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

[svn_mapbender at osgeo.org]

Author: christoph
Date: 2010-05-03 07:59:02 -0400 (Mon, 03 May 2010)
New Revision: 6060

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.1_to_2.7rc1_pgsql_UTF-8.sql
Log:
new tables

terms of use
layer preview

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-05-03 10:28:45 UTC (rev 6059)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.1_to_2.7rc1_pgsql_UTF-8.sql	2010-05-03 11:59:02 UTC (rev 6060)
@@ -2376,3 +2376,66 @@
 -- element var removeSpatialRequestHighlight for gazetteerWFS
 INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) SELECT gui_element.fkey_gui_id, 'gazetteerWFS', 'removeSpatialRequestHighlight', '0', 'remove spatialrequest highlighting when firing search' ,'var' FROM gui_element WHERE gui_element.e_id = 'gazetteerWFS' AND gui_element.fkey_gui_id NOT IN (SELECT fkey_gui_id FROM gui_element_vars WHERE var_name = 'removeSpatialRequestHighlight' AND fkey_e_id = 'gazetteerWFS');
 
+
+-- compatibility with UI Layout
+UPDATE gui_element SET e_content = '<ul></ul><div class=''ui-layout-content''></div>' WHERE e_id = 'mb_tabs_horizontal';
+
+
+-- Table: layer_preview
+
+CREATE TABLE layer_preview
+(
+  fkey_layer_id integer NOT NULL,
+  layer_map_preview_filename character varying(100),
+  layer_extent_preview_filename character varying(100),
+  layer_legend_preview_filename character varying(100),
+  CONSTRAINT fkey_layer_id FOREIGN KEY (fkey_layer_id)
+      REFERENCES layer (layer_id) MATCH SIMPLE
+      ON UPDATE CASCADE ON DELETE CASCADE,
+  CONSTRAINT layer_preview_fkey_layer_id_key UNIQUE (fkey_layer_id)
+)
+WITH (OIDS=FALSE);
+
+-- Table: termsofuse
+
+CREATE TABLE termsofuse
+(
+  termsofuse_id integer NOT NULL,
+  "name" character varying(255),
+  symbollink character varying(255),
+  description character varying(255),
+  descriptionlink character varying(255),
+  CONSTRAINT termsofuse_pkey PRIMARY KEY (termsofuse_id)
+)
+WITH OIDS;
+
+
+-- Table: wfs_termsofuse
+
+CREATE TABLE wfs_termsofuse
+(
+  fkey_wfs_id integer,
+  fkey_termsofuse_id integer,
+  CONSTRAINT wfs_termsofuse_fkey_wfs_id_fkey FOREIGN KEY (fkey_wfs_id)
+      REFERENCES wfs (wfs_id) MATCH SIMPLE
+      ON UPDATE CASCADE ON DELETE CASCADE,
+  CONSTRAINT wfs_termsofuse_termsofuse_fkey FOREIGN KEY (fkey_termsofuse_id)
+      REFERENCES termsofuse (termsofuse_id) MATCH SIMPLE
+      ON UPDATE CASCADE ON DELETE CASCADE
+)
+WITH OIDS;
+
+-- Table: wms_termsofuse
+
+CREATE TABLE wms_termsofuse
+(
+  fkey_wms_id integer,
+  fkey_termsofuse_id integer,
+  CONSTRAINT wms_termsofuse_termsofuse_fkey FOREIGN KEY (fkey_termsofuse_id)
+      REFERENCES termsofuse (termsofuse_id) MATCH SIMPLE
+      ON UPDATE CASCADE ON DELETE CASCADE,
+  CONSTRAINT wms_termsofuse_wms_fkey FOREIGN KEY (fkey_wms_id)
+      REFERENCES wms (wms_id) MATCH SIMPLE
+      ON UPDATE CASCADE ON DELETE CASCADE
+)
+WITH OIDS;