[Mapbender-commits] r1135 - trunk/mapbender/resources/db/postgresql

[svn_mapbender at osgeo.org]

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

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

Modified: trunk/mapbender/resources/db/postgresql/pgsql_schema.sql
===================================================================
--- trunk/mapbender/resources/db/postgresql/pgsql_schema.sql	2007-02-23 10:43:26 UTC (rev 1134)
+++ trunk/mapbender/resources/db/postgresql/pgsql_schema.sql	2007-02-23 10:43:52 UTC (rev 1135)
@@ -423,7 +423,10 @@
     f_label character varying(255),
     f_label_id character varying(50),
     f_show integer,
-    f_respos integer
+    f_respos integer,
+    f_form_element_html TEXT NULL,
+    f_edit int4,
+    f_mandatory int4
 );
 
 
@@ -1053,17 +1056,8 @@
 ALTER TABLE ONLY wms_srs
     ADD CONSTRAINT wms_srs_ibfk_1 FOREIGN KEY (fkey_wms_id) REFERENCES wms(wms_id) ON UPDATE CASCADE ON DELETE CASCADE;
 
---
--- 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 
 --