Author: arkurth
Date: Wed Jan 28 17:34:01 2015
New Revision: 1655401
URL: http://svn.apache.org/r1655401
Log:
VCL-764
Added command to remove constraint on sublog.blockRequestid in update-vcl.sql.
This should only exist in the database if the schema was created or updated
from the schema files in trunk between 2.3.2 and 2.4.
Modified:
vcl/trunk/mysql/update-vcl.sql
Modified: vcl/trunk/mysql/update-vcl.sql
URL:
http://svn.apache.org/viewvc/vcl/trunk/mysql/update-vcl.sql?rev=1655401&r1=1655400&r2=1655401&view=diff
==============================================================================
--- vcl/trunk/mysql/update-vcl.sql (original)
+++ vcl/trunk/mysql/update-vcl.sql Wed Jan 28 17:34:01 2015
@@ -2157,6 +2157,8 @@ CALL AddConstraintIfNotExists('subimages
-- Constraints for table `sublog`
--
+CALL DropExistingConstraints('sublog', 'blockRequestid');
+
CALL AddConstraintIfNotExists('sublog', 'logid', 'log', 'id', 'UPDATE',
'CASCADE');
CALL AddConstraintIfNotExists('sublog', 'imageid', 'image', 'id', 'UPDATE',
'CASCADE');
CALL AddConstraintIfNotExists('sublog', 'imagerevisionid', 'imagerevision',
'id', 'UPDATE', 'CASCADE');
