Author: arkurth
Date: Tue Oct 4 14:32:00 2011
New Revision: 1178816
URL: http://svn.apache.org/viewvc?rev=1178816&view=rev
Log:
VCL-30
Added columns to:
-connectmethod table: protocol, servicename, startupscript
-vmprofile table: virtualdiskpath
Modified:
incubator/vcl/trunk/mysql/update-vcl.sql
incubator/vcl/trunk/mysql/vcl.sql
Modified: incubator/vcl/trunk/mysql/update-vcl.sql
URL:
http://svn.apache.org/viewvc/incubator/vcl/trunk/mysql/update-vcl.sql?rev=1178816&r1=1178815&r2=1178816&view=diff
==============================================================================
--- incubator/vcl/trunk/mysql/update-vcl.sql (original)
+++ incubator/vcl/trunk/mysql/update-vcl.sql Tue Oct 4 14:32:00 2011
@@ -251,9 +251,12 @@ CREATE TABLE IF NOT EXISTS `connectmetho
`id` tinyint(3) unsigned NOT NULL auto_increment,
`name` varchar(80) NOT NULL,
`description` varchar(255) NOT NULL,
+ `protocol` varchar(32) NOT NULL,
`port` smallint(5) unsigned NOT NULL,
`connecttext` text NOT NULL,
- PRIMARY KEY (`id`)
+ `servicename` varchar(32) NOT NULL,
+ `startupscript` varchar(256) DEFAULT NULL,
+ PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
@@ -272,7 +275,7 @@ CREATE TABLE IF NOT EXISTS `connectmetho
KEY `connectmethodid` (`connectmethodid`),
KEY `OStypeid` (`OStypeid`),
KEY `OSid` (`OSid`),
- KEY `imageid` (`imageid`)
+ KEY `imagerevisionid` (`imagerevisionid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
@@ -502,6 +505,7 @@ CALL AddIndexIfNotExists('vmhost', 'vmpr
CALL DropColumnIfExists('vmprofile', 'nasshare');
CALL AddColumnIfNotExists('vmprofile', 'repositorypath', "varchar(128) default
NULL AFTER imageid");
+CALL AddColumnIfNotExists('vmprofile', 'virtualdiskpath', "varchar(128)
default NULL AFTER imageid");
CALL AddColumnIfNotExists('vmprofile', 'virtualswitch2', "varchar(80) NULL
default NULL AFTER `virtualswitch1`");
CALL AddColumnIfNotExists('vmprofile', 'virtualswitch3', "varchar(80) NULL
default NULL AFTER `virtualswitch2`");
CALL AddColumnIfNotExists('vmprofile', 'vmware_mac_eth0_generated',
"tinyint(1) NOT NULL default '0'");
Modified: incubator/vcl/trunk/mysql/vcl.sql
URL:
http://svn.apache.org/viewvc/incubator/vcl/trunk/mysql/vcl.sql?rev=1178816&r1=1178815&r2=1178816&view=diff
==============================================================================
--- incubator/vcl/trunk/mysql/vcl.sql (original)
+++ incubator/vcl/trunk/mysql/vcl.sql Tue Oct 4 14:32:00 2011
@@ -297,9 +297,12 @@ CREATE TABLE IF NOT EXISTS `connectmetho
`id` tinyint(3) unsigned NOT NULL auto_increment,
`name` varchar(80) NOT NULL,
`description` varchar(255) NOT NULL,
+ `protocol` varchar(32) NOT NULL,
`port` smallint(5) unsigned NOT NULL,
`connecttext` text NOT NULL,
- PRIMARY KEY (`id`)
+ `servicename` varchar(32) NOT NULL,
+ `startupscript` varchar(256) DEFAULT NULL,
+ PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
@@ -1190,6 +1193,7 @@ CREATE TABLE IF NOT EXISTS `vmprofile` (
`imageid` smallint(5) unsigned NOT NULL,
`repositorypath` varchar(128) default NULL,
`datastorepath` varchar(128) NOT NULL,
+ `virtualdiskpath` varchar(128) default NULL,
`vmpath` varchar(128) default NULL,
`virtualswitch0` varchar(80) NOT NULL default 'VMnet0',
`virtualswitch1` varchar(80) NOT NULL default 'VMnet2',
