clickclack/infra/migrations/sqlite/0003_user_profiles.sql
2026-05-08 12:05:22 +01:00

4 lines
151 B
SQL

ALTER TABLE users ADD COLUMN handle TEXT NOT NULL DEFAULT '';
CREATE UNIQUE INDEX IF NOT EXISTS idx_users_handle ON users(handle) WHERE handle <> '';