From 6e549d226b0ebce6ecdce0e7c5f03a0ce4867a89 Mon Sep 17 00:00:00 2001 From: Dan Goodliffe 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