diff options
| author | Dan Goodliffe <dan@randomdan.homeip.net> | 2025-09-01 19:35:57 +0100 |
|---|---|---|
| committer | Dan Goodliffe <dan@randomdan.homeip.net> | 2025-09-01 20:03:42 +0100 |
| commit | 53e0f24faade5b543f46e7d89544d92f3709bf7a (patch) | |
| tree | a20adc0c8357ed9a6346f8609a0dcfbbd9dd5d5e /src/schema.sql | |
| parent | 53a42351b97db6c84fb930b9eb9c89d694956bca (diff) | |
| download | webstat-53e0f24faade5b543f46e7d89544d92f3709bf7a.tar.bz2 webstat-53e0f24faade5b543f46e7d89544d92f3709bf7a.tar.xz webstat-53e0f24faade5b543f46e7d89544d92f3709bf7a.zip | |
Tag entities with their typewebstat-0.1.1
Diffstat (limited to 'src/schema.sql')
| -rw-r--r-- | src/schema.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/src/schema.sql b/src/schema.sql index 48aacb0..eddea2d 100644 --- a/src/schema.sql +++ b/src/schema.sql @@ -1,9 +1,11 @@ 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 TABLE entities ( id bigint NOT NULL, value text NOT NULL, + type entity NOT NULL, CONSTRAINT pk_entities PRIMARY KEY(id), CONSTRAINT uni_entities_value UNIQUE(value) |