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

[svn_mapbender at osgeo.org]

Author: mifan
Date: 2009-07-20 05:25:29 -0400 (Mon, 20 Jul 2009)
New Revision: 4388

Modified:
   branches/mifan_dev/mapbender/resources/db/pgsql/csw_schema_pgsql_2.8.sql
Log:
change to accomodate multiple cat 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-20 09:22:06 UTC (rev 4387)
+++ branches/mifan_dev/mapbender/resources/db/pgsql/csw_schema_pgsql_2.8.sql	2009-07-20 09:25:29 UTC (rev 4388)
@@ -88,15 +88,14 @@
 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),
+  param_type character varying(255) NOT NULL,
+  CONSTRAINT pk_con_cat_op PRIMARY KEY (fk_cat_id, param_type, param_name, param_value),
   CONSTRAINT fk_cat_conf_to_cat FOREIGN KEY (fk_cat_id)
       REFERENCES cat (cat_id) MATCH SIMPLE
       ON UPDATE CASCADE ON DELETE CASCADE
-)
-WITH (OIDS=FALSE);
+);