shared/migrations/20251012210012_blobs.up.sql at main

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 / 20251012210012_blobs.up.sql

at main 16 lines 573 B view raw

wrap content

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

1beaee00

 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);