Something went wrong. Try again.
Microservice to bring 2FA to self hosted PDSes
Something went wrong. Try again.
334 B · 10 lines
SQL
at main
1234567891011-- Add migration script hereCREATE TABLE IF NOT EXISTS gate_codes( code VARCHAR PRIMARY KEY, handle VARCHAR NOT NULL, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP);
-- Index on created_at for efficient cleanup of expired codesCREATE INDEX IF NOT EXISTS idx_gate_codes_created_at ON gate_codes(created_at);