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

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2010-10-12 02:19:53 -0700 (Tue, 12 Oct 2010)
New Revision: 7040

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.2_to_2.7rc1_pgsql_UTF-8.sql
Log:
new table wmc_load_count to rank using of wmc docs

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-12 07:20:11 UTC (rev 7039)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.2_to_2.7rc1_pgsql_UTF-8.sql	2010-10-12 09:19:53 UTC (rev 7040)
@@ -2963,5 +2963,28 @@
   OIDS=FALSE
 );
 ALTER TABLE wmc_preview OWNER TO postgres;
+-- Table wmc_load_count
 
+-- DROP TABLE wmc_load_count;
 
+CREATE TABLE wmc_load_count
+(
+  fkey_wmc_serial_id integer,
+  load_count bigint,
+  CONSTRAINT wmc_load_count_fkey_wmc_serial_id_fkey FOREIGN KEY (fkey_wmc_serial_id)
+      REFERENCES mb_user_wmc (wmc_serial_id) MATCH SIMPLE
+      ON UPDATE CASCADE ON DELETE CASCADE
+)
+WITH (OIDS=TRUE);
+ALTER TABLE wmc_load_count OWNER TO postgres;
+
+-- Index: idx_fkey_layer_id
+
+-- DROP INDEX idx_fkey_layer_id;
+
+CREATE INDEX idx_fkey_wmc_serial_id
+  ON wmc_load_count
+  USING btree
+  (fkey_wmc_serial_id);
+
+