Changeset 9969 for trunk/modules/boonex/events/install/sql/install.sql
- Timestamp:
- 04/06/09 03:52:46 (3 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/modules/boonex/events/install/sql/install.sql
r9968 r9969 215 215 SET @iLevelPromotion := 3; 216 216 217 INSERT INTO ` MemActions` VALUES (NULL, 'events view', NULL);218 SET @iAction := LAST_INSERT_ID(); 219 INSERT INTO ` MemLevelActions` (`IDLevel`, `IDAction`) VALUES217 INSERT INTO `sys_acl_actions` VALUES (NULL, 'events view', NULL); 218 SET @iAction := LAST_INSERT_ID(); 219 INSERT INTO `sys_acl_matrix` (`IDLevel`, `IDAction`) VALUES 220 220 (@iLevelNonMember, @iAction), (@iLevelStandard, @iAction), (@iLevelPromotion, @iAction); 221 221 222 INSERT INTO ` MemActions` VALUES (NULL, 'events browse', NULL);223 SET @iAction := LAST_INSERT_ID(); 224 INSERT INTO ` MemLevelActions` (`IDLevel`, `IDAction`) VALUES222 INSERT INTO `sys_acl_actions` VALUES (NULL, 'events browse', NULL); 223 SET @iAction := LAST_INSERT_ID(); 224 INSERT INTO `sys_acl_matrix` (`IDLevel`, `IDAction`) VALUES 225 225 (@iLevelNonMember, @iAction), (@iLevelStandard, @iAction), (@iLevelPromotion, @iAction); 226 226 227 INSERT INTO ` MemActions` VALUES (NULL, 'events search', NULL);228 SET @iAction := LAST_INSERT_ID(); 229 INSERT INTO ` MemLevelActions` (`IDLevel`, `IDAction`) VALUES227 INSERT INTO `sys_acl_actions` VALUES (NULL, 'events search', NULL); 228 SET @iAction := LAST_INSERT_ID(); 229 INSERT INTO `sys_acl_matrix` (`IDLevel`, `IDAction`) VALUES 230 230 (@iLevelNonMember, @iAction), (@iLevelStandard, @iAction), (@iLevelPromotion, @iAction); 231 231 232 INSERT INTO ` MemActions` VALUES (NULL, 'events add', NULL);233 SET @iAction := LAST_INSERT_ID(); 234 INSERT INTO ` MemLevelActions` (`IDLevel`, `IDAction`) VALUES232 INSERT INTO `sys_acl_actions` VALUES (NULL, 'events add', NULL); 233 SET @iAction := LAST_INSERT_ID(); 234 INSERT INTO `sys_acl_matrix` (`IDLevel`, `IDAction`) VALUES 235 235 (@iLevelStandard, @iAction), (@iLevelPromotion, @iAction); 236 236 237 INSERT INTO ` MemActions` VALUES (NULL, 'events edit any event', NULL);238 INSERT INTO ` MemActions` VALUES (NULL, 'events delete any event', NULL);239 INSERT INTO ` MemActions` VALUES (NULL, 'events mark as featured', NULL);240 INSERT INTO ` MemActions` VALUES (NULL, 'events approve', NULL);237 INSERT INTO `sys_acl_actions` VALUES (NULL, 'events edit any event', NULL); 238 INSERT INTO `sys_acl_actions` VALUES (NULL, 'events delete any event', NULL); 239 INSERT INTO `sys_acl_actions` VALUES (NULL, 'events mark as featured', NULL); 240 INSERT INTO `sys_acl_actions` VALUES (NULL, 'events approve', NULL); 241 241 242 242 -- alert handlers
Note: See TracChangeset
for help on using the changeset viewer.