[Mapbender-commits] r4382 - branches/mifan_dev/mapbender/resources/db/pgsql

[svn_mapbender at osgeo.org]

Author: mifan
Date: 2009-07-20 03:25:00 -0400 (Mon, 20 Jul 2009)
New Revision: 4382

Modified:
   branches/mifan_dev/mapbender/resources/db/pgsql/csw_schema_pgsql_2.8.sql
Log:
changes to schema - handle multiple op values

Modified: branches/mifan_dev/mapbender/resources/db/pgsql/csw_schema_pgsql_2.8.sql
===================================================================
--- branches/mifan_dev/mapbender/resources/db/pgsql/csw_schema_pgsql_2.8.sql	2009-07-17 08:54:27 UTC (rev 4381)
+++ branches/mifan_dev/mapbender/resources/db/pgsql/csw_schema_pgsql_2.8.sql	2009-07-20 07:25:00 UTC (rev 4382)
@@ -6,11 +6,6 @@
   cat_title character varying(255) NOT NULL DEFAULT ''::character varying, --ows-service-id:title
   cat_abstract text, --ows-service-id:abstract
   --cat_keywords do we need them? There maybe a special table? - cs:keywords - another table to hold kw
-  --Relevant Operations Metadata Sections in XML
-  cat_op_getcapabilities text NOT NULL DEFAULT ''::text,
-  cat_op_describerecord text,
-  cat_op_getrecords text,
-  cat_op_getrecordbyid text,
   --UploadUrl
   cat_upload_url character varying(255),
   fees character varying(50), --servicetype-fees
@@ -93,6 +88,7 @@
 CREATE TABLE cat_op_conf
 (
   fk_cat_id integer NOT NULL,
+  param_type character varying(255) NOT NULL,
   param_name character varying(255) NOT NULL,
   param_value text NOT NULL,
   CONSTRAINT pk_cons PRIMARY KEY (fk_cat_id, param_name, param_value),