Changeset 9969 for trunk/modules/boonex/ads/install/sql/install.sql
- Timestamp:
- 04/06/09 03:52:46 (3 years ago)
- File:
-
- 1 edited
-
trunk/modules/boonex/ads/install/sql/install.sql (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
-
trunk/modules/boonex/ads/install/sql/install.sql
r9964 r9969 299 299 SET @iLevelPromotion := 3; 300 300 301 INSERT INTO ` MemActions` VALUES (NULL, 'ads view', NULL);301 INSERT INTO `sys_acl_actions` VALUES (NULL, 'ads view', NULL); 302 302 SET @iAction := LAST_INSERT_ID(); 303 INSERT INTO ` MemLevelActions` (`IDLevel`, `IDAction`) VALUES303 INSERT INTO `sys_acl_matrix` (`IDLevel`, `IDAction`) VALUES 304 304 (@iLevelNonMember, @iAction), (@iLevelStandard, @iAction), (@iLevelPromotion, @iAction); 305 305 306 INSERT INTO ` MemActions` VALUES (NULL, 'ads browse', NULL);306 INSERT INTO `sys_acl_actions` VALUES (NULL, 'ads browse', NULL); 307 307 SET @iAction := LAST_INSERT_ID(); 308 INSERT INTO ` MemLevelActions` (`IDLevel`, `IDAction`) VALUES308 INSERT INTO `sys_acl_matrix` (`IDLevel`, `IDAction`) VALUES 309 309 (@iLevelNonMember, @iAction), (@iLevelStandard, @iAction), (@iLevelPromotion, @iAction); 310 310 311 INSERT INTO ` MemActions` VALUES (NULL, 'ads search', NULL);311 INSERT INTO `sys_acl_actions` VALUES (NULL, 'ads search', NULL); 312 312 SET @iAction := LAST_INSERT_ID(); 313 INSERT INTO ` MemLevelActions` (`IDLevel`, `IDAction`) VALUES313 INSERT INTO `sys_acl_matrix` (`IDLevel`, `IDAction`) VALUES 314 314 (@iLevelNonMember, @iAction), (@iLevelStandard, @iAction), (@iLevelPromotion, @iAction); 315 315 316 INSERT INTO ` MemActions` VALUES (NULL, 'ads add', NULL);316 INSERT INTO `sys_acl_actions` VALUES (NULL, 'ads add', NULL); 317 317 SET @iAction := LAST_INSERT_ID(); 318 INSERT INTO ` MemLevelActions` (`IDLevel`, `IDAction`) VALUES318 INSERT INTO `sys_acl_matrix` (`IDLevel`, `IDAction`) VALUES 319 319 (@iLevelStandard, @iAction), (@iLevelPromotion, @iAction); 320 320 321 INSERT INTO ` MemActions` VALUES (NULL, 'ads edit any ad', NULL);322 INSERT INTO ` MemActions` VALUES (NULL, 'ads delete any ad', NULL);323 INSERT INTO ` MemActions` VALUES (NULL, 'ads approving', NULL);321 INSERT INTO `sys_acl_actions` VALUES (NULL, 'ads edit any ad', NULL); 322 INSERT INTO `sys_acl_actions` VALUES (NULL, 'ads delete any ad', NULL); 323 INSERT INTO `sys_acl_actions` VALUES (NULL, 'ads approving', NULL); 324 324 325 325 INSERT INTO
Note: See TracChangeset
for help on using the changeset viewer.