diff options
| author | Dan Goodliffe <dan.goodliffe@octal.co.uk> | 2025-09-23 13:31:26 +0100 |
|---|---|---|
| committer | Dan Goodliffe <dan.goodliffe@octal.co.uk> | 2025-09-23 13:31:26 +0100 |
| commit | 71803b97f1c9e31f2027da48bb742353f9c43e62 (patch) | |
| tree | 99f418aa8cf4d4dd9edd2de1985295c48b4ba904 /src/schema.sql | |
| parent | 4785b4d8c5bac4e03ed8dd2a4c01ec098da60d7b (diff) | |
| download | webstat-71803b97f1c9e31f2027da48bb742353f9c43e62.tar.bz2 webstat-71803b97f1c9e31f2027da48bb742353f9c43e62.tar.xz webstat-71803b97f1c9e31f2027da48bb742353f9c43e62.zip | |
Write unparsable lines to the entity table
Diagnostics and the ability to ingest later.
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 3c6285b..4f3b205 100644 --- a/src/schema.sql +++ b/src/schema.sql @@ -1,6 +1,6 @@ CREATE TYPE http_verb AS ENUM('GET', 'HEAD', 'OPTIONS', 'TRACE', 'PUT', 'DELETE', 'POST', 'PATCH', 'CONNECT'); CREATE TYPE protocol AS ENUM('HTTP/1.0', 'HTTP/1.1', 'HTTP/1.2', 'HTTP/1.3', 'HTTP/2.0', 'HTTPS/3.0'); -CREATE TYPE entity AS ENUM('host', 'virtual_host', 'path', 'query_string', 'referrer', 'user_agent'); +CREATE TYPE entity AS ENUM('host', 'virtual_host', 'path', 'query_string', 'referrer', 'user_agent', 'unparsable_line'); CREATE TABLE entities ( id bigint NOT NULL, |