You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@vcl.apache.org by ar...@apache.org on 2015/01/28 18:34:01 UTC
svn commit: r1655401 - /vcl/trunk/mysql/update-vcl.sql
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');