-- 003_admin_flags.sql (Postgres)
--
-- Admin user-management columns: is_active, last_login_at, disabled_reason.
-- All ADDITIVE — every column ships with a DEFAULT so pre-v3 rows are
-- fully populated without a backfill step.
--
-- Postgres supports IF NOT EXISTS on ADD COLUMN, so the runner does NOT
-- need its sqlite-style per-statement try/catch here.

ALTER TABLE users ADD COLUMN IF NOT EXISTS is_active BOOLEAN NOT NULL DEFAULT TRUE;
ALTER TABLE users ADD COLUMN IF NOT EXISTS last_login_at TEXT;
ALTER TABLE users ADD COLUMN IF NOT EXISTS disabled_reason TEXT;

CREATE INDEX IF NOT EXISTS idx_users_is_active ON users(is_active);