[Mapbender-commits] r2822 - in branches/2.5/resources/db: mysql postgresql

[svn_mapbender at osgeo.org]

Author: christoph
Date: 2008-08-15 09:32:34 -0400 (Fri, 15 Aug 2008)
New Revision: 2822

Modified:
   branches/2.5/resources/db/mysql/mysql_schema.sql
   branches/2.5/resources/db/postgresql/pgsql_schema.sql
Log:
http://trac.osgeo.org/mapbender/ticket/277

Modified: branches/2.5/resources/db/mysql/mysql_schema.sql
===================================================================
--- branches/2.5/resources/db/mysql/mysql_schema.sql	2008-08-15 11:52:18 UTC (rev 2821)
+++ branches/2.5/resources/db/mysql/mysql_schema.sql	2008-08-15 13:32:34 UTC (rev 2822)
@@ -1071,4 +1071,8 @@
 ALTER TABLE gui_element MODIFY e_js_file character varying(255);
 ALTER TABLE gui_element MODIFY e_mb_mod character varying(255);
 ALTER TABLE wms MODIFY fees text;
-ALTER TABLE wms CHANGE COLUMN wms_mb_getcapabilies_doc wms_mb_getcapabilities_doc text;
\ No newline at end of file
+ALTER TABLE wms CHANGE COLUMN wms_mb_getcapabilies_doc wms_mb_getcapabilities_doc text;
+
+
+ALTER TABLE `wfs_conf`
+    ADD CONSTRAINT wfs_conf_ibfk_2 FOREIGN KEY (fkey_featuretype_id) REFERENCES wfs_featuretype(featuretype_id) ON UPDATE CASCADE ON DELETE CASCADE;
\ No newline at end of file

Modified: branches/2.5/resources/db/postgresql/pgsql_schema.sql
===================================================================
--- branches/2.5/resources/db/postgresql/pgsql_schema.sql	2008-08-15 11:52:18 UTC (rev 2821)
+++ branches/2.5/resources/db/postgresql/pgsql_schema.sql	2008-08-15 13:32:34 UTC (rev 2822)
@@ -1459,3 +1459,5 @@
 
 
 
+ALTER TABLE ONLY wfs_conf
+    ADD CONSTRAINT wfs_conf_ibfk_2 FOREIGN KEY (fkey_featuretype_id) REFERENCES wfs_featuretype(featuretype_id) ON UPDATE CASCADE ON DELETE CASCADE;
\ No newline at end of file