A community based topic aggregation platform built on atproto
bretton.dev
1-- +goose Up
2-- +goose StatementBegin
3-- Drop our block_refs table since Indigo's carstore will create its own
4DROP TABLE IF EXISTS block_refs;
5-- +goose StatementEnd
6
7-- +goose Down
8-- +goose StatementBegin
9-- Recreate block_refs table
10CREATE TABLE block_refs (
11 cid VARCHAR(256) NOT NULL,
12 did VARCHAR(256) NOT NULL,
13 created_at TIMESTAMP NOT NULL DEFAULT NOW(),
14 PRIMARY KEY (cid, did),
15 FOREIGN KEY (did) REFERENCES repositories(did) ON DELETE CASCADE
16);
17
18CREATE INDEX idx_block_refs_did ON block_refs(did);
19CREATE INDEX idx_block_refs_created_at ON block_refs(created_at);
20-- +goose StatementEnd