[Mapbender-commits] r3754 - in branches/2.5/resources/db: mysql/iso/update mysql/utf8/update postgresql/iso/update postgresql/utf8/update

[svn_mapbender at osgeo.org]

Author: christoph
Date: 2009-03-16 13:30:32 -0400 (Mon, 16 Mar 2009)
New Revision: 3754

Added:
   branches/2.5/resources/db/mysql/iso/update/update_2.5.1rc1_to_2.5.1_mysql_ISO-8859-1.sql
   branches/2.5/resources/db/mysql/utf8/update/update_2.5.1rc1_to_2.5.1_pgsql_UTF-8.sql
   branches/2.5/resources/db/postgresql/iso/update/update_2.5.1rc1_to_2.5.1_pgsql_ISO-8859-1.sql
   branches/2.5/resources/db/postgresql/utf8/update/update_2.5.1rc1_to_2.5.1_pgsql_UTF-8.sql
Log:
add missing constraint

Added: branches/2.5/resources/db/mysql/iso/update/update_2.5.1rc1_to_2.5.1_mysql_ISO-8859-1.sql
===================================================================
--- branches/2.5/resources/db/mysql/iso/update/update_2.5.1rc1_to_2.5.1_mysql_ISO-8859-1.sql	                        (rev 0)
+++ branches/2.5/resources/db/mysql/iso/update/update_2.5.1rc1_to_2.5.1_mysql_ISO-8859-1.sql	2009-03-16 17:30:32 UTC (rev 3754)
@@ -0,0 +1,8 @@
+--
+-- database changes in version 2.5.1
+--
+
+DELETE FROM wfs_conf_element WHERE f_id = ((SELECT DISTINCT f_id FROM wfs_conf_element) MINUS (SELECT DISTINCT f_id FROM wfs_conf_element, wfs_element WHERE f_id = element_id))
+
+ALTER TABLE ONLY wfs_conf_element
+    ADD CONSTRAINT wfs_conf_element_id_ibfk_1 FOREIGN KEY (f_id) REFERENCES wfs_element (element_id) ON UPDATE CASCADE ON DELETE CASCADE;

Added: branches/2.5/resources/db/mysql/utf8/update/update_2.5.1rc1_to_2.5.1_pgsql_UTF-8.sql
===================================================================
--- branches/2.5/resources/db/mysql/utf8/update/update_2.5.1rc1_to_2.5.1_pgsql_UTF-8.sql	                        (rev 0)
+++ branches/2.5/resources/db/mysql/utf8/update/update_2.5.1rc1_to_2.5.1_pgsql_UTF-8.sql	2009-03-16 17:30:32 UTC (rev 3754)
@@ -0,0 +1,8 @@
+--
+-- database changes in version 2.5.1
+--
+
+DELETE FROM wfs_conf_element WHERE f_id = ((SELECT DISTINCT f_id FROM wfs_conf_element) MINUS (SELECT DISTINCT f_id FROM wfs_conf_element, wfs_element WHERE f_id = element_id))
+
+ALTER TABLE ONLY wfs_conf_element
+    ADD CONSTRAINT wfs_conf_element_id_ibfk_1 FOREIGN KEY (f_id) REFERENCES wfs_element (element_id) ON UPDATE CASCADE ON DELETE CASCADE;

Added: branches/2.5/resources/db/postgresql/iso/update/update_2.5.1rc1_to_2.5.1_pgsql_ISO-8859-1.sql
===================================================================
--- branches/2.5/resources/db/postgresql/iso/update/update_2.5.1rc1_to_2.5.1_pgsql_ISO-8859-1.sql	                        (rev 0)
+++ branches/2.5/resources/db/postgresql/iso/update/update_2.5.1rc1_to_2.5.1_pgsql_ISO-8859-1.sql	2009-03-16 17:30:32 UTC (rev 3754)
@@ -0,0 +1,8 @@
+--
+-- database changes in version 2.5.1
+--
+
+DELETE FROM wfs_conf_element WHERE f_id = ((SELECT DISTINCT f_id FROM wfs_conf_element) EXCEPT (SELECT DISTINCT f_id FROM wfs_conf_element, wfs_element WHERE f_id = element_id))
+
+ALTER TABLE ONLY wfs_conf_element
+    ADD CONSTRAINT wfs_conf_element_id_ibfk_1 FOREIGN KEY (f_id) REFERENCES wfs_element (element_id) ON UPDATE CASCADE ON DELETE CASCADE;

Added: branches/2.5/resources/db/postgresql/utf8/update/update_2.5.1rc1_to_2.5.1_pgsql_UTF-8.sql
===================================================================
--- branches/2.5/resources/db/postgresql/utf8/update/update_2.5.1rc1_to_2.5.1_pgsql_UTF-8.sql	                        (rev 0)
+++ branches/2.5/resources/db/postgresql/utf8/update/update_2.5.1rc1_to_2.5.1_pgsql_UTF-8.sql	2009-03-16 17:30:32 UTC (rev 3754)
@@ -0,0 +1,8 @@
+--
+-- database changes in version 2.5.1
+--
+
+DELETE FROM wfs_conf_element WHERE f_id = ((SELECT DISTINCT f_id FROM wfs_conf_element) EXCEPT (SELECT DISTINCT f_id FROM wfs_conf_element, wfs_element WHERE f_id = element_id))
+
+ALTER TABLE ONLY wfs_conf_element
+    ADD CONSTRAINT wfs_conf_element_id_ibfk_1 FOREIGN KEY (f_id) REFERENCES wfs_element (element_id) ON UPDATE CASCADE ON DELETE CASCADE;