VNOX-Server/hub/migrations/0006_account_profile.sql
loki5512344 c18ccadf99
chore(server): checkpoint deployed services and unfinished forums
User requested a checkpoint and stopped all agents. Deployed artifacts remain the last verified releases; unfinished settings/categories/forums are preserved as WIP. See TODO/roadmap for verification and remaining release/updater work.
2026-11-01 15:31:20 +01:00

4 lines
279 B
SQL

-- Generated accounts remain incomplete until the owner selects a handle.
ALTER TABLE accounts ADD COLUMN profile_complete INTEGER NOT NULL DEFAULT 0
CHECK (profile_complete IN (0, 1));
CREATE UNIQUE INDEX accounts_handle_case_insensitive ON accounts(handle COLLATE NOCASE);