aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorRunxi Yu <me@runxiyu.org>2025-08-12 09:13:36 +0800
committerRunxi Yu <me@runxiyu.org>2025-08-12 09:13:36 +0800
commit5c38bbc52569fea40f1dc656485b3079f918f94e (patch)
tree98761aac1357ed36cfd44bfb708e596fd5b68247 /sql
parentSticky footer (diff)
downloadforge-5c38bbc52569fea40f1dc656485b3079f918f94e.tar.gz
forge-5c38bbc52569fea40f1dc656485b3079f918f94e.tar.zst
forge-5c38bbc52569fea40f1dc656485b3079f918f94e.zip
Add admin user type in constraints
Diffstat (limited to 'sql')
-rw-r--r--sql/schema.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/schema.sql b/sql/schema.sql
index a6efc39..92ae605 100644
--- a/sql/schema.sql
+++ b/sql/schema.sql
@@ -39,7 +39,7 @@ CREATE TABLE mailing_list_emails (
CREATE TABLE users (
id INTEGER GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
username TEXT UNIQUE,
- type TEXT NOT NULL CHECK (type IN ('pubkey_only', 'federated', 'registered')),
+ type TEXT NOT NULL CHECK (type IN ('pubkey_only', 'federated', 'registered', 'admin')),
password TEXT
);