svn commit: r619 - trunk/mapbender/resources/db/update/update_mysql_db.sql

[astrid_emde at osgeo.org]

Author: astrid_emde
Date: 2006-06-22 15:07:18+0000
New Revision: 619

Added:
   trunk/mapbender/resources/db/update/update_mysql_db.sql

Log:


Added: trunk/mapbender/resources/db/update/update_mysql_db.sql
Url: https://mapbender.osgeo.org/source/browse/mapbender/trunk/mapbender/resources/db/update/update_mysql_db.sql?view=auto&rev=619
==============================================================================
--- (empty file)
+++ trunk/mapbender/resources/db/update/update_mysql_db.sql	2006-06-22 15:07:18+0000
@@ -0,0 +1,51 @@
+--
+-- changes in version 2.4
+--
+
+--
+-- new table: 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;
+
+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
+--
+ALTER TABLE wms ADD wms_owsproxy VARCHAR(50) NULL ;
+
+
+--
+-- new column wfs_owsproxy in table wfs
+--
+ALTER TABLE wfs ADD wfs_owsproxy VARCHAR( 50 ) NULL ;
+
+
+--
+-- new column wms_upload_url in table wms
+--
+ALTER TABLE wms ADD wms_upload_url VARCHAR(255) NULL ;
+
+UPDATE wms set wms_upload_url = wms_getcapabilities;
+
+
+--
+-- new column e_url in table gui_element
+--
+ALTER TABLE gui_element ADD e_url VARCHAR( 255 ) NULL ;
+
+
+Update gui_element set e_mb_mod = 'mod_addWMSgeneralFunctions.js' where e_id = 'addWMSfromList' or e_id = 'addWMSfromfilteredList' ;
+ 
+
+