[Mapbender-commits] r1888 - trunk/mapbender/resources/db/update

[svn_mapbender at osgeo.org]

Author: verenadiewald
Date: 2007-12-05 04:49:55 -0500 (Wed, 05 Dec 2007)
New Revision: 1888

Modified:
   trunk/mapbender/resources/db/update/update_mysql_db.sql
   trunk/mapbender/resources/db/update/update_postgresql_db.sql
Log:
new column f_show_detail for table wfs_conf_element

Modified: trunk/mapbender/resources/db/update/update_mysql_db.sql
===================================================================
--- trunk/mapbender/resources/db/update/update_mysql_db.sql	2007-12-04 11:21:03 UTC (rev 1887)
+++ trunk/mapbender/resources/db/update/update_mysql_db.sql	2007-12-05 09:49:55 UTC (rev 1888)
@@ -8,7 +8,7 @@
 -- 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;
 --
 -- table gui_element: new column for translation
 --

Modified: trunk/mapbender/resources/db/update/update_postgresql_db.sql
===================================================================
--- trunk/mapbender/resources/db/update/update_postgresql_db.sql	2007-12-04 11:21:03 UTC (rev 1887)
+++ trunk/mapbender/resources/db/update/update_postgresql_db.sql	2007-12-05 09:49:55 UTC (rev 1888)
@@ -99,6 +99,7 @@
 --
 ALTER TABLE wfs_conf_element ADD COLUMN f_auth_varname VARCHAR(50);
 ALTER TABLE wfs_conf add COLUMN wfs_conf_description text;
+ALTER TABLE wfs_conf_element ADD COLUMN f_show_detail int4;
 
 --
 -- table gui_element: new column for translation