Author: arkurth
Date: Mon Jan 11 17:52:57 2010
New Revision: 897968

URL: http://svn.apache.org/viewvc?rev=897968&view=rev
Log:
VCL-145
Added winKMS and winProductKey tables to vcl.sql. They will store Windows 
product keys and KMS server addresses.

VCL-288
Added Global row to the affiliation table in vcl.sql.

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=897968&r1=897967&r2=897968&view=diff
==============================================================================
--- incubator/vcl/trunk/mysql/vcl.sql (original)
+++ incubator/vcl/trunk/mysql/vcl.sql Mon Jan 11 17:52:57 2010
@@ -1014,6 +1014,32 @@
 
 -- --------------------------------------------------------
 
+--
+-- Table structure for table `winKMS`
+--
+
+CREATE TABLE IF NOT EXISTS `winKMS` (
+  `affiliationid` mediumint(8) unsigned NOT NULL,
+  `address` varchar(50) NOT NULL,
+  `port` smallint(5) unsigned NOT NULL default '1688',
+  UNIQUE KEY `affiliationid_address` (`affiliationid`,`address`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `winProductKey`
+--
+
+CREATE TABLE IF NOT EXISTS `winProductKey` (
+  `affiliationid` mediumint(8) unsigned NOT NULL,
+  `productname` varchar(100) NOT NULL,
+  `productkey` varchar(100) NOT NULL,
+  UNIQUE KEY `affiliationid_productname` (`affiliationid`,`productname`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
+-- --------------------------------------------------------
+
 -- 
 -- Table structure for table `xmlrpcKey`
 -- 
@@ -1060,8 +1086,8 @@
 -- 
 
 INSERT INTO `affiliation` (`id`, `name`, `dataUpdateText`) VALUES 
-(1, 'Local', '');
-
+(1, 'Local', ''),
+(2, 'Global', '');
 
 -- 
 -- Dumping data for table `computerloadflow`
@@ -1754,3 +1780,15 @@
 ALTER TABLE `vmprofile`
   ADD CONSTRAINT `vmprofile_ibfk_2` FOREIGN KEY (`vmtypeid`) REFERENCES 
`vmtype` (`id`) ON UPDATE CASCADE,
   ADD CONSTRAINT `vmprofile_ibfk_1` FOREIGN KEY (`imageid`) REFERENCES `image` 
(`id`) ON UPDATE CASCADE;
+
+--
+-- Constraints for table `winKMS`
+--
+ALTER TABLE `winKMS`
+  ADD CONSTRAINT `winKMS_ibfk_1` FOREIGN KEY (`affiliationid`) REFERENCES 
`affiliation` (`id`) ON UPDATE CASCADE;
+
+--
+-- Constraints for table `winProductKey`
+--
+ALTER TABLE `winProductKey`
+  ADD CONSTRAINT `winProductKey_ibfk_1` FOREIGN KEY (`affiliationid`) 
REFERENCES `affiliation` (`id`) ON UPDATE CASCADE;


Reply via email to