[Mapbender-commits] r1371 - trunk/mapbender/resources/db/update
svn_mapbender at osgeo.org
svn_mapbender at osgeo.org
Tue May 29 07:42:59 EDT 2007
Author: christoph
Date: 2007-05-29 07:42:59 -0400 (Tue, 29 May 2007)
New Revision: 1371
Modified:
trunk/mapbender/resources/db/update/update_mysql_db.sql
trunk/mapbender/resources/db/update/update_postgresql_db.sql
Log:
no updates in 2.4.2
Modified: trunk/mapbender/resources/db/update/update_mysql_db.sql
===================================================================
--- trunk/mapbender/resources/db/update/update_mysql_db.sql 2007-05-29 11:42:14 UTC (rev 1370)
+++ trunk/mapbender/resources/db/update/update_mysql_db.sql 2007-05-29 11:42:59 UTC (rev 1371)
@@ -1,131 +1,4 @@
--
--- changes in version 2.4.1
+-- no changes in version 2.4.2
--
---
--- new table: keyword
---
-CREATE TABLE keyword
-(
-keyword_id int(11) NOT NULL auto_increment,
-keyword varchar(255) NOT NULL,
-PRIMARY KEY (keyword_id)
-) TYPE = InnoDb;
-
-ALTER TABLE keyword
- ADD CONSTRAINT keyword_keyword_key UNIQUE (keyword);
-
---
--- Index: ind_keyword
---
-ALTER TABLE `keyword` ADD INDEX `ind_keyword` ( `keyword` ) ;
-
---
--- new table: layer_keyword
---
-CREATE TABLE layer_keyword
-(
- fkey_layer_id int(11) NOT NULL,
- fkey_keyword_id int(11) NOT NULL,
-
-) TYPE = InnoDb;
-
-ALTER TABLE layer_keyword
-ADD CONSTRAINT fkey_keyword_id_fkey_layer_id FOREIGN KEY (fkey_keyword_id)
-REFERENCES keyword (keyword_id) MATCH SIMPLE ON UPDATE CASCADE ON DELETE CASCADE;
-
-ALTER TABLE layer_keyword
-ADD CONSTRAINT fkey_layer_id_fkey_keyword_id FOREIGN KEY (fkey_layer_id)
-REFERENCES layer (layer_id) MATCH SIMPLE ON UPDATE CASCADE ON DELETE CASCADE;
-
---
--- new columns in table wms
---
-ALTER TABLE wms ADD fees varchar(255) NULL;
-ALTER TABLE wms ADD accessconstraints text NULL;
-ALTER TABLE wms ADD contactperson varchar(255) NULL;
-ALTER TABLE wms ADD contactposition varchar(255) NULL;
-ALTER TABLE wms ADD contactorganization varchar(255) NULL;
-ALTER TABLE wms ADD address varchar(255) NULL;
-ALTER TABLE wms ADD city varchar(255) NULL;
-ALTER TABLE wms ADD stateorprovince varchar(255) NULL;
-ALTER TABLE wms ADD postcode varchar(255) NULL;
-ALTER TABLE wms ADD country varchar(255) NULL;
-ALTER TABLE wms ADD contactvoicetelephone varchar(255) NULL;
-ALTER TABLE wms ADD contactfacsimiletelephone varchar(255) NULL;
-ALTER TABLE wms ADD contactelectronicmailaddress varchar(255) NULL;
-ALTER TABLE wms ADD wms_mb_getcapabilies_doc text NULL;
-ALTER TABLE wms ADD wms_owner int(11) NULL;
-ALTER TABLE wms ADD wms_timestamp int(11) NULL;
-ALTER TABLE layer ADD layer_abstract text NULL;
-
-
---
--- new table: md_topic_category
---
-CREATE TABLE md_topic_category (
- md_topic_category_id int(11) NOT NULL auto_increment,
- md_topic_category_code_en varchar(255),
- md_topic_category_code_de varchar(255),
- PRIMARY KEY (md_topic_category_id)
-)TYPE = InnoDb;
-
---
--- new table: wms_md_topic_category
---
-CREATE TABLE wms_md_topic_category (
- fkey_wms_id int(11) NOT NULL,
- fkey_md_topic_category_id int(11) NOT NULL
-)TYPE = InnoDb;
-
-
--- wms_owner has to be set
--- Update wms set wms_owner =1;
-
-
-ALTER TABLE wms_md_topic_category
-ADD CONSTRAINT wms_md_topic_category_fkey_md_topic_category_id_fkey FOREIGN KEY (fkey_md_topic_category_id)
-REFERENCES md_topic_category (md_topic_category_id) MATCH SIMPLE ON UPDATE CASCADE ON DELETE CASCADE;
-
-ALTER TABLE wms_md_topic_category
-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_form_element_html 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);
Modified: trunk/mapbender/resources/db/update/update_postgresql_db.sql
===================================================================
--- trunk/mapbender/resources/db/update/update_postgresql_db.sql 2007-05-29 11:42:14 UTC (rev 1370)
+++ trunk/mapbender/resources/db/update/update_postgresql_db.sql 2007-05-29 11:42:59 UTC (rev 1371)
@@ -1,146 +1,3 @@
--
--- changes in version 2.4.1
---
-
---
--- new table: keyword
---
-CREATE TABLE keyword
-(
- keyword_id serial,
- keyword varchar(255) NOT NULL,
- CONSTRAINT pk_keyword_id PRIMARY KEY (keyword_id),
- CONSTRAINT keyword_keyword_key UNIQUE (keyword)
-)
-
-
---
--- Index: ind_keyword
---
-CREATE INDEX ind_keyword ON keyword USING btree (keyword);
-
---
--- new table: layer_keyword
---
-CREATE TABLE layer_keyword
-(
- fkey_layer_id int4 NOT NULL,
- fkey_keyword_id int4 NOT NULL,
- CONSTRAINT fkey_keyword_id_fkey_layer_id FOREIGN KEY (fkey_keyword_id)
- REFERENCES keyword (keyword_id) MATCH SIMPLE
- ON UPDATE CASCADE ON DELETE CASCADE,
- CONSTRAINT fkey_layer_id_fkey_keyword_id FOREIGN KEY (fkey_layer_id)
- REFERENCES layer (layer_id) MATCH SIMPLE
- ON UPDATE CASCADE ON DELETE CASCADE
-)
-
-
---
--- new columns in table wms
---
-ALTER TABLE wms ADD fees varchar(255) NULL;
-ALTER TABLE wms ADD accessconstraints text NULL;
-ALTER TABLE wms ADD contactperson varchar(255) NULL;
-ALTER TABLE wms ADD contactposition varchar(255) NULL;
-ALTER TABLE wms ADD contactorganization varchar(255) NULL;
-ALTER TABLE wms ADD address varchar(255) NULL;
-ALTER TABLE wms ADD city varchar(255) NULL;
-ALTER TABLE wms ADD stateorprovince varchar(255) NULL;
-ALTER TABLE wms ADD postcode varchar(255) NULL;
-ALTER TABLE wms ADD country varchar(255) NULL;
-ALTER TABLE wms ADD contactvoicetelephone varchar(255) NULL;
-ALTER TABLE wms ADD contactfacsimiletelephone varchar(255) NULL;
-ALTER TABLE wms ADD contactelectronicmailaddress varchar(255) NULL;
-ALTER TABLE wms ADD wms_mb_getcapabilies_doc text NULL;
-ALTER TABLE wms ADD wms_owner int4 NULL;
-ALTER TABLE wms ADD wms_timestamp int4 NULL;
-
---
--- new columns in table layer
---
-ALTER TABLE layer ADD layer_abstract text NULL;
-
-
---
--- new table: md_topic_category
---
-CREATE TABLE md_topic_category (
- md_topic_category_id serial,
- md_topic_category_code_en varchar(255),
- md_topic_category_code_de varchar(255),
- CONSTRAINT md_topic_category_pkey PRIMARY KEY (md_topic_category_id)
-);
-
-INSERT INTO md_topic_category VALUES (1, 'farming', 'Landwirtschaft');
-INSERT INTO md_topic_category VALUES (2, 'biota', 'Biotope');
-INSERT INTO md_topic_category VALUES (3, 'boundaries', 'Grenzen');
-INSERT INTO md_topic_category VALUES (4, 'climatologyMeteorologyAtmosphere', 'Wetterkunde');
-INSERT INTO md_topic_category VALUES (5, 'economy', 'Wirtschaft');
-INSERT INTO md_topic_category VALUES (6, 'elevation', 'Höhendaten');
-INSERT INTO md_topic_category VALUES (7, 'environment', 'Umwelt');
-INSERT INTO md_topic_category VALUES (8, 'geoscientificInformation', 'Geowissenschaft');
-INSERT INTO md_topic_category VALUES (9, 'health', 'Gesundheit');
-INSERT INTO md_topic_category VALUES (10, 'imageryBaseMapsEarthCover', 'Grundlagenkarten');
-INSERT INTO md_topic_category VALUES (11, 'intelligenceMilitary', 'militärische Aufklärung');
-INSERT INTO md_topic_category VALUES (12, 'inlandWaters', 'Binnengewässer');
-INSERT INTO md_topic_category VALUES (13, 'location', 'Ortsinformationen');
-INSERT INTO md_topic_category VALUES (14, 'oceans', 'Meereskunde');
-INSERT INTO md_topic_category VALUES (15, 'planningCadastre', 'Landnutzung/Planung/Kataster');
-INSERT INTO md_topic_category VALUES (16, 'society', 'Gesellschaft');
-INSERT INTO md_topic_category VALUES (17, 'structure', 'Bauwerke');
-INSERT INTO md_topic_category VALUES (18, 'transportation', 'Transportwesen');
-INSERT INTO md_topic_category VALUES (19, 'utilitiesCommunication', 'Infrastruktur');
-
-
---
--- new table: wms_md_topic_category
---
-CREATE TABLE wms_md_topic_category (
- fkey_wms_id int4 NOT NULL,
- fkey_md_topic_category_id int4 NOT NULL,
- CONSTRAINT wms_md_topic_category_fkey_md_topic_category_id_fkey FOREIGN KEY (fkey_md_topic_category_id)
- REFERENCES md_topic_category (md_topic_category_id) MATCH SIMPLE
- ON UPDATE CASCADE ON DELETE CASCADE,
- 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_form_element_html 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);
+-- no changes in version 2.4.2
+--
\ No newline at end of file
More information about the Mapbender_commits
mailing list