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`


Reply via email to