vicwalker.dev.br / tranquil-pds
forked from tranquil.farm/tranquil-pds
Our Personal Data Server from scratch!
fork atom
tranquil-pds / migrations / 20251226_trusted_devices.sql
at fix/code-quality-in-general 4 lines 295 B view raw
oyster.cafe Passkey-only accounts
fa6c4cc1
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;