migrations/003_likes.up.sql at main

moth11.net / 88x31

fork atom

tiny 88x31 lexicon for atproto

fork atom

88x31 / migrations / 003_likes.up.sql

at main 9 lines 243 B view raw

wrap content

moth11.net i think it looked better that way lol 3mo ago

78461a69

1CREATE TABLE likes (
2  uri TEXT PRIMARY KEY,
3  subject_uri TEXT NOT NULL,
4  subject_cid TEXT NOT NULL,
5  did TEXT NOT NULL,
6  cid TEXT NOT NULL,
7	created_at TIMESTAMPTZ NOT NULL DEFAULT now(),
8	indexed_at TIMESTAMPTZ NOT NULL DEFAULT now()
9);