migrations/1765097328_likes_by_subject.up.cql at main · hailey.at/vylet-go

hailey.at / vylet-go

this repo has no description

vylet-go / migrations / 1765097328_likes_by_subject.up.cql

at main 269 B view raw

 1CREATE TABLE IF NOT EXISTS likes_by_subject (
 2	uri TEXT,
 3	cid TEXT,
 4	subject_uri TEXT,
 5	subject_cid TEXT,
 6	author_did TEXT,
 7	created_at TIMESTAMP,
 8	indexed_at TIMESTAMP,
 9	PRIMARY KEY (subject_uri, created_at, uri)
10) WITH CLUSTERING ORDER BY (created_at DESC, uri ASC);