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

[astrid_emde at osgeo.org]

Author: astrid_emde
Date: 2006-07-19 13:29:22+0000
New Revision: 664

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

Log:
mb_monitor and constraint added

layer_stle.title changed to varchar(100)

Modified: 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=diff&rev=664&p1=trunk/mapbender/resources/db/update/update_mysql_db.sql&p2=trunk/mapbender/resources/db/update/update_mysql_db.sql&r1=663&r2=664
==============================================================================
--- trunk/mapbender/resources/db/update/update_mysql_db.sql	(original)
+++ trunk/mapbender/resources/db/update/update_mysql_db.sql	2006-07-19 13:29:22+0000
@@ -3,6 +3,23 @@
 --
 
 --
+-- new table: mb_monitor
+--
+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 ''
+) 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;
+
+
+--
 -- new table: wfs_featuretype_namespace
 --
 CREATE TABLE `wfs_featuretype_namespace` (
@@ -46,6 +63,13 @@
 
 
 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
+--
+ALTER TABLE layer_style CHANGE title title VARCHAR(100);
+
+