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 2015/01/15 17:34:37 UTC
svn commit: r1652168 - /vcl/trunk/mysql/vcl.sql
Author: jfthomps
Date: Thu Jan 15 16:34:37 2015
New Revision: 1652168
URL: http://svn.apache.org/r1652168
Log:
VCL-763 - Add missing constraints to database tables
vcl.sql: removed constraint on userid field from continuations table. When a user is not logged in yet, there are a few times continuations are still used. In these cases, the userid field gets set to 0.
Modified:
vcl/trunk/mysql/vcl.sql
Modified: vcl/trunk/mysql/vcl.sql
URL: http://svn.apache.org/viewvc/vcl/trunk/mysql/vcl.sql?rev=1652168&r1=1652167&r2=1652168&view=diff
==============================================================================
--- vcl/trunk/mysql/vcl.sql (original)
+++ vcl/trunk/mysql/vcl.sql Thu Jan 15 16:34:37 2015
@@ -2234,7 +2234,6 @@ ALTER TABLE `connectlog` ADD CONSTRAINT
-- Constraints for table `continuations`
--
ALTER TABLE `continuations` ADD CONSTRAINT FOREIGN KEY (`parentid`) REFERENCES `continuations` (`id`) ON DELETE CASCADE;
-ALTER TABLE `continuations` ADD CONSTRAINT FOREIGN KEY (`userid`) REFERENCES `user` (`id`);
--
-- Constraints for table `image`