Changeset 15704 for trunk/install

Timestamp:

11/28/11 01:06:42 (6 months ago)

Author:

Alexander Trofimov

Message:

Grid - selected and disabled rows

File:

• trunk/install/sql/v70.sql (modified) (6 diffs)

trunk/install/sql/v70.sql

@@ -1404 +1404 @@
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
---
--- Dumping data for table `sys_localization_strings`
---
-
--- --------------------------------------------------------
---
--- Table structure for table `sys_acl_actions`
---
+
+-- --------------------------------------------------------
+
 
 CREATE TABLE `sys_acl_actions` (
   `ID` smallint(5) unsigned NOT NULL auto_increment,
+  `Module` varchar(32) NOT NULL,
   `Name` varchar(255) NOT NULL default '',
   `AdditionalParamName` varchar(80) default NULL,
+  `Title` varchar(255) NOT NULL,
+  `Desc` text NOT NULL,
+  `Countable` tinyint(4) NOT NULL DEFAULT '0',
+  `DisabledForLevels` int(10) unsigned NOT NULL DEFAULT '3',
   PRIMARY KEY  (`ID`)
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
 
---
--- Dumping data for table `sys_acl_actions`
---
-
-INSERT INTO `sys_acl_actions` VALUES(1, 'send greetings', NULL);
-INSERT INTO `sys_acl_actions` VALUES(2, 'view profiles', NULL);
-INSERT INTO `sys_acl_actions` VALUES(3, 'vote', NULL);
-INSERT INTO `sys_acl_actions` VALUES(4, 'send messages', NULL);
-INSERT INTO `sys_acl_actions` VALUES(5, 'get other members emails', NULL);
-INSERT INTO `sys_acl_actions` VALUES(6, 'comments post', NULL);
-INSERT INTO `sys_acl_actions` VALUES(7, 'comments vote', NULL);
-INSERT INTO `sys_acl_actions` VALUES(8, 'comments edit own', NULL);
-INSERT INTO `sys_acl_actions` VALUES(9, 'comments remove own', NULL);
-
--- --------------------------------------------------------
-
---
--- Table structure for table `sys_acl_actions_track`
---
+INSERT INTO `sys_acl_actions` (`ID`, `Module`, `Name`, `AdditionalParamName`, `Title`, `Desc`, `Countable`, `DisabledForLevels`) VALUES
+(1, 'system', 'send greetings', NULL, '_sys_send_greetings', '', 1, 3),
+(2, 'system', 'view profiles', NULL, '_sys_view_profile', '', 1, 0),
+(3, 'system', 'vote', NULL, '_sys_vote', '', 0, 0),
+(4, 'system', 'send messages', NULL, '_sys_messages', '', 0, 3),
+(5, 'system', 'get other members emails', NULL, '_sys_get_email', '', 1, 3),
+(6, 'system', 'comments post', NULL, '_sys_comments_post', '', 0, 3),
+(7, 'system', 'comments vote', NULL, '_sys_comments_vote', '', 0, 3),
+(8, 'system', 'comments edit own', NULL, '_sys_comments_edit_own', '', 0, 3),
+(9, 'system', 'comments remove own', NULL, '_sys_comments_remove_own', '', 0, 3);
+
 
 CREATE TABLE `sys_acl_actions_track` (
@@ -1448 +1440 @@
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
---
--- Dumping data for table `sys_acl_actions_track`
---
-
-
--- --------------------------------------------------------
-
-
---
--- Table structure for table `sys_acl_matrix`
---
 
 CREATE TABLE `sys_acl_matrix` (
@@ -1470 +1451 @@
   PRIMARY KEY  (`IDLevel`,`IDAction`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
---
--- Dumping data for table `sys_acl_matrix`
---
 
 INSERT INTO `sys_acl_matrix` VALUES(1, 2, NULL, NULL, NULL, NULL, NULL);
@@ -1495 +1472 @@
 INSERT INTO `sys_acl_matrix` VALUES(3, 9, NULL, NULL, NULL, NULL, NULL);
 
--- --------------------------------------------------------
-
---
--- Table structure for table `sys_acl_level_prices`
---
 
 CREATE TABLE `sys_acl_level_prices` (
@@ -1510 +1482 @@
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
---
--- Dumping data for table `sys_acl_level_prices`
---
-
-
--- --------------------------------------------------------
-
---
--- Table structure for table `sys_acl_levels`
---
 
 CREATE TABLE `sys_acl_levels` (
@@ -1537 +1499 @@
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
 
---
--- Dumping data for table `sys_acl_levels`
---
-
-INSERT INTO `sys_acl_levels` VALUES(1, 'Non-member', 'non-member.png', '', 'yes', 'no', 'no', 1);
-INSERT INTO `sys_acl_levels` VALUES(2, 'Standard',  'member.png', '', 'yes', 'no', 'no', 2);
-INSERT INTO `sys_acl_levels` VALUES(3, 'Promotion',  'promotion.png', '', 'yes', 'no', 'no', 3);
+INSERT INTO `sys_acl_levels` (`ID`, `Name`, `Icon`, `Description`, `Active`, `Purchasable`, `Removable`, `QuotaSize`, `QuotaNumber`, `QuotaMaxFileSize`, `Order`) VALUES
+(1, 'Non-member', 'non-member.png', '', 'yes', 'no', 'no', 1500000, 200, 0, 1),
+(2, 'Authenticated', 'authenticated.png', '', 'yes', 'no', 'no', 0, 0, 0, 2),
+(3, 'Standard', 'member.png', '', 'yes', 'no', 'no', 5000000, 5, 2000000, 3),
+(4, 'Premium', 'premium.png', '', 'yes', 'yes', 'no', 0, 0, 0, 4),
+(5, 'Moderator', 'moderator.png', '', 'yes', 'no', 'no', 0, 0, 0, 5),
+(6, 'Administrator', 'administrator.png', '', 'yes', 'no', 'no', 0, 0, 0, 5);
+
 
 -- --------------------------------------------------------