svn commit: r663 - trunk/mapbender/resources/db/update/update_postgresql_db.sql

[astrid_emde at osgeo.org]

Author: astrid_emde
Date: 2006-07-19 13:29:01+0000
New Revision: 663

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

Log:
mb_monitor and constraint added

layer_stle.title changed to varchar(100)

Modified: trunk/mapbender/resources/db/update/update_postgresql_db.sql
Url: https://mapbender.osgeo.org/source/browse/mapbender/trunk/mapbender/resources/db/update/update_postgresql_db.sql?view=diff&rev=663&p1=trunk/mapbender/resources/db/update/update_postgresql_db.sql&p2=trunk/mapbender/resources/db/update/update_postgresql_db.sql&r1=662&r2=663
==============================================================================
--- trunk/mapbender/resources/db/update/update_postgresql_db.sql	(original)
+++ trunk/mapbender/resources/db/update/update_postgresql_db.sql	2006-07-19 13:29:01+0000
@@ -3,6 +3,25 @@
 --
 
 --
+-- 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 ''
+); 
+
+ALTER TABLE ONLY mb_monitor
+    ADD CONSTRAINT fkey_monitor_wms_id_wms_id  FOREIGN KEY (fkey_wms_id) REFERENCES wms(wms_id) ON UPDATE CASCADE ON DELETE CASCADE;
+
+
+
+--
 -- new table: wfs_featuretype_namespace
 --
 CREATE TABLE wfs_featuretype_namespace (
@@ -41,8 +60,12 @@
 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' ;
+
+--
+-- table layer_style, column title was too small. length changed to 100 from 50
+--
+ALTER TABLE layer_style ALTER COLUMN title TYPE varchar(100);