Client side atproto account migrator in your web browser, along with services for backups and adversarial migrations. pdsmoover.com
pds atproto migrations moo cow
128
fork

Configure Feed

Select the types of activity you want to include in your feed.

at main 16 lines 573 B view raw
1-- Add up migration script here 2 3CREATE TYPE blob_type AS ENUM ('repo', 'blob', 'prefs'); 4 5CREATE TABLE blobs 6( 7 id SERIAL PRIMARY KEY, 8 created_at TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP, 9 account_did TEXT NOT NULL REFERENCES accounts (did), 10 size BIGINT NOT NULL, 11 type blob_type NOT NULL, 12 cid_or_rev TEXT NOT NULL UNIQUE 13); 14 15CREATE INDEX idx_blobs_account_did ON blobs (account_did); 16create index idx_blobs_cid on blobs (cid_or_rev);