From 6e549d226b0ebce6ecdce0e7c5f03a0ce4867a89 Mon Sep 17 00:00:00 2001
From: Dan Goodliffe <dan@randomdan.homeip.net>
Date: Mon, 25 Aug 2025 13:08:16 +0100
Subject: Use SQL standard identity column

---
 src/schema.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'src/schema.sql')

diff --git a/src/schema.sql b/src/schema.sql
index 4ac3d84..48aacb0 100644
--- a/src/schema.sql
+++ b/src/schema.sql
@@ -10,7 +10,7 @@ CREATE TABLE entities (
 );
 
 CREATE TABLE access_log (
-	id serial NOT NULL,
+	id bigint GENERATED ALWAYS AS IDENTITY,
 	hostname bigint NOT NULL,
 	virtual_host bigint NOT NULL,
 	remoteip inet NOT NULL,
-- 
cgit v1.2.3

