serendipty01.dev / smokesignal
forked from smokesignal.events/smokesignal
The smokesignal.events web application
fork atom
smokesignal / migrations / 20250709190627_oauth_requests_authorization_server.sql
at main 15 lines 536 B view raw
Nick Gerakines refactor: updated to atproto-* 0.9.5 and updated traits and function calls to better support blind oauth
f8939305
1-- Add authorization_server column and remove did column from atproto_oauth_requests table 2 3-- Add authorization_server column 4ALTER TABLE atproto_oauth_requests 5ADD COLUMN authorization_server VARCHAR(512) NOT NULL DEFAULT ''; 6 7-- Drop the DID index first 8DROP INDEX idx_atproto_oauth_requests_did; 9 10-- Remove the did column 11ALTER TABLE atproto_oauth_requests 12DROP COLUMN did; 13 14-- Add index for authorization_server lookups 15CREATE INDEX idx_atproto_oauth_requests_authorization_server ON atproto_oauth_requests(authorization_server);