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

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2010-03-29 08:06:04 -0400 (Mon, 29 Mar 2010)
New Revision: 5856

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.1_to_2.7rc1_pgsql_UTF-8.sql
Log:
adopt db schema to admin ows metadataurl entries

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-03-29 11:47:08 UTC (rev 5855)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.1_to_2.7rc1_pgsql_UTF-8.sql	2010-03-29 12:06:04 UTC (rev 5856)
@@ -2196,6 +2196,64 @@
           WHERE user_dep.mb_user_id = wfs.wfs_owner) wfs_dep, wfs_featuretype, wfs_element, wfs_conf
   WHERE wfs_featuretype.fkey_wfs_id = wfs_dep.wfs_id AND wfs_featuretype.featuretype_searchable = 1 AND wfs_element.element_type::text ~~ '%Type'::text AND wfs_featuretype.featuretype_id = wfs_element.fkey_featuretype_id AND wfs_featuretype.featuretype_id = wfs_conf.fkey_featuretype_id
   ORDER BY wfs_featuretype.featuretype_id;
+  
+-- Table: content_metadata
+
+-- DROP TABLE content_metadata;
+
+CREATE TABLE content_metadata
+(
+  metadata_id serial NOT NULL,
+  link_type character varying(255),
+  schemaid character varying(32) NOT NULL,
+  origin integer NOT NULL DEFAULT 1,
+  createdate integer,
+  changedate integer,
+  data text NOT NULL,
+  link character varying(255),
+  harvestresult integer,
+  harvestexception text,
+  uuid character varying(250),
+  title character varying(255),
+  abstract text,
+  temp_reference_1 integer,
+  temp_reference_2 integer,
+  spatial_res_type integer,
+  spatial_res_value character varying(20),
+  ref_system character varying(20),
+  format text,
+  inspire_charset character varying(10),
+  inspire_top_consistance boolean,
+  CONSTRAINT metadata_pkey PRIMARY KEY (metadata_id),
+  CONSTRAINT metadata_uuid_key UNIQUE (uuid)
+)
+WITH OIDS;
+
+
+
+
+
+-- Table: ows_relation_metadata
+
+-- DROP TABLE ows_relation_metadata;
+
+CREATE TABLE ows_relation_metadata
+(
+  fkey_metadata_id integer NOT NULL,
+  fkey_layer_id integer NOT NULL,
+  fkey_featuretype_id integer NOT NULL,
+  CONSTRAINT ows_relation_metadata_fkey_layer_id_fkey FOREIGN KEY (fkey_layer_id)
+      REFERENCES layer (layer_id) MATCH SIMPLE
+      ON UPDATE CASCADE ON DELETE CASCADE,
+  CONSTRAINT ows_relation_metadata_fkey_featuretype_id_fkey FOREIGN KEY (fkey_featuretype_id)
+      REFERENCES wfs_featuretype (featuretype_id) MATCH SIMPLE
+      ON UPDATE CASCADE ON DELETE CASCADE,
+  CONSTRAINT ows_relation_metadata_fkey_metadata_id_fkey FOREIGN KEY (fkey_metadata_id)
+      REFERENCES content_metadata (metadata_id) MATCH SIMPLE
+      ON UPDATE CASCADE ON DELETE CASCADE
+)
+WITHOUT OIDS;
+
 ----  
 -------