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

[svn_mapbender at osgeo.org]

Author: astrid_emde
Date: 2007-02-12 06:58:34 -0500 (Mon, 12 Feb 2007)
New Revision: 1116

Modified:
   trunk/mapbender/resources/db/postgresql/pgsql_schema.sql
Log:
new columns in table wfs_conf_elemet added and lots of primarykeys added

Modified: trunk/mapbender/resources/db/postgresql/pgsql_schema.sql
===================================================================
--- trunk/mapbender/resources/db/postgresql/pgsql_schema.sql	2007-02-12 11:57:45 UTC (rev 1115)
+++ trunk/mapbender/resources/db/postgresql/pgsql_schema.sql	2007-02-12 11:58:34 UTC (rev 1116)
@@ -1053,3 +1053,39 @@
 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 
+--
+ALTER TABLE gui_layer ADD CONSTRAINT pk_gui_layer PRIMARY KEY (fkey_gui_id,fkey_layer_id);
+
+ALTER TABLE gui_wms ADD CONSTRAINT pk_gui_wms PRIMARY KEY (fkey_gui_id,fkey_wms_id);
+
+ALTER TABLE layer_keyword ADD CONSTRAINT pk_layer_keyword PRIMARY KEY (fkey_layer_id,fkey_keyword_id);
+
+ALTER TABLE mb_user_wmc ADD CONSTRAINT pk_user_wmc PRIMARY KEY (wmc_id);
+
+ALTER TABLE wfs_element ADD CONSTRAINT pk_wfs_element PRIMARY KEY (fkey_featuretype_id,element_id);
+
+ALTER TABLE wms_format ADD CONSTRAINT pk_wms_format PRIMARY KEY (fkey_wms_id,data_type,data_format);
+
+ALTER TABLE wms_md_topic_category ADD CONSTRAINT pk_md_topic_category PRIMARY KEY (fkey_wms_id,fkey_md_topic_category_id);
+
+ALTER TABLE wms_srs ADD CONSTRAINT pk_wms_srs PRIMARY KEY (fkey_wms_id,wms_srs);
+
+ALTER TABLE wfs_featuretype_namespace ADD CONSTRAINT pk_featuretype_namespace PRIMARY KEY  (fkey_wfs_id,fkey_featuretype_id,namespace);
+
+ALTER TABLE mb_monitor ADD CONSTRAINT pk_mb_monitor PRIMARY KEY  (upload_id,fkey_wms_id);
+
+ALTER TABLE mb_log ADD CONSTRAINT pk_mb_log PRIMARY KEY  (id); 
+