From 5c38bbc52569fea40f1dc656485b3079f918f94e Mon Sep 17 00:00:00 2001
From: Runxi Yu <me@runxiyu.org>
Date: Tue, 12 Aug 2025 09:13:36 +0800
Subject: Add admin user type in constraints

---
 sql/schema.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'sql/schema.sql')

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

