migrations/20251226_trusted_devices.sql at 86e7bd3b9ade84077508b20d1b2e35e4599da886 · lewis.moe/bspds-sandbox

lewis.moe / bspds-sandbox

this repo has no description

bspds-sandbox / migrations / 20251226_trusted_devices.sql

at 86e7bd3b9ade84077508b20d1b2e35e4599da886 295 B view raw

1ALTER TABLE oauth_device ADD COLUMN trusted_at TIMESTAMPTZ;
2ALTER TABLE oauth_device ADD COLUMN trusted_until TIMESTAMPTZ;
3ALTER TABLE oauth_device ADD COLUMN friendly_name TEXT;
4CREATE INDEX IF NOT EXISTS idx_oauth_device_trusted ON oauth_device(trusted_until) WHERE trusted_until IS NOT NULL;