Revision: 643
http://cs-project.svn.sourceforge.net/cs-project/?rev=643&view=rev
Author: crazedsanity
Date: 2007-11-20 10:32:35 -0800 (Tue, 20 Nov 2007)
Log Message:
-----------
Fix problematic constraint in existing schema & install SQL.
Modified Paths:
--------------
trunk/docs/schema/cs_project.schema.sql
trunk/docs/sql/setup/03__indexes_etc.sql
Modified: trunk/docs/schema/cs_project.schema.sql
===================================================================
--- trunk/docs/schema/cs_project.schema.sql 2007-11-20 18:31:53 UTC (rev 642)
+++ trunk/docs/schema/cs_project.schema.sql 2007-11-20 18:32:35 UTC (rev 643)
@@ -2004,7 +2004,8 @@
--
ALTER TABLE ONLY contact_email_table
- ADD CONSTRAINT contact_email_table_contact_id_fkey FOREIGN KEY (contact_id) REFERENCES contact_table(contact_id);
+ ADD CONSTRAINT contact_email_table_contact_id_fkey FOREIGN KEY (contact_id) REFERENCES contact_table(contact_id)
+ DEFERRABLE INITIALLY DEFERRED;
--
Modified: trunk/docs/sql/setup/03__indexes_etc.sql
===================================================================
--- trunk/docs/sql/setup/03__indexes_etc.sql 2007-11-20 18:31:53 UTC (rev 642)
+++ trunk/docs/sql/setup/03__indexes_etc.sql 2007-11-20 18:32:35 UTC (rev 643)
@@ -1,8 +1,8 @@
--
-- SVN INFORMATION:::
-- SVN Signature: $Id:::: 03__indexes_etc.sql 253 2007-09-29 19:48:37Z crazedsanity $
--- Last Committted Date:: $Date$
--- Last Committed Path::: $HeadURL$
+-- Last Committted Date:: $Date:2007-11-20 11:02:38 -0600 (Tue, 20 Nov 2007) $
+-- Last Committed Path::: $HeadURL:https://cs-project.svn.sourceforge.net/svnroot/cs-project/trunk/docs/sql/setup/03__indexes_etc.sql $
--
--
@@ -466,7 +466,8 @@
--
ALTER TABLE ONLY contact_email_table
- ADD CONSTRAINT contact_email_table_contact_id_fkey FOREIGN KEY (contact_id) REFERENCES contact_table(contact_id);
+ ADD CONSTRAINT contact_email_table_contact_id_fkey FOREIGN KEY (contact_id) REFERENCES contact_table(contact_id)
+ DEFERRABLE INITIALLY DEFERRED;
--
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
