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

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2014-10-17 02:43:16 -0700 (Fri, 17 Oct 2014)
New Revision: 9101

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql
Log:
Possibility to log access to inspire downloadservices

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	2014-10-17 09:34:16 UTC (rev 9100)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql	2014-10-17 09:43:16 UTC (rev 9101)
@@ -520,6 +520,7 @@
 ALTER TABLE wfs_output_formats
   OWNER TO postgres;
 
+<<<<<<< .mine
 -- Index für proxy-Log-Tabelle
 CREATE INDEX idx_mb_proxy_log_timestamp
 ON mb_proxy_log
@@ -534,3 +535,53 @@
 gui_element.e_id = 'printPDF' AND
 gui_element.fkey_gui_id
 NOT IN (SELECT fkey_gui_id FROM gui_element_vars WHERE fkey_e_id = 'printPDF' AND var_name = 'reverseLegend');
+
+-- Table: inspire_dls_log
+-- DROP TABLE inspire_dls_log;
+
+CREATE TABLE inspire_dls_log
+(
+  log_id serial NOT NULL,
+  createdate timestamp without time zone,
+  lastchanged timestamp without time zone NOT NULL DEFAULT now(),
+  link text, --capabilities and/or atom feed url
+  linktype character varying(100), -- e.g. ATOM Feed, WFS 
+--  dls_service_uuid character varying(100),
+--  metadata_uuid character varying(100), 
+  service_title character varying(250),
+  datasetid text,
+  --datasetid_codespace text,
+  log_count bigint
+)
+WITH (
+  OIDS=FALSE
+);
+ALTER TABLE inspire_dls_log
+  OWNER TO postgres;
+
+-- Trigger: update_inspire_dls_log_lastchanged on inspire_dls_log
+
+-- DROP TRIGGER update_inspire_dls_log_lastchanged ON inspire_dls_log;
+
+CREATE TRIGGER update_inspire_dls_log_lastchanged
+  BEFORE UPDATE
+  ON inspire_dls_log
+  FOR EACH ROW
+  EXECUTE PROCEDURE update_lastchanged_column();
+
+-- Index: idx_ inspire_dls_log_link
+
+-- DROP INDEX idx_ inspire_dls_log_link;
+
+CREATE INDEX idx_inspire_dls_log_link
+  ON inspire_dls_log
+  USING btree
+  (link );
+
+
+-- Index für proxy-Log-Tabelle
+CREATE INDEX idx_mb_proxy_log_timestamp
+ON mb_proxy_log
+USING btree
+(proxy_log_timestamp);
+