You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@vcl.apache.org by fa...@apache.org on 2011/02/17 18:03:35 UTC
svn commit: r1071699 - /incubator/vcl/trunk/mysql/update-2.2.1.sql
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);
-- --------------------------------------------------------
--