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

[astrid_emde at osgeo.org]

Author: astrid_emde
Date: 2006-06-09 12:21:39+0000
New Revision: 401

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

Log:
db schema for Version 2.4

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=401&p1=trunk/mapbender/resources/db/postgresql/pgsql_schema.sql&p2=trunk/mapbender/resources/db/postgresql/pgsql_schema.sql&r1=400&r2=401
==============================================================================
--- trunk/mapbender/resources/db/postgresql/pgsql_schema.sql	(original)
+++ trunk/mapbender/resources/db/postgresql/pgsql_schema.sql	2006-06-09 12:21:39+0000
@@ -38,7 +38,8 @@
     e_js_file character varying(50),
     e_mb_mod character varying(50),
     e_target character varying(50),
-    e_requires character varying(50)
+    e_requires character varying(50),
+    e_url VARCHAR( 255 ) NULL
 );
 
 
@@ -281,7 +282,8 @@
     wfs_getcapabilities character varying(255),
     wfs_describefeaturetype character varying(255),
     wfs_getfeature character varying(255),
-    wfs_transaction character varying(255)
+    wfs_transaction character varying(255),
+    wfs_owsproxy VARCHAR( 50 ) NULL
 );
 
 
@@ -350,6 +352,19 @@
     featuretype_srs character varying(50)
 );
 
+--
+-- new table from Version 2.4: wfs_featuretype_namespace
+--
+
+CREATE TABLE wfs_featuretype_namespace (
+  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
+) ;
+
 
 --
 -- Name: wms; Type: TABLE; Schema: public; Owner: admin; Tablespace:
@@ -365,7 +380,9 @@
     wms_getfeatureinfo character varying(255) DEFAULT ''::character varying NOT NULL,
     wms_getlegendurl character varying(255),
     wms_filter character varying(255),
-    wms_getcapabilities_doc text
+    wms_getcapabilities_doc text,
+    wms_owsproxy VARCHAR( 50 ) NULL,
+    wms_upload_url VARCHAR( 255 ) NULL
 );