[Mapbender-commits] r5856 -
trunk/mapbender/resources/db/pgsql/UTF-8/update
svn_mapbender at osgeo.org
svn_mapbender at osgeo.org
Mon Mar 29 08:06:11 EDT 2010
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;
+
----
-------
More information about the Mapbender_commits
mailing list