[Mapbender-commits] r1134 - trunk/mapbender/resources/db/mysql

[svn_mapbender at osgeo.org]

Author: astrid_emde
Date: 2007-02-23 05:43:26 -0500 (Fri, 23 Feb 2007)
New Revision: 1134

Modified:
   trunk/mapbender/resources/db/mysql/mysql_schema.sql
Log:
added new columns in table wfs_conf_element

Modified: trunk/mapbender/resources/db/mysql/mysql_schema.sql
===================================================================
--- trunk/mapbender/resources/db/mysql/mysql_schema.sql	2007-02-22 16:57:20 UTC (rev 1133)
+++ trunk/mapbender/resources/db/mysql/mysql_schema.sql	2007-02-23 10:43:26 UTC (rev 1134)
@@ -394,6 +394,9 @@
   f_label_id varchar(50) default NULL,
   f_show tinyint(3) unsigned default NULL,
   f_respos int(11) default NULL,
+  f_form_element_html TEXT NULL,
+  f_edit int4,
+  f_mandatory int4,
   PRIMARY KEY  (wfs_conf_element_id),
   KEY fkey_wfs_conf_id (fkey_wfs_conf_id)
 ) TYPE=InnoDB;
@@ -721,17 +724,6 @@
 -- wms_owner has to be set
 -- Update wms set wms_owner =1;
 
---
--- new columns in table wfs_conf_element
--- Selectbox (Text) for predefined values
-ALTER TABLE wfs_conf_element ADD f_box TEXT NULL ;
- 
--- editable
-ALTER TABLE wfs_conf_element ADD COLUMN f_edit int4;
- 
--- Pflichtfeld / mandatory 
-ALTER TABLE wfs_conf_element ADD COLUMN f_mandatory int4;
- 
 --  
 -- add missing primary keys 
 --