You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@vcl.apache.org by jf...@apache.org on 2009/09/11 15:13:45 UTC
svn commit: r813818 - /incubator/vcl/trunk/mysql/vcl.sql
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`
--