[Mapbender-commits] r3758 - in branches/2.5/resources/db:
mysql/iso/update mysql/utf8/update postgresql/iso/update
postgresql/utf8/update
svn_mapbender at osgeo.org
svn_mapbender at osgeo.org
Tue Mar 17 06:18:26 EDT 2009
Author: christoph
Date: 2009-03-17 06:18:26 -0400 (Tue, 17 Mar 2009)
New Revision: 3758
Added:
branches/2.5/resources/db/mysql/utf8/update/update_2.5.1rc1_to_2.5.1_mysql_UTF-8.sql
Modified:
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/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:
added missing constraint wfs_conf_element / wfs_element
Modified: 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 2009-03-17 10:15:46 UTC (rev 3757)
+++ branches/2.5/resources/db/mysql/iso/update/update_2.5.1rc1_to_2.5.1_mysql_ISO-8859-1.sql 2009-03-17 10:18:26 UTC (rev 3758)
@@ -2,7 +2,10 @@
-- 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))
+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
+ALTER TABLE ONLY `wfs_element`
+ ADD CONSTRAINT wfs_element_element_id_key UNIQUE (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;
Copied: branches/2.5/resources/db/mysql/utf8/update/update_2.5.1rc1_to_2.5.1_mysql_UTF-8.sql (from rev 3754, 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_mysql_UTF-8.sql (rev 0)
+++ branches/2.5/resources/db/mysql/utf8/update/update_2.5.1rc1_to_2.5.1_mysql_UTF-8.sql 2009-03-17 10:18:26 UTC (rev 3758)
@@ -0,0 +1,11 @@
+--
+-- 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_element`
+ ADD CONSTRAINT wfs_element_element_id_key UNIQUE (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;
Modified: 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 2009-03-17 10:15:46 UTC (rev 3757)
+++ branches/2.5/resources/db/postgresql/iso/update/update_2.5.1rc1_to_2.5.1_pgsql_ISO-8859-1.sql 2009-03-17 10:18:26 UTC (rev 3758)
@@ -2,7 +2,10 @@
-- 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))
+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_element
+ ADD CONSTRAINT wfs_element_element_id_key UNIQUE (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;
Modified: 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 2009-03-17 10:15:46 UTC (rev 3757)
+++ branches/2.5/resources/db/postgresql/utf8/update/update_2.5.1rc1_to_2.5.1_pgsql_UTF-8.sql 2009-03-17 10:18:26 UTC (rev 3758)
@@ -2,7 +2,11 @@
-- 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))
+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_element
+ ADD CONSTRAINT wfs_element_element_id_key UNIQUE (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;
+
\ No newline at end of file
More information about the Mapbender_commits
mailing list