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

[astrid_emde at osgeo.org]

Author: astrid_emde
Date: 2006-07-19 13:30:33+0000
New Revision: 666

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

Log:
mb_monitor and constraint added

layer_stle.title changed to varchar(100)

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=666&p1=trunk/mapbender/resources/db/mysql/mysql_schema.sql&p2=trunk/mapbender/resources/db/mysql/mysql_schema.sql&r1=665&r2=666
==============================================================================
--- trunk/mapbender/resources/db/mysql/mysql_schema.sql	(original)
+++ trunk/mapbender/resources/db/mysql/mysql_schema.sql	2006-07-19 13:30:33+0000
@@ -217,7 +217,7 @@
 CREATE TABLE layer_style (
   fkey_layer_id int(11) NOT NULL default '0',
   name varchar(50) NOT NULL default '',
-  title varchar(50) NOT NULL default '',
+  title varchar(100) NOT NULL default '',
   legendurl varchar(255) default NULL,
   legendurlformat varchar(50) default NULL,
   KEY layer_index (fkey_layer_id)
@@ -261,9 +261,24 @@
 -- --------------------------------------------------------
 
 --
--- Tabellenstruktur für Tabelle `mb_user`
+-- Tabellenstruktur für Tabelle 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;
+
+-- --------------------------------------------------------
 
+--
+-- Tabellenstruktur für Tabelle `mb_user`
+--
 CREATE TABLE mb_user (
   mb_user_id int(11) NOT NULL auto_increment,
   mb_user_name varchar(50) NOT NULL default '',
@@ -553,6 +568,11 @@
   ADD CONSTRAINT `layer_style_ibfk_1` FOREIGN KEY (`fkey_layer_id`) REFERENCES `layer` (`layer_id`) ON DELETE CASCADE ON UPDATE CASCADE;
 
 --
+-- Constraints der Tabelle mb_monitor
+--
+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;
+
+--
 -- Constraints der Tabelle `mb_user_mb_group`
 --
 ALTER TABLE `mb_user_mb_group`