You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@vcl.apache.org by jf...@apache.org on 2014/09/25 14:47:29 UTC
svn commit: r1627532 - /vcl/trunk/mysql/vcl.sql
Author: jfthomps
Date: Thu Sep 25 12:47:28 2014
New Revision: 1627532
URL: http://svn.apache.org/r1627532
Log:
VCL-170 - option to power off blades after reservation - new reload module
VCL-5 - multiple web servers
vcl.sql:
-modified managementnode table: removed trailing comma at end of KEY IPaddress line
-modified constraints for semaphore table: added semicolon at end of last ADD CONSTRAINT line
Modified:
vcl/trunk/mysql/vcl.sql
Modified: vcl/trunk/mysql/vcl.sql
URL: http://svn.apache.org/viewvc/vcl/trunk/mysql/vcl.sql?rev=1627532&r1=1627531&r2=1627532&view=diff
==============================================================================
--- vcl/trunk/mysql/vcl.sql (original)
+++ vcl/trunk/mysql/vcl.sql Thu Sep 25 12:47:28 2014
@@ -597,7 +597,7 @@ CREATE TABLE IF NOT EXISTS `managementno
KEY `stateid` (`stateid`),
KEY `ownerid` (`ownerid`),
KEY `imagelibgroupid` (`imagelibgroupid`),
- KEY `IPaddress` (`IPaddress`),
+ KEY `IPaddress` (`IPaddress`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
@@ -2199,7 +2199,7 @@ ALTER TABLE `semaphore`
ADD CONSTRAINT `semaphore_ibfk_1` FOREIGN KEY (`managementnodeid`) REFERENCES `managementnode` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `semaphore_ibfk_2` FOREIGN KEY (`computerid`) REFERENCES `computer` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `semaphore_ibfk_3` FOREIGN KEY (`imageid`) REFERENCES `image` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
- ADD CONSTRAINT `semaphore_ibfk_4` FOREIGN KEY (`imagerevisionid`) REFERENCES `imagerevision` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
+ ADD CONSTRAINT `semaphore_ibfk_4` FOREIGN KEY (`imagerevisionid`) REFERENCES `imagerevision` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
--
-- Constraints for table `serverprofile`