diff options
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) |