svn commit: r412 - trunk/mapbender/resources/db/update/update_postgresql_db.sql

[astrid_emde at osgeo.org]

Author: astrid_emde
Date: 2006-06-12 09:12:41+0000
New Revision: 412

Modified:
   trunk/mapbender/resources/db/update/update_postgresql_db.sql

Log:
database changes in Version 2.4 for PostgreSQL

Modified: trunk/mapbender/resources/db/update/update_postgresql_db.sql
Url: https://mapbender.osgeo.org/source/browse/mapbender/trunk/mapbender/resources/db/update/update_postgresql_db.sql?view=diff&rev=412&p1=trunk/mapbender/resources/db/update/update_postgresql_db.sql&p2=trunk/mapbender/resources/db/update/update_postgresql_db.sql&r1=411&r2=412
==============================================================================
--- trunk/mapbender/resources/db/update/update_postgresql_db.sql	(original)
+++ trunk/mapbender/resources/db/update/update_postgresql_db.sql	2006-06-12 09:12:41+0000
@@ -1,22 +1,31 @@
 --
--- size of varchar changed from 255 to 50
+-- changes in version 2.4
 --
 
-ALTER TABLE gui_element_vars ALTER var_name TYPE varchar(50);
+--
+-- new table: 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
+) ;
+
+
+--
+-- new column wms_owsproxy in table wms
+--
+ALTER TABLE wms ADD wms_owsproxy VARCHAR( 50 ) NULL ;
 
 
 --
--- new table: mb_user_wmc
+-- new column wms_upload_url in table wms
 --
+ALTER TABLE wms ADD wms_upload_url VARCHAR( 255 ) NULL ;
 
-CREATE TABLE mb_user_wmc (
-  wmc_id character varying(20) DEFAULT '' NOT NULL ,
-  fkey_user_id integer DEFAULT 0 NOT NULL ,
-  wmc text NOT NULL,
-  wmc_title character varying(50) DEFAULT NULL ,
-  wmc_timestamp integer DEFAULT NULL
-);
+UPDATE wms set wms_upload_url = wms_getcapabilities;
 
-ALTER TABLE ONLY mb_user_wmc
-  ADD CONSTRAINT mb_user_wmc_ibfk_1 FOREIGN KEY (fkey_user_id) REFERENCES mb_user (mb_user_id) ON UPDATE CASCADE ON DELETE CASCADE;