[Mapbender-commits] r3770 - in branches/2.5/resources/db/mysql:
iso/update utf8/update
svn_mapbender at osgeo.org
svn_mapbender at osgeo.org
Tue Mar 17 08:35:13 EDT 2009
Author: christoph
Date: 2009-03-17 08:35:13 -0400 (Tue, 17 Mar 2009)
New Revision: 3770
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/utf8/update/update_2.5.1rc1_to_2.5.1_mysql_UTF-8.sql
Log:
wrong syntax
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 12:27:44 UTC (rev 3769)
+++ branches/2.5/resources/db/mysql/iso/update/update_2.5.1rc1_to_2.5.1_mysql_ISO-8859-1.sql 2009-03-17 12:35:13 UTC (rev 3770)
@@ -4,8 +4,8 @@
DELETE FROM wfs_conf_element WHERE f_id NOT IN (SELECT DISTINCT element_id AS f_id FROM wfs_element);
-ALTER TABLE ONLY `wfs_element`
+ALTER TABLE `wfs_element`
ADD CONSTRAINT wfs_element_element_id_key UNIQUE (element_id);
-ALTER TABLE ONLY `wfs_conf_element`
+ALTER TABLE `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/mysql/utf8/update/update_2.5.1rc1_to_2.5.1_mysql_UTF-8.sql
===================================================================
--- branches/2.5/resources/db/mysql/utf8/update/update_2.5.1rc1_to_2.5.1_mysql_UTF-8.sql 2009-03-17 12:27:44 UTC (rev 3769)
+++ branches/2.5/resources/db/mysql/utf8/update/update_2.5.1rc1_to_2.5.1_mysql_UTF-8.sql 2009-03-17 12:35:13 UTC (rev 3770)
@@ -4,8 +4,8 @@
DELETE FROM wfs_conf_element WHERE f_id NOT IN (SELECT DISTINCT element_id AS f_id FROM wfs_element);
-ALTER TABLE ONLY `wfs_element`
+ALTER TABLE `wfs_element`
ADD CONSTRAINT wfs_element_element_id_key UNIQUE (element_id);
-ALTER TABLE ONLY `wfs_conf_element`
+ALTER TABLE `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;
More information about the Mapbender_commits
mailing list