[Mapbender-commits] r1005 - trunk/mapbender/resources/db/update
svn_mapbender at osgeo.org
svn_mapbender at osgeo.org
Tue Jan 16 06:01:36 EST 2007
Author: astrid_emde
Date: 2007-01-16 06:01:36 -0500 (Tue, 16 Jan 2007)
New Revision: 1005
Modified:
trunk/mapbender/resources/db/update/update_mysql_db.sql
Log:
dbchanges version 2.4.1
Modified: trunk/mapbender/resources/db/update/update_mysql_db.sql
===================================================================
--- trunk/mapbender/resources/db/update/update_mysql_db.sql 2007-01-16 09:49:33 UTC (rev 1004)
+++ trunk/mapbender/resources/db/update/update_mysql_db.sql 2007-01-16 11:01:36 UTC (rev 1005)
@@ -1,75 +1,108 @@
--
--- changes in version 2.4
+-- changes in version 2.4.1
--
--
--- new table: mb_monitor
+-- new table: keyword
--
-CREATE TABLE mb_monitor (
- upload_id varchar(255) NOT NULL default '',
- fkey_wms_id int NOT NULL default '0',
- status int4 NOT NULL,
- status_comment varchar(255) NOT NULL default '',
- timestamp_begin int4 NOT NULL,
- timestamp_end int4 NOT NULL,
- upload_url varchar(255) NOT NULL default '',
- updated char(1) NOT NULL default ''
+CREATE TABLE keyword
+(
+keyword_id int(11) NOT NULL auto_increment,
+keyword varchar(255) NOT NULL,
+PRIMARY KEY (keyword_id)
) TYPE = InnoDb;
-ALTER TABLE mb_monitor ADD CONSTRAINT mb_monitor_ibfk_1 FOREIGN KEY (fkey_wms_id) REFERENCES wms (wms_id) ON DELETE CASCADE ON UPDATE CASCADE;
-
-
+ALTER TABLE keyword
+ ADD CONSTRAINT keyword_keyword_key UNIQUE (keyword);
+
--
--- new table: wfs_featuretype_namespace
+-- Index: ind_keyword
--
-CREATE TABLE `wfs_featuretype_namespace` (
- `fkey_wfs_id` int(11) NOT NULL default '0',
- `fkey_featuretype_id` int(11) NOT NULL default '0',
- `namespace` varchar(255) NOT NULL default '',
- `namespace_location` varchar(255) NOT NULL default '',
- KEY `wfs_id` (`fkey_wfs_id`),
- KEY `featuretype_id` (`fkey_featuretype_id`)
-) TYPE=InnoDB;
+ALTER TABLE `keyword` ADD INDEX `ind_keyword` ( `keyword` ) ;
-ALTER TABLE `wfs_featuretype_namespace`
- ADD CONSTRAINT `wfs_featuretype_namespace_ibfk_2` FOREIGN KEY (`fkey_featuretype_id`) REFERENCES `wfs_featuretype` (`featuretype_id`) ON DELETE CASCADE ON UPDATE CASCADE,
- ADD CONSTRAINT `wfs_featuretype_namespace_ibfk_1` FOREIGN KEY (`fkey_wfs_id`) REFERENCES `wfs` (`wfs_id`) ON DELETE CASCADE ON UPDATE CASCADE;
-
-
--
--- new column wms_owsproxy in table wms
+-- new table: layer_keyword
--
-ALTER TABLE wms ADD wms_owsproxy VARCHAR(50) NULL ;
+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;
---
--- new column wfs_owsproxy in table wfs
---
-ALTER TABLE wfs ADD wfs_owsproxy VARCHAR( 50 ) NULL ;
+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 column wms_upload_url in table wms
+-- new columns in table wms
--
-ALTER TABLE wms ADD wms_upload_url VARCHAR(255) NULL ;
+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;
-UPDATE wms set wms_upload_url = wms_getcapabilities;
-
--
--- new column e_url in table gui_element
+-- new table: md_topic_category
--
-ALTER TABLE gui_element ADD e_url VARCHAR( 255 ) NULL ;
+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;
+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');
-Update gui_element set e_mb_mod = 'mod_addWMSgeneralFunctions.js' where e_id = 'addWMSfromList' or e_id = 'addWMSfromfilteredList' ;
-
--
--- table layer_style, column title was too small. length changed to 100 from 50
+-- new table: wms_md_topic_category
--
-ALTER TABLE layer_style CHANGE title title VARCHAR(100);
+CREATE TABLE wms_md_topic_category (
+ fkey_wms_id int(11) NOT NULL,
+ fkey_md_topic_category_id int(11) NOT NULL
+)TYPE = InnoDb;
+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;
-
More information about the Mapbender_commits
mailing list