10 lines
320 B
PL/PgSQL
10 lines
320 B
PL/PgSQL
BEGIN;
|
|
CREATE TABLE IF NOT EXISTS auth_login_state (
|
|
id text PRIMARY KEY,
|
|
attempts integer NOT NULL DEFAULT 0,
|
|
window_start timestamptz NOT NULL DEFAULT clock_timestamp(),
|
|
last_step bigint NOT NULL DEFAULT -1
|
|
);
|
|
INSERT INTO schema_migrations(version) VALUES ('007_dynamic_code_auth') ON CONFLICT DO NOTHING;
|
|
COMMIT;
|