From 53e0f24faade5b543f46e7d89544d92f3709bf7a Mon Sep 17 00:00:00 2001
From: Dan Goodliffe <dan@randomdan.homeip.net>
Date: Mon, 1 Sep 2025 19:35:57 +0100
Subject: Tag entities with their type

---
 src/schema.sql | 2 ++
 1 file changed, 2 insertions(+)

(limited to 'src/schema.sql')

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)
-- 
cgit v1.2.3

