migrations/20251126000000_gate_codes.sql at main · mackuba.eu/pds-gatekeeper

forked from baileytownsend.dev/pds-gatekeeper

Microservice to bring 2FA to self hosted PDSes

pds-gatekeeper / migrations / 20251126000000_gate_codes.sql

at main 334 B view raw

 1-- Add migration script here
 2CREATE TABLE IF NOT EXISTS gate_codes
 3(
 4    code VARCHAR PRIMARY KEY,
 5    handle VARCHAR NOT NULL,
 6    created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
 7);
 8
 9-- Index on created_at for efficient cleanup of expired codes
10CREATE INDEX IF NOT EXISTS idx_gate_codes_created_at ON gate_codes(created_at);