Author: jfthomps
Date: Wed Sep 1 18:59:07 2010
New Revision: 991654
URL: http://svn.apache.org/viewvc?rev=991654&view=rev
Log:
VCL-161
remove xmlrpcKey table from vcl.sql
vcl.sql: removed xmlrpcKey table
update-2.2.sql: added a "drop table" for xmlrpcKey
Modified:
incubator/vcl/trunk/mysql/update-2.2.sql
incubator/vcl/trunk/mysql/vcl.sql
Modified: incubator/vcl/trunk/mysql/update-2.2.sql
URL:
http://svn.apache.org/viewvc/incubator/vcl/trunk/mysql/update-2.2.sql?rev=991654&r1=991653&r2=991654&view=diff
==============================================================================
--- incubator/vcl/trunk/mysql/update-2.2.sql (original)
+++ incubator/vcl/trunk/mysql/update-2.2.sql Wed Sep 1 18:59:07 2010
@@ -415,6 +415,14 @@ CALL AddConstraintIfNotExists('winKMS',
--
CALL AddConstraintIfNotExists('winProductKey', 'affiliationid', 'affiliation',
'id');
+
+-- --------------------------------------------------------
+
+--
+-- remove table xmlrpcKey
+--
+
+DROP TABLE IF EXISTS `xmlrpcKey`
-- --------------------------------------------------------
Modified: incubator/vcl/trunk/mysql/vcl.sql
URL:
http://svn.apache.org/viewvc/incubator/vcl/trunk/mysql/vcl.sql?rev=991654&r1=991653&r2=991654&view=diff
==============================================================================
--- incubator/vcl/trunk/mysql/vcl.sql (original)
+++ incubator/vcl/trunk/mysql/vcl.sql Wed Sep 1 18:59:07 2010
@@ -1076,21 +1076,6 @@ CREATE TABLE IF NOT EXISTS `winProductKe
-- --------------------------------------------------------
--
--- Table structure for table `xmlrpcKey`
---
-
-CREATE TABLE IF NOT EXISTS `xmlrpcKey` (
- `id` smallint(5) unsigned NOT NULL auto_increment,
- `ownerid` mediumint(8) unsigned NOT NULL default '0',
- `key` varchar(255) NOT NULL default '',
- `active` tinyint(1) NOT NULL default '1',
- `created` datetime NOT NULL default '0000-00-00 00:00:00',
- PRIMARY KEY (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-
--- --------------------------------------------------------
-
---
-- Table structure for table `xmlrpcLog`
--
