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

[svn_mapbender at osgeo.org]

Author: astrid_emde
Date: 2007-02-12 06:57:05 -0500 (Mon, 12 Feb 2007)
New Revision: 1113

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

Modified: trunk/mapbender/resources/db/update/update_postgresql_db.sql
===================================================================
--- trunk/mapbender/resources/db/update/update_postgresql_db.sql	2007-02-09 15:18:54 UTC (rev 1112)
+++ trunk/mapbender/resources/db/update/update_postgresql_db.sql	2007-02-12 11:57:05 UTC (rev 1113)
@@ -103,4 +103,40 @@
 );
 
 -- wms_owner has to be set
--- Update wms set wms_owner =1;
\ No newline at end of file
+-- 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 
+--
+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);