[Mapbender-commits] r4461 - trunk/mapbender/resources/db/update

[svn_mapbender at osgeo.org]

Author: christoph
Date: 2009-07-31 05:53:14 -0400 (Fri, 31 Jul 2009)
New Revision: 4461

Modified:
   trunk/mapbender/resources/db/update/update_2.7.sql
Log:
added monitoring subscription table

Modified: trunk/mapbender/resources/db/update/update_2.7.sql
===================================================================
--- trunk/mapbender/resources/db/update/update_2.7.sql	2009-07-31 08:43:04 UTC (rev 4460)
+++ trunk/mapbender/resources/db/update/update_2.7.sql	2009-07-31 09:53:14 UTC (rev 4461)
@@ -215,8 +215,30 @@
   ON mb_monitor
   FOR EACH ROW
   EXECUTE PROCEDURE mb_monitor_after();
+
+
+-- Table: mb_user_abo_ows
+
+-- DROP TABLE mb_user_abo_ows;
+
+CREATE TABLE mb_user_abo_ows
+(
+  fkey_mb_user_id integer,
+  fkey_wms_id integer,
+  fkey_wfs_id integer,
+  CONSTRAINT mb_user_abo_ows_user_id_fkey FOREIGN KEY (fkey_mb_user_id)
+      REFERENCES mb_user (mb_user_id) MATCH SIMPLE
+      ON UPDATE CASCADE ON DELETE CASCADE,
+  CONSTRAINT mb_user_abo_ows_wfs_fkey FOREIGN KEY (fkey_wfs_id)
+      REFERENCES wfs (wfs_id) MATCH SIMPLE
+      ON UPDATE CASCADE ON DELETE CASCADE,
+  CONSTRAINT mb_user_abo_ows_wms_fkey FOREIGN KEY (fkey_wms_id)
+      REFERENCES wms (wms_id) MATCH SIMPLE
+      ON UPDATE CASCADE ON DELETE CASCADE
+)
+WITHOUT OIDS;  
+
   
-  
 -- Index: idx_wms_id
 
 -- DROP INDEX idx_wms_id;