Author: fapeeler
Date: Mon Feb 14 20:38:33 2011
New Revision: 1070655
URL: http://svn.apache.org/viewvc?rev=1070655&view=rev
Log:
VCL-434
Updating core vcl.sql file to match schema updates.
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=1070655&r1=1070654&r2=1070655&view=diff
==============================================================================
--- incubator/vcl/trunk/mysql/vcl.sql (original)
+++ incubator/vcl/trunk/mysql/vcl.sql Mon Feb 14 20:38:33 2011
@@ -1337,7 +1337,8 @@ INSERT INTO `OSinstalltype` (`id`, `name
(2, 'kickstart'),
(3, 'none'),
(1, 'partimage'),
-(4, 'vmware');
+(4, 'vmware'),
+(5, 'vbox');
--
-- Dumping data for table `OStype`
@@ -1393,6 +1394,8 @@ INSERT INTO `provisioningOSinstalltype`
(6, 2),
(3, 3),
(7, 4);
+INSERT IGNORE INTO `provisioningOSinstalltype` (`provisioningid`,
`OSinstalltypeid`) VALUES
+((SELECT `id` FROM `provisioning` WHERE `name` LIKE 'vbox' ), (SELECT `id`
FROM `OSinstalltype` WHERE `name` LIKE 'vbox'`));
--
-- Dumping data for table `resource`
