svn commit: r400 - trunk/mapbender/resources/db/mysql/mysql_schema.sql

[astrid_emde at osgeo.org]

Author: astrid_emde
Date: 2006-06-09 12:21:10+0000
New Revision: 400

Modified:
   trunk/mapbender/resources/db/mysql/mysql_schema.sql

Log:
db schema for Version 2.4

Modified: trunk/mapbender/resources/db/mysql/mysql_schema.sql
Url: https://mapbender.osgeo.org/source/browse/mapbender/trunk/mapbender/resources/db/mysql/mysql_schema.sql?view=diff&rev=400&p1=trunk/mapbender/resources/db/mysql/mysql_schema.sql&p2=trunk/mapbender/resources/db/mysql/mysql_schema.sql&r1=399&r2=400
==============================================================================
--- trunk/mapbender/resources/db/mysql/mysql_schema.sql	(original)
+++ trunk/mapbender/resources/db/mysql/mysql_schema.sql	2006-06-09 12:21:10+0000
@@ -45,6 +45,7 @@
   e_mb_mod varchar(50) default NULL,
   e_target varchar(50) default NULL,
   e_requires varchar(50) default NULL,
+  e_url VARCHAR(255) NULL,
   PRIMARY KEY  (fkey_gui_id,e_id),
   KEY idx_gui_id_e_id (fkey_gui_id,e_id)
 ) TYPE=InnoDB;
@@ -330,6 +331,7 @@
   wfs_describefeaturetype varchar(255) default NULL,
   wfs_getfeature varchar(255) default NULL,
   wfs_transaction varchar(255) default NULL,
+  wfs_owsproxy VARCHAR(50) NULL,
   PRIMARY KEY  (wfs_id),
   KEY wfs_ (wfs_id)
 ) TYPE=InnoDB;
@@ -416,6 +418,21 @@
 -- --------------------------------------------------------
 
 --
+-- Tabellenstruktur für Tabelle `wfs_featuretype_namespace`
+--
+
+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;
+
+-- --------------------------------------------------------
+
+--
 -- Tabellenstruktur für Tabelle `wms`
 --
 
@@ -430,6 +447,8 @@
   wms_getlegendurl varchar(255) default NULL,
   wms_filter varchar(255) default NULL,
   wms_getcapabilities_doc longtext,
+  wms_owsproxy VARCHAR(50) NULL,
+  wms_upload_url VARCHAR(255) NULL,
   PRIMARY KEY  (wms_id)
 ) TYPE=InnoDB;
 
@@ -571,6 +590,14 @@
   ADD CONSTRAINT `wfs_featuretype_ibfk_1` FOREIGN KEY (`fkey_wfs_id`) REFERENCES `wfs` (`wfs_id`) ON DELETE CASCADE ON UPDATE CASCADE;
 
 --
+-- Constraints der Tabelle `wfs_featuretype_namespace`
+--
+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;
+
+
+--
 -- Constraints der Tabelle `wms_format`
 --
 ALTER TABLE `wms_format`