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

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2010-10-10 22:17:08 -0700 (Sun, 10 Oct 2010)
New Revision: 7036

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.2_to_2.7rc1_pgsql_UTF-8.sql
Log:
Add table to admin wmc preview files

Modified: trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.2_to_2.7rc1_pgsql_UTF-8.sql
===================================================================
--- trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.2_to_2.7rc1_pgsql_UTF-8.sql	2010-10-11 05:10:31 UTC (rev 7035)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.2_to_2.7rc1_pgsql_UTF-8.sql	2010-10-11 05:17:08 UTC (rev 7036)
@@ -2939,5 +2939,23 @@
 --
 UPDATE gui_element SET e_attributes='', e_js_file='mod_searchCSW_ajax_button.php' WHERE e_id='addCSW';
 
+-- add possibility to store previews for wmc docs 
+-- Table: wmc_preview
 
+-- DROP TABLE wmc_preview;
 
+CREATE TABLE wmc_preview
+(
+  fkey_wmc_serial_id integer NOT NULL,
+  wmc_preview_filename character varying(100),
+  CONSTRAINT c_fkey_wmc_serial_id FOREIGN KEY (fkey_wmc_serial_id)
+      REFERENCES mb_user_wmc (wmc_serial_id) MATCH SIMPLE
+      ON UPDATE CASCADE ON DELETE CASCADE,
+  CONSTRAINT wmc_fkey_layer_id_key UNIQUE (fkey_wmc_serial_id)
+)
+WITH (
+  OIDS=FALSE
+);
+ALTER TABLE wmc_preview OWNER TO postgres;
+
+