From 9f1dfacb0f236da5f0413ac20e3376388df7d798 Mon Sep 17 00:00:00 2001
From: Dan Goodliffe <dan@randomdan.homeip.net>
Date: Sat, 17 Jan 2026 18:33:56 +0000
Subject: pg_format schema.sql and sql/*.sql

No changes.
---
 src/sql/accessLogPurgeOld.sql | 19 +++++++++++++------
 1 file changed, 13 insertions(+), 6 deletions(-)

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

diff --git a/src/sql/accessLogPurgeOld.sql b/src/sql/accessLogPurgeOld.sql
index 8379018..18ec775 100644
--- a/src/sql/accessLogPurgeOld.sql
+++ b/src/sql/accessLogPurgeOld.sql
@@ -1,11 +1,18 @@
 WITH scope AS (
-	SELECT id
-	FROM access_log
-	ORDER BY id
+	SELECT
+		id
+	FROM
+		access_log
+	ORDER BY
+		id
 	LIMIT ?
-), scoperange AS (
-	SELECT min(id) minid, max(id) maxid
-	FROM scope)
+),
+scoperange AS (
+	SELECT
+		min(id) minid,
+		max(id) maxid
+	FROM
+		scope)
 DELETE FROM access_log USING scoperange
 WHERE request_time < CURRENT_DATE - ?::interval
 	AND access_log.id BETWEEN scoperange.minid AND scoperange.maxid
-- 
cgit v1.2.3

