[Mapbender-commits] r8317 - trunk/mapbender/resources/db/pgsql/UTF-8/update

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2012-04-19 00:06:13 -0700 (Thu, 19 Apr 2012)
New Revision: 8317

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.2_to_2.7.3_pgsql_UTF-8.sql
Log:
New table for ows scheduler

Modified: trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.2_to_2.7.3_pgsql_UTF-8.sql
===================================================================
--- trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.2_to_2.7.3_pgsql_UTF-8.sql	2012-04-19 06:45:04 UTC (rev 8316)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.2_to_2.7.3_pgsql_UTF-8.sql	2012-04-19 07:06:13 UTC (rev 8317)
@@ -242,3 +242,48 @@
 
 UPDATE translations SET msgstr = 'Kartenprojektion ändern' WHERE msgstr = 'Karenprojektion ändern';
 
+ALTER TABLE gui_wms ADD COLUMN gui_wms_parent_gui character varying(50);
+
+ALTER TABLE gui_wms ADD CONSTRAINT gui_wms_ibfk_5 FOREIGN KEY (gui_wms_parent_gui) REFERENCES gui (gui_id) MATCH SIMPLE ON UPDATE CASCADE ON DELETE CASCADE; -- delete wms from gui, if original gui will be deleted!
+
+
+ALTER TABLE gui_wms ADD COLUMN gui_wms_timestamp TIMESTAMP WITHOUT TIME ZONE;
+UPDATE gui_wms SET gui_wms_timestamp = to_timestamp('1970-01-01','YYYY-MM-DD') WHERE gui_wms_timestamp IS NULL;
+ALTER TABLE gui_wms ALTER COLUMN gui_wms_timestamp SET NOT NULL;
+ALTER TABLE gui_wms ALTER COLUMN gui_wms_timestamp SET DEFAULT now();
+
+-- Table: scheduler - is used to schedule ows updates
+
+-- DROP TABLE scheduler;
+
+CREATE TABLE scheduler
+(
+  scheduler_id serial NOT NULL,
+  scheduler_type character varying(50) NOT NULL DEFAULT ''::character varying,
+  fkey_wms_id integer,
+  fkey_wfs_id integer,
+  fkey_dataurl_id integer,
+  scheduler_interval interval,
+  scheduler_mail integer,
+  scheduler_publish integer,
+  scheduler_searchable integer,
+  scheduler_create timestamp without time zone,
+  scheduler_change timestamp without time zone,
+  scheduler_status integer,
+  scheduler_status_error_message text,
+  scheduler_overwrite integer,
+  CONSTRAINT pk_scheduler_id PRIMARY KEY (scheduler_id),
+  CONSTRAINT scheduler_fkey_wfs_id_fkey FOREIGN KEY (fkey_wfs_id)
+      REFERENCES wfs (wfs_id) MATCH SIMPLE
+      ON UPDATE CASCADE ON DELETE CASCADE,
+  CONSTRAINT scheduler_fkey_wms_id_fkey FOREIGN KEY (fkey_wms_id)
+      REFERENCES wms (wms_id) MATCH SIMPLE
+      ON UPDATE CASCADE ON DELETE CASCADE
+)
+WITH (
+  OIDS=FALSE
+);
+ALTER TABLE scheduler OWNER TO postgres;
+
+
+