Changeset 9985 for trunk/modules/boonex/blogs/install/sql/install.sql

Timestamp:

04/06/09 23:30:15 (3 years ago)

Author:

Andrey Prikaznov

Message:

 

File:

• trunk/modules/boonex/blogs/install/sql/install.sql (modified) (1 diff)

trunk/modules/boonex/blogs/install/sql/install.sql

@@ -123 +123 @@
 INSERT INTO `sys_admin_menu` (`ID`, `Title`, `Url`, `Desc`, `Check`, `Order`, `Categ`, `Icon`) VALUES(NULL, 'Articles', '../modules/boonex/blogs/post_mod_blog.php?action=show_member_blog&ownerID=0', 'Admin blogs (as articles)', '', @iAMOrder3+1, 4, 'modules/boonex/blogs/|blogs.gif');
 
-INSERT INTO `Categories` (`Category`, `ID`, `Type`, `Owner`, `Status`) VALUES('Baby Blogs', 0, 'bx_blogs', 0, 'active');
-INSERT INTO `Categories` (`Category`, `ID`, `Type`, `Owner`, `Status`) VALUES('Blogging for Money', 0, 'bx_blogs', 0, 'active');
-INSERT INTO `Categories` (`Category`, `ID`, `Type`, `Owner`, `Status`) VALUES('Books', 0, 'bx_blogs', 0, 'active');
-INSERT INTO `Categories` (`Category`, `ID`, `Type`, `Owner`, `Status`) VALUES('City Blogs', 0, 'bx_blogs', 0, 'active');
-INSERT INTO `Categories` (`Category`, `ID`, `Type`, `Owner`, `Status`) VALUES('Dating and Personals', 0, 'bx_blogs', 0, 'active');
-INSERT INTO `Categories` (`Category`, `ID`, `Type`, `Owner`, `Status`) VALUES('Entertainment Blogs', 0, 'bx_blogs', 0, 'active');
-INSERT INTO `Categories` (`Category`, `ID`, `Type`, `Owner`, `Status`) VALUES('Food Blogs', 0, 'bx_blogs', 0, 'active');
-INSERT INTO `Categories` (`Category`, `ID`, `Type`, `Owner`, `Status`) VALUES('Games', 0, 'bx_blogs', 0, 'active');
-INSERT INTO `Categories` (`Category`, `ID`, `Type`, `Owner`, `Status`) VALUES('Health', 0, 'bx_blogs', 0, 'active');
-INSERT INTO `Categories` (`Category`, `ID`, `Type`, `Owner`, `Status`) VALUES('Holidays', 0, 'bx_blogs', 0, 'active');
-INSERT INTO `Categories` (`Category`, `ID`, `Type`, `Owner`, `Status`) VALUES('Lifestyle', 0, 'bx_blogs', 0, 'active');
-INSERT INTO `Categories` (`Category`, `ID`, `Type`, `Owner`, `Status`) VALUES('Movies', 0, 'bx_blogs', 0, 'active');
-INSERT INTO `Categories` (`Category`, `ID`, `Type`, `Owner`, `Status`) VALUES('Music', 0, 'bx_blogs', 0, 'active');
-INSERT INTO `Categories` (`Category`, `ID`, `Type`, `Owner`, `Status`) VALUES('Politics', 0, 'bx_blogs', 0, 'active');
-INSERT INTO `Categories` (`Category`, `ID`, `Type`, `Owner`, `Status`) VALUES('Tech News', 0, 'bx_blogs', 0, 'active');
-INSERT INTO `Categories` (`Category`, `ID`, `Type`, `Owner`, `Status`) VALUES('Videos', 0, 'bx_blogs', 0, 'active');
-
-
-INSERT INTO `sys_objects_categories` (`ID`, `ObjectName`, `Query`) VALUES(NULL, 'bx_blogs', 'SELECT `Categories` FROM `[db_prefix]_posts` WHERE `PostID` = {iID} AND `PostStatus` = ''approval''');
+INSERT INTO `sys_categories` (`Category`, `ID`, `Type`, `Owner`, `Status`) VALUES('Baby Blogs', 0, 'bx_blogs', 0, 'active');
+INSERT INTO `sys_categories` (`Category`, `ID`, `Type`, `Owner`, `Status`) VALUES('Blogging for Money', 0, 'bx_blogs', 0, 'active');
+INSERT INTO `sys_categories` (`Category`, `ID`, `Type`, `Owner`, `Status`) VALUES('Books', 0, 'bx_blogs', 0, 'active');
+INSERT INTO `sys_categories` (`Category`, `ID`, `Type`, `Owner`, `Status`) VALUES('City Blogs', 0, 'bx_blogs', 0, 'active');
+INSERT INTO `sys_categories` (`Category`, `ID`, `Type`, `Owner`, `Status`) VALUES('Dating and Personals', 0, 'bx_blogs', 0, 'active');
+INSERT INTO `sys_categories` (`Category`, `ID`, `Type`, `Owner`, `Status`) VALUES('Entertainment Blogs', 0, 'bx_blogs', 0, 'active');
+INSERT INTO `sys_categories` (`Category`, `ID`, `Type`, `Owner`, `Status`) VALUES('Food Blogs', 0, 'bx_blogs', 0, 'active');
+INSERT INTO `sys_categories` (`Category`, `ID`, `Type`, `Owner`, `Status`) VALUES('Games', 0, 'bx_blogs', 0, 'active');
+INSERT INTO `sys_categories` (`Category`, `ID`, `Type`, `Owner`, `Status`) VALUES('Health', 0, 'bx_blogs', 0, 'active');
+INSERT INTO `sys_categories` (`Category`, `ID`, `Type`, `Owner`, `Status`) VALUES('Holidays', 0, 'bx_blogs', 0, 'active');
+INSERT INTO `sys_categories` (`Category`, `ID`, `Type`, `Owner`, `Status`) VALUES('Lifestyle', 0, 'bx_blogs', 0, 'active');
+INSERT INTO `sys_categories` (`Category`, `ID`, `Type`, `Owner`, `Status`) VALUES('Movies', 0, 'bx_blogs', 0, 'active');
+INSERT INTO `sys_categories` (`Category`, `ID`, `Type`, `Owner`, `Status`) VALUES('Music', 0, 'bx_blogs', 0, 'active');
+INSERT INTO `sys_categories` (`Category`, `ID`, `Type`, `Owner`, `Status`) VALUES('Politics', 0, 'bx_blogs', 0, 'active');
+INSERT INTO `sys_categories` (`Category`, `ID`, `Type`, `Owner`, `Status`) VALUES('Tech News', 0, 'bx_blogs', 0, 'active');
+INSERT INTO `sys_categories` (`Category`, `ID`, `Type`, `Owner`, `Status`) VALUES('Videos', 0, 'bx_blogs', 0, 'active');
+
+
+INSERT INTO `sys_objects_categories` (`ID`, `ObjectName`, `Query`) VALUES(NULL, 'bx_blogs', 'SELECT `sys_categories` FROM `[db_prefix]_posts` WHERE `PostID` = {iID} AND `PostStatus` = ''approval''');
 
 INSERT INTO `sys_options_cats` VALUES(NULL, 'Blogs', 9);