CREATE TABLE desktop_authorizations ( device_hash TEXT PRIMARY KEY, code_hash TEXT NOT NULL UNIQUE, public_key TEXT NOT NULL, user_id TEXT REFERENCES accounts(user_id) ON DELETE CASCADE, expires_at INTEGER NOT NULL ); CREATE INDEX desktop_authorization_expiry ON desktop_authorizations(expires_at); CREATE TABLE desktop_devices ( refresh_hash TEXT PRIMARY KEY, device_hash TEXT NOT NULL UNIQUE, public_key TEXT NOT NULL, user_id TEXT NOT NULL REFERENCES accounts(user_id) ON DELETE CASCADE, created_at INTEGER NOT NULL, expires_at INTEGER NOT NULL ); CREATE INDEX desktop_device_expiry ON desktop_devices(expires_at);