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

[svn_mapbender at osgeo.org]

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

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

Modified: trunk/mapbender/resources/db/mysql/mysql_schema.sql
===================================================================
--- trunk/mapbender/resources/db/mysql/mysql_schema.sql	2007-02-12 11:57:26 UTC (rev 1114)
+++ trunk/mapbender/resources/db/mysql/mysql_schema.sql	2007-02-12 11:57:45 UTC (rev 1115)
@@ -718,6 +718,44 @@
 ADD CONSTRAINT wms_md_topic_category_fkey_wms_id_fkey  FOREIGN KEY (fkey_wms_id)
 REFERENCES wms (wms_id) MATCH SIMPLE ON UPDATE CASCADE ON DELETE CASCADE;
 
+-- 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 
+--
+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); 
+
+
 SET FOREIGN_KEY_CHECKS=1;
\ No newline at end of file