[Mapbender-commits] r2124 - branches/2.5/resources/db/update

[svn_mapbender at osgeo.org]

Author: astrid_emde
Date: 2008-02-20 08:40:07 -0500 (Wed, 20 Feb 2008)
New Revision: 2124

Modified:
   branches/2.5/resources/db/update/update_mysql_db.sql
Log:
new column f_operator

Modified: branches/2.5/resources/db/update/update_mysql_db.sql
===================================================================
--- branches/2.5/resources/db/update/update_mysql_db.sql	2008-02-20 13:37:50 UTC (rev 2123)
+++ branches/2.5/resources/db/update/update_mysql_db.sql	2008-02-20 13:40:07 UTC (rev 2124)
@@ -39,10 +39,17 @@
 
 
 --
+-- table wfs_conf
+--
+ALTER TABLE wfs_conf add COLUMN wfs_conf_description text;
+
+--
 -- table wfs_conf_element: change in WFS configuration: access to geometries may now be restricted
 --
 ALTER TABLE wfs_conf_element ADD COLUMN f_auth_varname VARCHAR(50) NULL;
 ALTER TABLE wfs_conf_element ADD COLUMN f_show_detail int4;
+ALTER TABLE wfs_conf_element ADD COLUMN f_operator VARCHAR(50) NULL;
+
 --
 -- table gui_element: new column for translation
 --