Author: fapeeler Date: Thu Feb 17 17:03:35 2011 New Revision: 1071699 URL: http://svn.apache.org/viewvc?rev=1071699&view=rev Log: VCL-434
clean up of sql file for 2.2.1 release populated provisioningOSinstalltype table added 'id' columns to the insert statements Modified: incubator/vcl/trunk/mysql/update-2.2.1.sql Modified: incubator/vcl/trunk/mysql/update-2.2.1.sql URL: http://svn.apache.org/viewvc/incubator/vcl/trunk/mysql/update-2.2.1.sql?rev=1071699&r1=1071698&r2=1071699&view=diff ============================================================================== --- incubator/vcl/trunk/mysql/update-2.2.1.sql (original) +++ incubator/vcl/trunk/mysql/update-2.2.1.sql Thu Feb 17 17:03:35 2011 @@ -211,7 +211,10 @@ CREATE TABLE IF NOT EXISTS `provisioning -- Inserts for table `module` -- -INSERT IGNORE INTO `module` (`name`, `prettyname`, `description`, `perlpackage`) VALUES ('provisioning_vbox', 'Virtual Box Provisioning Module', '', 'VCL::Module::Provisioning::vbox'); +INSERT IGNORE INTO `module` (`id`, `name`, `prettyname`, `description`, `perlpackage`) VALUES +('22, 'state_image', 'VCL Image State Module', '', 'VCL::image'), +('23', 'base', 'VCL Base Module', '', 'VCL::Module'), +('24', 'provisioning_vbox', 'Virtual Box Provisioning Module', '', 'VCL::Module::Provisioning::vbox'); -- -------------------------------------------------------- @@ -219,7 +222,8 @@ INSERT IGNORE INTO `module` (`name`, `pr -- Inserts for table `provisioning` -- -INSERT IGNORE INTO `provisioning` (`name`, `prettyname`, `moduleid`) VALUES ('vbox', 'Virtual Box', (SELECT `id` FROM `module` WHERE `name` LIKE 'provisioning_vbox')); +INSERT IGNORE INTO `provisioning` (`id`, `name`, `prettyname`, `moduleid`) VALUES +('8', 'vbox', 'Virtual Box', (SELECT `id` FROM `module` WHERE `name` LIKE 'provisioning_vbox')); -- -------------------------------------------------------- @@ -227,7 +231,7 @@ INSERT IGNORE INTO `provisioning` (`name -- Inserts for table `OSinstalltype` -- -INSERT IGNORE INTO `OSinstalltype` (`name`) VALUES ('vbox'); +INSERT IGNORE INTO `OSinstalltype` (`id`, `name`) VALUES ('5', 'vbox'); -- -------------------------------------------------------- -- -------------------------------------------------------- @@ -235,9 +239,16 @@ INSERT IGNORE INTO `OSinstalltype` (`nam -- -- Inserts for table `provisioningOSinstalltype` -- - -INSERT IGNORE INTO `provisioningOSinstalltype` (`provisioningid`, `OSinstalltypeid`) VALUES -((SELECT `id` FROM `provisioning` WHERE `name` LIKE 'vbox' ), (SELECT `id` FROM `OSinstalltype` WHERE `name` LIKE 'vbox'`)); +INSERT IGNORE INTO `provisioningOSinstalltype` (`provisioningid`, `OSinstalltypeid`) VALUES +(1, 1), +(5, 1), +(6, 1), +(1, 2), +(5, 2), +(6, 2), +(3, 3), +(7, 4), +(8, 5); -- -------------------------------------------------------- --