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

[svn_mapbender at osgeo.org]

Author: mifan
Date: 2009-07-05 15:09:14 -0400 (Sun, 05 Jul 2009)
New Revision: 4309

Modified:
   branches/mifan_dev/mapbender/resources/db/pgsql/csw_schema_pgsql_2.8.sql
Log:
table to hold values of cat cap operations - getrecords in particular

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-05 19:07:50 UTC (rev 4308)
+++ branches/mifan_dev/mapbender/resources/db/pgsql/csw_schema_pgsql_2.8.sql	2009-07-05 19:09:14 UTC (rev 4309)
@@ -89,3 +89,23 @@
       REFERENCES cat (cat_id) MATCH SIMPLE
       ON UPDATE CASCADE ON DELETE CASCADE
 );
+
+CREATE TABLE cat_op_conf
+(
+  fk_cat_id integer 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),
+  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);
+
+
+
+
+
+
+
+