From 7ec58bf3f72fd7e0396a37f43ff023731697ff8a Mon Sep 17 00:00:00 2001
From: Dan Goodliffe <dan@randomdan.homeip.net>
Date: Sat, 23 Aug 2025 17:28:37 +0100
Subject: Store log lines in full using entity ids

---
 src/sql/accessLogInsert.sql | 4 ++++
 1 file changed, 4 insertions(+)
 create mode 100644 src/sql/accessLogInsert.sql

(limited to 'src/sql/accessLogInsert.sql')

diff --git a/src/sql/accessLogInsert.sql b/src/sql/accessLogInsert.sql
new file mode 100644
index 0000000..e0c39b8
--- /dev/null
+++ b/src/sql/accessLogInsert.sql
@@ -0,0 +1,4 @@
+INSERT INTO
+access_log(hostname, virtual_host, remoteip, request_time, method, path, query_string, protocol, status, size, duration,
+		referrer, user_agent)
+VALUES(?, ?, ?, TO_TIMESTAMP(? / 1000000.0) at time zone 'utc', ?, ?, ?, ?, ?, ?, ? * '1us'::interval, ?, ?)
-- 
cgit v1.2.3

