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`
