gcx/backend/migrations/041_add_user_lockout_fields...

5 lines
187 B
SQL

-- 041: Add login lockout fields to users table
ALTER TABLE users
ADD COLUMN IF NOT EXISTS login_fail_count INT NOT NULL DEFAULT 0,
ADD COLUMN IF NOT EXISTS locked_until TIMESTAMPTZ;