svn commit: r665 - trunk/mapbender/resources/db/postgresql/pgsql_schema.sql

[astrid_emde at osgeo.org]

Author: astrid_emde
Date: 2006-07-19 13:29:54+0000
New Revision: 665

Modified:
   trunk/mapbender/resources/db/postgresql/pgsql_schema.sql

Log:
mb_monitor and constraint added

layer_stle.title changed to varchar(100)

Modified: trunk/mapbender/resources/db/postgresql/pgsql_schema.sql
Url: https://mapbender.osgeo.org/source/browse/mapbender/trunk/mapbender/resources/db/postgresql/pgsql_schema.sql?view=diff&rev=665&p1=trunk/mapbender/resources/db/postgresql/pgsql_schema.sql&p2=trunk/mapbender/resources/db/postgresql/pgsql_schema.sql&r1=664&r2=665
==============================================================================
--- trunk/mapbender/resources/db/postgresql/pgsql_schema.sql	(original)
+++ trunk/mapbender/resources/db/postgresql/pgsql_schema.sql	2006-07-19 13:29:54+0000
@@ -182,7 +182,7 @@
 CREATE TABLE layer_style (
     fkey_layer_id integer DEFAULT 0 NOT NULL,
     name character varying(50) DEFAULT ''::character varying NOT NULL,
-    title character varying(50) DEFAULT ''::character varying NOT NULL,
+    title character varying(100) DEFAULT ''::character varying NOT NULL,
     legendurl character varying(255),
     legendurlformat character varying(50)
 );
@@ -218,6 +218,19 @@
     request text
 );
 
+--
+-- Name: 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 ''
+); 
 
 --
 -- Name: mb_user; Type: TABLE; Schema: public; Owner: admin; Tablespace:
@@ -526,6 +539,12 @@
     ADD CONSTRAINT pk_wms_id PRIMARY KEY (wms_id);
 
 
+--
+-- Name: fkey_monitor_wms_id_wms_id 
+--
+
+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;
 
 --
 -- Name: fkey_mb_user_mb_group_mb_use_id; Type: FK CONSTRAINT; Schema: public; Owner: admin