diff options
| author | Dan Goodliffe <dan@randomdan.homeip.net> | 2025-08-25 13:08:16 +0100 |
|---|---|---|
| committer | Dan Goodliffe <dan@randomdan.homeip.net> | 2025-08-25 16:02:50 +0100 |
| commit | 6e549d226b0ebce6ecdce0e7c5f03a0ce4867a89 (patch) | |
| tree | 1ee7424999841d45346c6ca4ec85d3d325c28b61 /src/schema.sql | |
| parent | 21a9cb6866afe3354bee60d852ebffc7ef3a8355 (diff) | |
| download | webstat-6e549d226b0ebce6ecdce0e7c5f03a0ce4867a89.tar.bz2 webstat-6e549d226b0ebce6ecdce0e7c5f03a0ce4867a89.tar.xz webstat-6e549d226b0ebce6ecdce0e7c5f03a0ce4867a89.zip | |
Use SQL standard identity column
Diffstat (limited to 'src/schema.sql')
| -rw-r--r-- | src/schema.sql | 2 |
1 files changed, 1 insertions, 1 deletions
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, |