Author: jfthomps Date: Fri Sep 11 13:13:45 2009 New Revision: 813818 URL: http://svn.apache.org/viewvc?rev=813818&view=rev Log: VCL-184
changed computerloadlog.id from mediumint to int changed vmprofile.username length from 32 to 80 changed vmprofile.password length from 128 to 256 added keys to vmprofile table: vmtypeid (vmtypeid, imageid) imageid (imageid) added schema-version entry to variable table 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=813818&r1=813817&r2=813818&view=diff ============================================================================== --- incubator/vcl/trunk/mysql/vcl.sql (original) +++ incubator/vcl/trunk/mysql/vcl.sql Fri Sep 11 13:13:45 2009 @@ -256,7 +256,7 @@ -- CREATE TABLE IF NOT EXISTS `computerloadlog` ( - `id` mediumint(12) unsigned NOT NULL auto_increment, + `id` int(12) unsigned NOT NULL auto_increment, `reservationid` mediumint(8) unsigned NOT NULL, `computerid` smallint(8) unsigned NOT NULL, `loadstateid` smallint(8) unsigned default NULL, @@ -992,9 +992,11 @@ `virtualswitch0` varchar(80) NOT NULL default 'VMnet0', `virtualswitch1` varchar(80) NOT NULL default 'VMnet2', `vmdisk` enum('localdisk','networkdisk') NOT NULL default 'localdisk', - `username` varchar(32) NULL default NULL, - `password` varchar(128) NULL default NULL, - PRIMARY KEY (`id`) + `username` varchar(80) NULL default NULL, + `password` varchar(256) NULL default NULL, + PRIMARY KEY (`id`), + KEY `vmtypeid` (`vmtypeid`,`imageid`), + KEY `imageid` (`imageid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- @@ -1497,6 +1499,13 @@ (7, 'userGrant'); -- +-- Dumping data for table `variable` +-- + +INSERT INTO `variable` (`id`, `name`, `serialization`, `value`) VALUES +(1, 'schema-version', 'none', '1'); + +-- -- Dumping data for table `vmprofile` --