You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@vcl.apache.org by ar...@apache.org on 2010/01/11 18:52:57 UTC
svn commit: r897968 - /incubator/vcl/trunk/mysql/vcl.sql
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;