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

[svn_mapbender at osgeo.org]

Author: christoph
Date: 2009-03-17 08:27:44 -0400 (Tue, 17 Mar 2009)
New Revision: 3769

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:
incorrect 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 11:48:02 UTC (rev 3768)
+++ 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)
@@ -2,7 +2,7 @@
 -- 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 NOT IN (SELECT DISTINCT element_id AS f_id FROM wfs_element);
 
 ALTER TABLE ONLY `wfs_element`
     ADD CONSTRAINT wfs_element_element_id_key UNIQUE (element_id);

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 11:48:02 UTC (rev 3768)
+++ 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)
@@ -2,7 +2,7 @@
 -- 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 NOT IN (SELECT DISTINCT element_id AS f_id FROM wfs_element);
 
 ALTER TABLE ONLY `wfs_element`
     ADD CONSTRAINT wfs_element_element_id_key UNIQUE (element_id);