Author: jfthomps
Date: Tue Dec 21 17:38:55 2010
New Revision: 1051575

URL: http://svn.apache.org/viewvc?rev=1051575&view=rev
Log:
VCL-405
create provisioningOSinstalltype table to map provisioning methods to 
OSinstalltypes

table added along with data

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=1051575&r1=1051574&r2=1051575&view=diff
==============================================================================
--- incubator/vcl/trunk/mysql/vcl.sql (original)
+++ incubator/vcl/trunk/mysql/vcl.sql Tue Dec 21 17:38:55 2010
@@ -626,6 +626,18 @@ CREATE TABLE IF NOT EXISTS `provisioning
 
 -- --------------------------------------------------------
 
+--
+-- Table structure for table `provisioningOSinstalltype`
+--
+
+CREATE TABLE IF NOT EXISTS `provisioningOSinstalltype` (
+  `provisioningid` smallint(5) unsigned NOT NULL,
+  `OSinstalltypeid` tinyint(3) unsigned NOT NULL,
+  PRIMARY KEY  (`provisioningid`,`OSinstalltypeid`)
+) ENGINE=InnoDB  DEFAULT CHARSET=latin1;
+
+-- --------------------------------------------------------
+
 -- 
 -- Table structure for table `querylog`
 -- 
@@ -1366,6 +1378,20 @@ INSERT INTO `provisioning` (`id`, `name`
 (6, 'xcat_2x', 'xCAT 2.x', 20),
 (7, 'vmware', 'VMware', 21);
 
+--
+-- Dumping data for table `provisioningOSinstalltype`
+--
+
+INSERT INTO `provisioningOSinstalltype` (`provisioningid`, `OSinstalltypeid`) 
VALUES
+(1, 1),
+(5, 1),
+(6, 1),
+(1, 2),
+(5, 2),
+(6, 2),
+(3, 3),
+(7, 4);
+
 -- 
 -- Dumping data for table `resource`
 -- 


Reply via email to