summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorDan Goodliffe <dan.goodliffe@octal.co.uk>2025-09-02 14:23:11 +0100
committerDan Goodliffe <dan.goodliffe@octal.co.uk>2025-09-02 14:23:11 +0100
commit31cdf70cadf5bc135369a4bbf7f3641b4f0abb99 (patch)
treefc366c7bfe216d91b254aec4d422168028f70c8b
parent53e0f24faade5b543f46e7d89544d92f3709bf7a (diff)
downloadwebstat-31cdf70cadf5bc135369a4bbf7f3641b4f0abb99.tar.bz2
webstat-31cdf70cadf5bc135369a4bbf7f3641b4f0abb99.tar.xz
webstat-31cdf70cadf5bc135369a4bbf7f3641b4f0abb99.zip
Add entity detail column
-rw-r--r--src/schema.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/src/schema.sql b/src/schema.sql
index eddea2d..3c6285b 100644
--- a/src/schema.sql
+++ b/src/schema.sql
@@ -6,6 +6,7 @@ CREATE TABLE entities (
id bigint NOT NULL,
value text NOT NULL,
type entity NOT NULL,
+ detail jsonb,
CONSTRAINT pk_entities PRIMARY KEY(id),
CONSTRAINT uni_entities_value UNIQUE(value)