[Cs-project-svn_notify] SF.net SVN: cs-project: [643] trunk/docs

[<cra...@us...>]

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.