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.
4 lines
279 B
SQL
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);
|