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

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2015-11-25 04:46:12 -0800 (Wed, 25 Nov 2015)
New Revision: 9315

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql
Log:
Extent information model to handle licence source notes at resource level (wms, wfs, md), new option to handle standardized licences at metadata level

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	2015-11-25 08:40:13 UTC (rev 9314)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql	2015-11-25 12:46:12 UTC (rev 9315)
@@ -656,4 +656,41 @@
 
 ALTER TABLE mb_user_wmc ADD COLUMN uuid uuid;
 
+-- Table: md_termsofuse
 
+-- DROP TABLE md_termsofuse;
+
+CREATE TABLE md_termsofuse
+(
+  fkey_metadata_id integer,
+  fkey_termsofuse_id integer,
+  CONSTRAINT md_termsofuse_termsofuse_fkey FOREIGN KEY (fkey_termsofuse_id)
+      REFERENCES termsofuse (termsofuse_id) MATCH SIMPLE
+      ON UPDATE CASCADE ON DELETE CASCADE,
+  CONSTRAINT md_termsofuse_md_fkey FOREIGN KEY (fkey_metadata_id)
+      REFERENCES mb_metadata (metadata_id) MATCH SIMPLE
+      ON UPDATE CASCADE ON DELETE CASCADE
+)
+WITH (
+  OIDS=FALSE
+);
+ALTER TABLE md_termsofuse
+  OWNER TO postgres;
+
+-- Column: wms_licence_source_note
+
+-- ALTER TABLE wms DROP COLUMN wms_licence_source_note;
+
+ALTER TABLE wms ADD COLUMN wms_licence_source_note text DEFAULT null;
+
+-- Column: wfs_licence_source_note
+
+-- ALTER TABLE wfs DROP COLUMN wfs_licence_source_note;
+
+ALTER TABLE wfs ADD COLUMN wfs_licence_source_note text DEFAULT null;
+
+-- Column: md_licence_source_note
+
+-- ALTER TABLE mb_metadata DROP COLUMN md_licence_source_note;
+
+ALTER TABLE mb_metadata ADD COLUMN md_licence_source_note text DEFAULT null;