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

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2016-05-23 06:56:21 -0700 (Mon, 23 May 2016)
New Revision: 9471

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql
Log:
bugfix

Modified: trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql
===================================================================
--- trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql	2016-05-23 13:52:41 UTC (rev 9470)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql	2016-05-23 13:56:21 UTC (rev 9471)
@@ -936,6 +936,24 @@
 ALTER FUNCTION f_getmd_tou(integer)
   OWNER TO postgres;
 
+-- Table: metadata_load_count
+
+-- DROP TABLE metadata_load_count;
+
+CREATE TABLE metadata_load_count
+(
+  fkey_metadata_id integer,
+  load_count bigint,
+  CONSTRAINT metadata_load_count_fkey_metadata_id_fkey FOREIGN KEY (fkey_metadata_id)
+      REFERENCES mb_metadata (metadata_id) MATCH SIMPLE
+      ON UPDATE CASCADE ON DELETE CASCADE
+)
+WITH (
+  OIDS=FALSE
+);
+ALTER TABLE metadata_load_count
+  OWNER TO postgres
+
 --new view which integrates the termsofuse for datasets if given 
 
 DROP VIEW search_dataset_view;
@@ -982,24 +1000,8 @@
   OWNER TO postgres;
 
 
--- Table: metadata_load_count
 
--- DROP TABLE metadata_load_count;
 
-CREATE TABLE metadata_load_count
-(
-  fkey_metadata_id integer,
-  load_count bigint,
-  CONSTRAINT metadata_load_count_fkey_metadata_id_fkey FOREIGN KEY (fkey_metadata_id)
-      REFERENCES mb_metadata (metadata_id) MATCH SIMPLE
-      ON UPDATE CASCADE ON DELETE CASCADE
-)
-WITH (
-  OIDS=FALSE
-);
-ALTER TABLE metadata_load_count
-  OWNER TO postgres;
-
 --new table to log invocation of mapbender clients by referrer
 
 -- Table: external_api_log