Changeset 9969 for trunk/modules/boonex/store/install/sql/install.sql
- Timestamp:
- 04/06/09 03:52:46 (3 years ago)
- File:
-
- 1 edited
-
trunk/modules/boonex/store/install/sql/install.sql (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
-
trunk/modules/boonex/store/install/sql/install.sql
r9968 r9969 184 184 SET @iLevelPromotion := 3; 185 185 186 INSERT INTO ` MemActions` VALUES (NULL, 'store view product', NULL);187 SET @iAction := LAST_INSERT_ID(); 188 INSERT INTO ` MemLevelActions` (`IDLevel`, `IDAction`) VALUES186 INSERT INTO `sys_acl_actions` VALUES (NULL, 'store view product', NULL); 187 SET @iAction := LAST_INSERT_ID(); 188 INSERT INTO `sys_acl_matrix` (`IDLevel`, `IDAction`) VALUES 189 189 (@iLevelNonMember, @iAction), (@iLevelStandard, @iAction), (@iLevelPromotion, @iAction); 190 190 191 INSERT INTO ` MemActions` VALUES (NULL, 'store browse', NULL);192 SET @iAction := LAST_INSERT_ID(); 193 INSERT INTO ` MemLevelActions` (`IDLevel`, `IDAction`) VALUES191 INSERT INTO `sys_acl_actions` VALUES (NULL, 'store browse', NULL); 192 SET @iAction := LAST_INSERT_ID(); 193 INSERT INTO `sys_acl_matrix` (`IDLevel`, `IDAction`) VALUES 194 194 (@iLevelNonMember, @iAction), (@iLevelStandard, @iAction), (@iLevelPromotion, @iAction); 195 195 196 INSERT INTO ` MemActions` VALUES (NULL, 'store search', NULL);197 SET @iAction := LAST_INSERT_ID(); 198 INSERT INTO ` MemLevelActions` (`IDLevel`, `IDAction`) VALUES196 INSERT INTO `sys_acl_actions` VALUES (NULL, 'store search', NULL); 197 SET @iAction := LAST_INSERT_ID(); 198 INSERT INTO `sys_acl_matrix` (`IDLevel`, `IDAction`) VALUES 199 199 (@iLevelNonMember, @iAction), (@iLevelStandard, @iAction), (@iLevelPromotion, @iAction); 200 200 201 INSERT INTO ` MemActions` VALUES (NULL, 'store add product', NULL);202 SET @iAction := LAST_INSERT_ID(); 203 INSERT INTO ` MemLevelActions` (`IDLevel`, `IDAction`) VALUES201 INSERT INTO `sys_acl_actions` VALUES (NULL, 'store add product', NULL); 202 SET @iAction := LAST_INSERT_ID(); 203 INSERT INTO `sys_acl_matrix` (`IDLevel`, `IDAction`) VALUES 204 204 (@iLevelStandard, @iAction), (@iLevelPromotion, @iAction); 205 205 206 INSERT INTO ` MemActions` VALUES (NULL, 'store edit any product', NULL);207 INSERT INTO ` MemActions` VALUES (NULL, 'store delete any product', NULL);208 INSERT INTO ` MemActions` VALUES (NULL, 'store mark as featured', NULL);209 INSERT INTO ` MemActions` VALUES (NULL, 'store approve product', NULL);206 INSERT INTO `sys_acl_actions` VALUES (NULL, 'store edit any product', NULL); 207 INSERT INTO `sys_acl_actions` VALUES (NULL, 'store delete any product', NULL); 208 INSERT INTO `sys_acl_actions` VALUES (NULL, 'store mark as featured', NULL); 209 INSERT INTO `sys_acl_actions` VALUES (NULL, 'store approve product', NULL); 210 210 211 211 -- alert handlers
Note: See TracChangeset
for help on using the changeset viewer.