svn commit: r402 - trunk/mapbender/resources/db/postgresql/pgsql_schema.sql

[astrid_emde at osgeo.org]

Author: astrid_emde
Date: 2006-06-09 13:01:04+0000
New Revision: 402

Modified:
   trunk/mapbender/resources/db/postgresql/pgsql_schema.sql

Log:


Modified: trunk/mapbender/resources/db/postgresql/pgsql_schema.sql
Url: https://mapbender.osgeo.org/source/browse/mapbender/trunk/mapbender/resources/db/postgresql/pgsql_schema.sql?view=diff&rev=402&p1=trunk/mapbender/resources/db/postgresql/pgsql_schema.sql&p2=trunk/mapbender/resources/db/postgresql/pgsql_schema.sql&r1=401&r2=402
==============================================================================
--- trunk/mapbender/resources/db/postgresql/pgsql_schema.sql	(original)
+++ trunk/mapbender/resources/db/postgresql/pgsql_schema.sql	2006-06-09 13:01:04+0000
@@ -360,9 +360,7 @@
   fkey_wfs_id INTEGER NOT NULL default '0',
   fkey_featuretype_id INTEGER NOT NULL default '0',
   namespace varchar(255) NOT NULL default '',
-  namespace_location varchar(255) NOT NULL default '', 
-  FOREIGN KEY (fkey_featuretype_id) REFERENCES wfs_featuretype (featuretype_id) ON DELETE CASCADE ON UPDATE CASCADE,
-  FOREIGN KEY (fkey_wfs_id) REFERENCES wfs (wfs_id) ON DELETE CASCADE ON UPDATE CASCADE
+  namespace_location varchar(255) NOT NULL default ''
 ) ;
 
 
@@ -519,6 +517,13 @@
 ALTER TABLE ONLY wfs
     ADD CONSTRAINT pk_wfs_id PRIMARY KEY (wfs_id);
 
+--
+-- Name: pk_wfs_featuretype_id; Type: CONSTRAINT; Schema: public; Owner: admin; Tablespace:
+--
+
+ALTER TABLE ONLY wfs_featuretype
+    ADD CONSTRAINT pk_wfs_featuretype_id PRIMARY KEY (featuretype_id);
+
 
 --
 -- Name: pk_wms_id; Type: CONSTRAINT; Schema: public; Owner: admin; Tablespace:
@@ -706,6 +711,18 @@
 
 
 --
+-- Name: wfs_featuretype_namespace_ibfk_1; Type: FK CONSTRAINT; Schema: public; Owner: admin
+--
+
+ALTER TABLE ONLY wfs_featuretype_namespace
+    ADD CONSTRAINT wfs_featuretype_namespace_ibfk_1 FOREIGN KEY (fkey_featuretype_id) REFERENCES wfs_featuretype (featuretype_id) ON DELETE CASCADE ON UPDATE CASCADE;
+
+ALTER TABLE ONLY wfs_featuretype_namespace
+    ADD CONSTRAINT wfs_featuretype_namespace_ibfk_2 FOREIGN KEY (fkey_wfs_id) REFERENCES wfs (wfs_id) ON DELETE CASCADE ON UPDATE CASCADE;
+
+
+
+--
 -- Name: wms_format_ibfk_1; Type: FK CONSTRAINT; Schema: public; Owner: admin
 --