shared/migrations/20251015201900_missing_blobs.up.sql at feat/batch-one-qol

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

pds atproto migrations moo cow

fork atom

pds-moover / shared / migrations / 20251015201900_missing_blobs.up.sql

at feat/batch-one-qol 13 lines 538 B view raw

wrap content

baileytownsend.dev PDS MOOver: The Next Generation 4mo ago

1beaee00

 1-- Create missing_blobs table to track blobs that could not be fetched
 2CREATE TABLE IF NOT EXISTS missing_blobs
 3(
 4    id            BIGSERIAL PRIMARY KEY,
 5    did           TEXT        NOT NULL,
 6    cid           TEXT        NOT NULL,
 7    created_date  TIMESTAMPTZ NOT NULL DEFAULT now()
 8);
 9
10-- Ensure we do not insert duplicates for the same DID + CID pair
11CREATE UNIQUE INDEX IF NOT EXISTS uq_missing_blobs_did_cid ON missing_blobs (did, cid);
12
13CREATE INDEX IF NOT EXISTS idx_missing_blobs_created_date ON missing_blobs (created_date);