this repo has no description
lewis.moe
1ALTER TABLE users ADD COLUMN two_factor_enabled BOOLEAN NOT NULL DEFAULT FALSE;
2
3ALTER TYPE notification_type ADD VALUE 'two_factor_code';
4
5CREATE TABLE oauth_2fa_challenge (
6 id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
7 did TEXT NOT NULL REFERENCES users(did) ON DELETE CASCADE,
8 request_uri TEXT NOT NULL,
9 code TEXT NOT NULL,
10 attempts INTEGER NOT NULL DEFAULT 0,
11 created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
12 expires_at TIMESTAMPTZ NOT NULL DEFAULT NOW() + INTERVAL '10 minutes'
13);
14
15CREATE INDEX idx_oauth_2fa_challenge_request_uri ON oauth_2fa_challenge(request_uri);
16CREATE INDEX idx_oauth_2fa_challenge_expires ON oauth_2fa_challenge(expires_at);