Author: jfthomps
Date: Fri Sep 30 14:53:24 2011
New Revision: 1177687
URL: http://svn.apache.org/viewvc?rev=1177687&view=rev
Log:
VCL-344
local admin account make sure has full access
-added overlapResCount to usergroup inserts
-made admin user member of adminUsers, manageNewImages, and Specify End Time
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=1177687&r1=1177686&r2=1177687&view=diff
==============================================================================
--- incubator/vcl/trunk/mysql/vcl.sql (original)
+++ incubator/vcl/trunk/mysql/vcl.sql Fri Sep 30 14:53:24 2011
@@ -1678,18 +1678,21 @@ INSERT INTO `user` (`id`, `uid`, `unityi
-- Dumping data for table `usergroup`
--
-INSERT INTO `usergroup` (`id`, `name`, `affiliationid`, `ownerid`,
`editusergroupid`, `custom`, `courseroll`, `initialmaxtime`, `totalmaxtime`,
`maxextendtime`) VALUES
-(1, 'global', 1, 1, 1, 1, 0, 240, 360, 30),
-(3, 'adminUsers', 1, 1, 1, 1, 0, 480, 600, 180),
-(4, 'manageNewImages', 1, 1, 3, 1, 0, 240, 360, 30),
-(5, 'Specify End Time', 1, 1, 3, 1, 0, 240, 360, 30);
+INSERT INTO `usergroup` (`id`, `name`, `affiliationid`, `ownerid`,
`editusergroupid`, `custom`, `courseroll`, `initialmaxtime`, `totalmaxtime`,
`maxextendtime`, `overlapResCount`) VALUES
+(1, 'global', 1, 1, 1, 1, 0, 240, 360, 30, 0),
+(3, 'adminUsers', 1, 1, 1, 1, 0, 480, 600, 180, 50),
+(4, 'manageNewImages', 1, 1, 3, 1, 0, 240, 360, 30, 0),
+(5, 'Specify End Time', 1, 1, 3, 1, 0, 240, 360, 30, 0);
--
-- Dumping data for table `usergroupmembers`
--
INSERT INTO `usergroupmembers` (`userid`, `usergroupid`) VALUES
-(1, 1);
+(1, 1),
+(1, 3),
+(1, 4);
+(1, 5);
--
-- Dumping data for table `usergrouppriv`