this repo has no description
lewis.moe
1CREATE TABLE record_blobs (
2 id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
3 repo_id UUID NOT NULL REFERENCES users(id) ON DELETE CASCADE,
4 record_uri TEXT NOT NULL,
5 blob_cid TEXT NOT NULL,
6 created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
7 UNIQUE(repo_id, record_uri, blob_cid)
8);
9
10CREATE INDEX idx_record_blobs_repo_id ON record_blobs(repo_id);
11CREATE INDEX idx_record_blobs_blob_cid ON record_blobs(blob_cid);