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

[svn_mapbender at osgeo.org]

Author: christoph
Date: 2010-08-06 09:33:07 +0000 (Fri, 06 Aug 2010)
New Revision: 6708

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.1_to_2.7rc1_pgsql_UTF-8.sql
Log:
added missing foreign key in layer_load_count

Modified: trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.1_to_2.7rc1_pgsql_UTF-8.sql
===================================================================
--- trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.1_to_2.7rc1_pgsql_UTF-8.sql	2010-08-06 08:57:35 UTC (rev 6707)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.1_to_2.7rc1_pgsql_UTF-8.sql	2010-08-06 09:33:07 UTC (rev 6708)
@@ -2538,3 +2538,7 @@
 -- overview: initWms.php is replaced by initWmcObj.php
 UPDATE gui_element SET e_mb_mod = '../../lib/history.js,map_obj.js,map.js,wms.js,wfs_obj.js,initWmcObj.php' WHERE e_id = 'overview';
 
+-- missing foreign key in layer_load_count
+ALTER TABLE ONLY layer_load_count
+    ADD CONSTRAINT layer_load_count_fkey_layer_id_fkey FOREIGN KEY (fkey_layer_id) REFERENCES layer (layer_id) ON UPDATE CASCADE ON DELETE CASCADE;
+