vcl-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From arku...@apache.org
Subject svn commit: r1787092 - in /vcl/trunk/mysql: update-vcl.sql vcl.sql
Date Wed, 15 Mar 2017 18:33:47 GMT
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;



Mime
View raw message