mirror of
https://tangled.org/tranquil.farm/tranquil-pds
synced 2026-02-08 21:30:08 +00:00
5 lines
295 B
SQL
5 lines
295 B
SQL
ALTER TABLE oauth_device ADD COLUMN trusted_at TIMESTAMPTZ;
|
|
ALTER TABLE oauth_device ADD COLUMN trusted_until TIMESTAMPTZ;
|
|
ALTER TABLE oauth_device ADD COLUMN friendly_name TEXT;
|
|
CREATE INDEX IF NOT EXISTS idx_oauth_device_trusted ON oauth_device(trusted_until) WHERE trusted_until IS NOT NULL;
|