aboutsummaryrefslogtreecommitdiffhomepage
path: root/backend/schema.sql
diff options
context:
space:
mode:
authornsfisis <nsfisis@gmail.com>2025-03-11 01:23:41 +0900
committernsfisis <nsfisis@gmail.com>2025-03-11 01:23:41 +0900
commita93c441ec4f992ed2f7eeae23fb823b1d152913f (patch)
treec8e7750019849a7100d11ac6b81517ad0d5c98ea /backend/schema.sql
parent57212d2c7992a46827f503ae70c8e31f2084b718 (diff)
downloadiosdc-japan-2025-albatross-a93c441ec4f992ed2f7eeae23fb823b1d152913f.tar.gz
iosdc-japan-2025-albatross-a93c441ec4f992ed2f7eeae23fb823b1d152913f.tar.zst
iosdc-japan-2025-albatross-a93c441ec4f992ed2f7eeae23fb823b1d152913f.zip
feat: show user label
Diffstat (limited to 'backend/schema.sql')
-rw-r--r--backend/schema.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/backend/schema.sql b/backend/schema.sql
index 8c63ff2..6550fcd 100644
--- a/backend/schema.sql
+++ b/backend/schema.sql
@@ -4,6 +4,7 @@ CREATE TABLE users (
display_name VARCHAR(64) NOT NULL,
icon_path VARCHAR(255),
is_admin BOOLEAN NOT NULL,
+ label VARCHAR(16),
created_at TIMESTAMP NOT NULL DEFAULT NOW()
);
CREATE INDEX idx_users_username ON users(username);