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

Timestamp:

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

Author:

Andrey Prikaznov

Message:

 

File:

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

trunk/modules/boonex/events/install/sql/install.sql

@@ -152 +152 @@
 
 -- category objects
-INSERT INTO `sys_objects_categories` VALUES (NULL, 'bx_events', 'SELECT `Categories` FROM `[db_prefix]main` WHERE `ID` = {iID} AND `Status` = ''approved''');
-
-INSERT INTO `Categories` VALUES ('Events', '0', 'shared_photo', '0', 'active');
-
-INSERT INTO `Categories` VALUES ('Party', '0', 'bx_events', '0', 'active');
-INSERT INTO `Categories` VALUES ('Expedition', '0', 'bx_events', '0', 'active');
-INSERT INTO `Categories` VALUES ('Presentation', '0', 'bx_events', '0', 'active');
-INSERT INTO `Categories` VALUES ('Last Friday', '0', 'bx_events', '0', 'active');
-INSERT INTO `Categories` VALUES ('Birthday', '0', 'bx_events', '0', 'active');
-INSERT INTO `Categories` VALUES ('Exhibition', '0', 'bx_events', '0', 'active');
-INSERT INTO `Categories` VALUES ('Bushwalking', '0', 'bx_events', '0', 'active');
+INSERT INTO `sys_objects_categories` VALUES (NULL, 'bx_events', 'SELECT `sys_categories` FROM `[db_prefix]main` WHERE `ID` = {iID} AND `Status` = ''approved''');
+
+INSERT INTO `sys_categories` VALUES ('Events', '0', 'shared_photo', '0', 'active');
+
+INSERT INTO `sys_categories` VALUES ('Party', '0', 'bx_events', '0', 'active');
+INSERT INTO `sys_categories` VALUES ('Expedition', '0', 'bx_events', '0', 'active');
+INSERT INTO `sys_categories` VALUES ('Presentation', '0', 'bx_events', '0', 'active');
+INSERT INTO `sys_categories` VALUES ('Last Friday', '0', 'bx_events', '0', 'active');
+INSERT INTO `sys_categories` VALUES ('Birthday', '0', 'bx_events', '0', 'active');
+INSERT INTO `sys_categories` VALUES ('Exhibition', '0', 'bx_events', '0', 'active');
+INSERT INTO `sys_categories` VALUES ('Bushwalking', '0', 'bx_events', '0', 'active');
 
 -- users actions