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

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2014-08-11 03:39:14 -0700 (Mon, 11 Aug 2014)
New Revision: 9040

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql
Log:
New field in mb_user_wmc to handle licences for stored data in wmc

Modified: trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql
===================================================================
--- trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql	2014-08-11 10:37:54 UTC (rev 9039)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql	2014-08-11 10:39:14 UTC (rev 9040)
@@ -465,4 +465,20 @@
 UPDATE mb_user_wmc SET wmc_has_local_data = 0 WHERE wmc_has_local_data IS NULL;
 ALTER TABLE mb_user_wmc ALTER COLUMN wmc_has_local_data SET DEFAULT 0;
 
+-- Option for allow publication of spatial data **************
 
+-- Column: wmc_local_data_fkey_termsofuse_id
+
+-- ALTER TABLE mb_user_wmc DROP COLUMN wmc_local_data_fkey_termsofuse_id;
+
+ALTER TABLE mb_user_wmc ADD COLUMN wmc_local_data_fkey_termsofuse_id integer;
+
+-- Foreign Key: wmc_local_data_fkey_termsofuse_id
+
+-- ALTER TABLE mb_user_wmc DROP CONSTRAINT wmc_local_data_fkey_termsofuse_id;
+
+ALTER TABLE mb_user_wmc
+  ADD CONSTRAINT wmc_local_data_termsofuse_fkey FOREIGN KEY (wmc_local_data_fkey_termsofuse_id)
+      REFERENCES termsofuse (termsofuse_id) MATCH SIMPLE
+      ON UPDATE CASCADE ON DELETE RESTRICT;
+-- ************************************************************