Author: arkurth
Date: Wed Mar 15 18:33:47 2017
New Revision: 1787092
URL: http://svn.apache.org/viewvc?rev=1787092&view=rev
Log:
VCL-1023
Added vcldsemaphore table definition to vcl.sql and update-vcl.sql.
Modified:
vcl/trunk/mysql/update-vcl.sql
vcl/trunk/mysql/vcl.sql
Modified: vcl/trunk/mysql/update-vcl.sql
URL:
http://svn.apache.org/viewvc/vcl/trunk/mysql/update-vcl.sql?rev=1787092&r1=1787091&r2=1787092&view=diff
==============================================================================
--- vcl/trunk/mysql/update-vcl.sql (original)
+++ vcl/trunk/mysql/update-vcl.sql Wed Mar 15 18:33:47 2017
@@ -1497,6 +1497,21 @@ CREATE TABLE IF NOT EXISTS `variable` (
-- --------------------------------------------------------
+--
+-- Table structure for table `vcldsemaphore`
+--
+
+CREATE TABLE IF NOT EXISTS `vcldsemaphore` (
+ `identifier` varchar(256) NOT NULL,
+ `reservationid` mediumint(9) unsigned NOT NULL,
+ `pid` smallint(5) unsigned NOT NULL,
+ `expires` datetime NOT NULL,
+ PRIMARY KEY (`identifier`),
+ KEY `reservationid` (`reservationid`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
+-- --------------------------------------------------------
+
--
-- Table structure change for table `vmhost`
--
@@ -2598,6 +2613,14 @@ CALL AddConstraintIfNotExists('userpriv'
-- --------------------------------------------------------
+--
+-- Constraints for table `vcldsemaphore`
+--
+
+CALL AddConstraintIfNotExists('vcldsemaphore', 'reservationid', 'reservation',
'id', 'both', 'CASCADE');
+
+-- --------------------------------------------------------
+
--
-- Constraints for table `vmhost`
--
Modified: vcl/trunk/mysql/vcl.sql
URL:
http://svn.apache.org/viewvc/vcl/trunk/mysql/vcl.sql?rev=1787092&r1=1787091&r2=1787092&view=diff
==============================================================================
--- vcl/trunk/mysql/vcl.sql (original)
+++ vcl/trunk/mysql/vcl.sql Wed Mar 15 18:33:47 2017
@@ -1436,6 +1436,21 @@ CREATE TABLE IF NOT EXISTS `variable` (
-- --------------------------------------------------------
+--
+-- Table structure for table `vcldsemaphore`
+--
+
+CREATE TABLE IF NOT EXISTS `vcldsemaphore` (
+ `identifier` varchar(256) NOT NULL,
+ `reservationid` mediumint(9) unsigned NOT NULL,
+ `pid` smallint(5) unsigned NOT NULL,
+ `expires` datetime NOT NULL,
+ PRIMARY KEY (`identifier`),
+ KEY `reservationid` (`reservationid`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
+-- --------------------------------------------------------
+
--
-- Table structure for table `vmhost`
--
@@ -2617,6 +2632,11 @@ ALTER TABLE `userpriv` ADD CONSTRAINT FO
ALTER TABLE `userpriv` ADD CONSTRAINT FOREIGN KEY (`userprivtypeid`)
REFERENCES `userprivtype` (`id`) ON UPDATE CASCADE;
--
+-- Constraints for table `vcldsemaphore`
+--
+ALTER TABLE `vcldsemaphore` ADD CONSTRAINT FOREIGN KEY (`reservationid`)
REFERENCES `reservation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
+
+--
-- Constraints for table `vmhost`
--
ALTER TABLE `vmhost` ADD CONSTRAINT FOREIGN KEY (`vmprofileid`) REFERENCES
`vmprofile` (`id`) ON UPDATE CASCADE;
