OXYGENHUB
# fbd7c8551932 oxygenhub / crates / hub / migrations / 0030_device_token_life.sql
334 B · SQL · last changed Device tokens expire and renew on use; the approval page shows the requester (closes #70) 1 month ago source blame history raw
1 
-- oxygenhub#70: tokens from device sign-in expire, and each use renews
2 
-- them (renew_ms: the lifetime a use extends the token to); a device code
3 
-- keeps the address that asked for it, shown when it is approved.
4 
ALTER TABLE tokens ADD COLUMN renew_ms INTEGER;
5 
ALTER TABLE device_codes ADD COLUMN requester TEXT NOT NULL DEFAULT '';