quilling.dev
Alternative ATProto PDS implementation
1 CREATE TABLE IF NOT EXISTS blocks (
2 cid TEXT PRIMARY KEY NOT NULL,
3 data BLOB NOT NULL,
4 multicodec INTEGER NOT NULL,
5 multihash INTEGER NOT NULL
6 );
7 CREATE TABLE IF NOT EXISTS tree_nodes (
8 repo_did TEXT NOT NULL,
9 key TEXT NOT NULL,
10 value_cid TEXT NOT NULL,
11 PRIMARY KEY (repo_did, key),
12 FOREIGN KEY (value_cid) REFERENCES blocks(cid)
13 );
14 CREATE INDEX IF NOT EXISTS idx_blocks_cid ON blocks(cid);
15 CREATE INDEX IF NOT EXISTS idx_tree_nodes_repo ON tree_nodes(repo_did);