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

[svn_mapbender at osgeo.org]

Author: astrid_emde
Date: 2007-01-26 11:42:56 -0500 (Fri, 26 Jan 2007)
New Revision: 1068

Modified:
   trunk/mapbender/resources/db/mysql/mysql_schema.sql
Log:
new database for mapbender 2.4.1

Modified: trunk/mapbender/resources/db/mysql/mysql_schema.sql
===================================================================
--- trunk/mapbender/resources/db/mysql/mysql_schema.sql	2007-01-26 14:06:09 UTC (rev 1067)
+++ trunk/mapbender/resources/db/mysql/mysql_schema.sql	2007-01-26 16:42:56 UTC (rev 1068)
@@ -1,7 +1,7 @@
 
 SET FOREIGN_KEY_CHECKS=0;
 --
--- Datenbank: `mb22_release`
+-- Datenbank: mb2.4.1
 --
 
 -- --------------------------------------------------------
@@ -272,7 +272,7 @@
   timestamp_end int4 NOT NULL,
   upload_url varchar(255) NOT NULL default '',
   updated char(1) NOT NULL default ''
-) TYPE = InnoDb;
+) TYPE=InnoDb;
 
 -- --------------------------------------------------------
 
@@ -629,4 +629,114 @@
 ALTER TABLE `wms_srs`
   ADD CONSTRAINT `wms_srs_ibfk_1` FOREIGN KEY (`fkey_wms_id`) REFERENCES `wms` (`wms_id`) ON DELETE CASCADE ON UPDATE CASCADE;
 
+--
+-- changes in version 2.4.1
+--
+
+--
+-- 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;
+
+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 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;
+
+
+
 SET FOREIGN_KEY_CHECKS=1;
\ No newline at end of file