Author: jfthomps
Date: Thu Mar 10 18:37:55 2011
New Revision: 1080309
URL: http://svn.apache.org/viewvc?rev=1080309&view=rev
Log:
VCL-434
added usergrouppriv and usergroupprivtype tables
Modified:
incubator/vcl/trunk/mysql/vcl.sql
Modified: incubator/vcl/trunk/mysql/vcl.sql
URL:
http://svn.apache.org/viewvc/incubator/vcl/trunk/mysql/vcl.sql?rev=1080309&r1=1080308&r2=1080309&view=diff
==============================================================================
--- incubator/vcl/trunk/mysql/vcl.sql (original)
+++ incubator/vcl/trunk/mysql/vcl.sql Thu Mar 10 18:37:55 2011
@@ -979,6 +979,31 @@ CREATE TABLE IF NOT EXISTS `usergroupmem
-- --------------------------------------------------------
--
+-- Table structure for table `usergrouppriv`
+--
+
+CREATE TABLE IF NOT EXISTS `usergrouppriv` (
+ `usergroupid` smallint(5) unsigned NOT NULL,
+ `userprivtypeid` tinyint(3) unsigned NOT NULL,
+ UNIQUE KEY `usergroupid` (`usergroupid`,`userprivtypeid`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `usergroupprivtype`
+--
+
+CREATE TABLE IF NOT EXISTS `usergroupprivtype` (
+ `id` tinyint(3) unsigned NOT NULL auto_increment,
+ `name` varchar(50) NOT NULL,
+ `help` text,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
+-- --------------------------------------------------------
+
+--
-- Table structure for table `userpriv`
--
@@ -1536,6 +1561,42 @@ INSERT INTO `usergroupmembers` (`userid`
(1, 1);
--
+-- Dumping data for table `usergrouppriv`
+--
+
+INSERT INTO `usergrouppriv` (`usergroupid`, `userprivtypeid`) VALUES
+(3, 1),
+(3, 2),
+(3, 3),
+(3, 4),
+(3, 5),
+(3, 6),
+(3, 7),
+(3, 8),
+(3, 9),
+(3, 10),
+(3, 11),
+(3, 12);
+
+--
+-- Dumping data for table `usergroupprivtype`
+--
+
+INSERT INTO `usergroupprivtype` (`id`, `name`, `help`) VALUES
+(1, 'Manage Additional User Group Permissions', 'This gives users in the group
access to this portion of the site.'),
+(2, 'Manage Block Allocations', 'Grants the ability to create, accept, and
reject block allocations.'),
+(3, 'Set Overlapping Reservation Count', 'Grants the ability to control how
many overlapping reservations users in a given user group can make.'),
+(4, 'View Debug Information', 'Allows user to see various verbose/debugging
information while using the web site.'),
+(5, 'Manage VM Profiles', 'Grants the ability to manage VM profiles under the
Virtual Hosts section of the site.'),
+(6, 'Search Tools', 'Grants the ability to see the Search Tools section of the
site.'),
+(7, 'Schedule Site Maintenance', 'Grants the ability to schedule and manage
site maintenance for the web site.'),
+(8, 'View Dashboard (global)', 'The dashboard displays real time information
about the VCL system. This option grants access to view the dashboard with
information displayed for users from all affiliations.'),
+(9, 'View Dashboard (affiliation only)', 'The dashboard displays real time
information about the VCL system. This option grants access to view the
dashboard with information displayed only about users matching the affiliation
of the currently logged in user.'),
+(10, 'User Lookup (global)', 'The User Lookup tool allows a user to see
various information about VCL users. This grants the use of the tool for all
affiliations.'),
+(11, 'User Lookup (affiliation only)', 'The User Lookup tool allows a user to
see various information about VCL users. This grants the use of the tool for
looking up users of the same affiliation as the logged in user.'),
+(12, 'View Statistics by Affiliation', 'Grants the ability to see statistics
for affiliations that do not match the affiliation of the logged in user.');
+
+--
-- Dumping data for table `userpriv`
--
