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

Timestamp:

04/06/09 03:52:46 (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

@@ -232 +232 @@
 SET @iLevelPromotion := 3;
 
-INSERT INTO `MemActions` VALUES (NULL, 'blog view', NULL);
-SET @iAction := LAST_INSERT_ID();
-INSERT INTO `MemLevelActions` (`IDLevel`, `IDAction`) VALUES 
-    (@iLevelNonMember, @iAction), (@iLevelStandard, @iAction), (@iLevelPromotion, @iAction);
-
-INSERT INTO `MemActions` VALUES (NULL, 'blog post view', NULL);
-SET @iAction := LAST_INSERT_ID();
-INSERT INTO `MemLevelActions` (`IDLevel`, `IDAction`) VALUES 
-    (@iLevelNonMember, @iAction), (@iLevelStandard, @iAction), (@iLevelPromotion, @iAction);
-
-INSERT INTO `MemActions` VALUES (NULL, 'blogs browse', NULL);
-SET @iAction := LAST_INSERT_ID();
-INSERT INTO `MemLevelActions` (`IDLevel`, `IDAction`) VALUES 
-    (@iLevelNonMember, @iAction), (@iLevelStandard, @iAction), (@iLevelPromotion, @iAction);
-
-INSERT INTO `MemActions` VALUES (NULL, 'blogs posts browse', NULL);
-SET @iAction := LAST_INSERT_ID();
-INSERT INTO `MemLevelActions` (`IDLevel`, `IDAction`) VALUES 
-    (@iLevelNonMember, @iAction), (@iLevelStandard, @iAction), (@iLevelPromotion, @iAction);
-
-INSERT INTO `MemActions` VALUES (NULL, 'blog post search', NULL);
-SET @iAction := LAST_INSERT_ID();
-INSERT INTO `MemLevelActions` (`IDLevel`, `IDAction`) VALUES 
-    (@iLevelNonMember, @iAction), (@iLevelStandard, @iAction), (@iLevelPromotion, @iAction);
-
-INSERT INTO `MemActions` VALUES (NULL, 'blog post add', NULL);
-SET @iAction := LAST_INSERT_ID();
-INSERT INTO `MemLevelActions` (`IDLevel`, `IDAction`) VALUES 
+INSERT INTO `sys_acl_actions` VALUES (NULL, 'blog view', NULL);
+SET @iAction := LAST_INSERT_ID();
+INSERT INTO `sys_acl_matrix` (`IDLevel`, `IDAction`) VALUES 
+    (@iLevelNonMember, @iAction), (@iLevelStandard, @iAction), (@iLevelPromotion, @iAction);
+
+INSERT INTO `sys_acl_actions` VALUES (NULL, 'blog post view', NULL);
+SET @iAction := LAST_INSERT_ID();
+INSERT INTO `sys_acl_matrix` (`IDLevel`, `IDAction`) VALUES 
+    (@iLevelNonMember, @iAction), (@iLevelStandard, @iAction), (@iLevelPromotion, @iAction);
+
+INSERT INTO `sys_acl_actions` VALUES (NULL, 'blogs browse', NULL);
+SET @iAction := LAST_INSERT_ID();
+INSERT INTO `sys_acl_matrix` (`IDLevel`, `IDAction`) VALUES 
+    (@iLevelNonMember, @iAction), (@iLevelStandard, @iAction), (@iLevelPromotion, @iAction);
+
+INSERT INTO `sys_acl_actions` VALUES (NULL, 'blogs posts browse', NULL);
+SET @iAction := LAST_INSERT_ID();
+INSERT INTO `sys_acl_matrix` (`IDLevel`, `IDAction`) VALUES 
+    (@iLevelNonMember, @iAction), (@iLevelStandard, @iAction), (@iLevelPromotion, @iAction);
+
+INSERT INTO `sys_acl_actions` VALUES (NULL, 'blog post search', NULL);
+SET @iAction := LAST_INSERT_ID();
+INSERT INTO `sys_acl_matrix` (`IDLevel`, `IDAction`) VALUES 
+    (@iLevelNonMember, @iAction), (@iLevelStandard, @iAction), (@iLevelPromotion, @iAction);
+
+INSERT INTO `sys_acl_actions` VALUES (NULL, 'blog post add', NULL);
+SET @iAction := LAST_INSERT_ID();
+INSERT INTO `sys_acl_matrix` (`IDLevel`, `IDAction`) VALUES 
     (@iLevelStandard, @iAction), (@iLevelPromotion, @iAction);
 
-INSERT INTO `MemActions` VALUES (NULL, 'blog posts edit any post', NULL);
-INSERT INTO `MemActions` VALUES (NULL, 'blog posts delete any post', NULL);
-INSERT INTO `MemActions` VALUES (NULL, 'blog posts approving', NULL);
+INSERT INTO `sys_acl_actions` VALUES (NULL, 'blog posts edit any post', NULL);
+INSERT INTO `sys_acl_actions` VALUES (NULL, 'blog posts delete any post', NULL);
+INSERT INTO `sys_acl_actions` VALUES (NULL, 'blog posts approving', NULL);
 
 -- member menu