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

[astrid_emde at osgeo.org]

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

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=413&p1=trunk/mapbender/resources/db/update/update_postgresql_db.sql&p2=trunk/mapbender/resources/db/update/update_postgresql_db.sql&r1=412&r2=413
==============================================================================
--- trunk/mapbender/resources/db/update/update_postgresql_db.sql	(original)
+++ trunk/mapbender/resources/db/update/update_postgresql_db.sql	2006-06-12 09:16:41+0000
@@ -18,14 +18,26 @@
 --
 -- new column wms_owsproxy in table wms
 --
-ALTER TABLE wms ADD wms_owsproxy VARCHAR( 50 ) NULL ;
+ALTER TABLE wms ADD wms_owsproxy VARCHAR(50) NULL ;
+
+
+--
+-- new column wfs_owsproxy in table wfs
+--
+ALTER TABLE wfs ADD wfs_owsproxy VARCHAR( 50 ) NULL ;
 
 
 --
 -- new column wms_upload_url in table wms
 --
-ALTER TABLE wms ADD wms_upload_url VARCHAR( 255 ) NULL ;
+ALTER TABLE wms ADD wms_upload_url VARCHAR(255) NULL ;
 
 UPDATE wms set wms_upload_url = wms_getcapabilities;
 
 
+--
+-- new column e_url in table gui_element
+--
+ALTER TABLE gui_element ADD e_url VARCHAR( 255 ) NULL ;
+
+