shomei-migrations-0.2.0.0: migrations/shomei/0033-login-attempts-factor.sql

SET LOCAL search_path = pg_catalog, pg_temp;

-- Which credential the attempt proved or failed to prove; every pre-existing row was a password
-- attempt. Counting stays by outcome (all factors share one lockout), so 0011's indexes stay right.
ALTER TABLE shomei.shomei_login_attempts
  ADD COLUMN IF NOT EXISTS factor text NOT NULL DEFAULT 'password';