Something went wrong. Try again.
Paper Mario mod hosting site - AT Protocol appview starhaven.dev
appview
Something went wrong. Try again.
687 B · 20 lines
SQL
at main
123456789101112131415161718192021-- dev.starhaven.mod.star: accounts starring mods.CREATE TABLE IF NOT EXISTS mod_star( author_did TEXT NOT NULL, rkey TEXT NOT NULL,
-- The listing starred, as the two halves of its at-uri. mod_did TEXT NOT NULL, mod_rkey TEXT NOT NULL,
-- When this appview first saw the star. The record's own createdAt is -- whatever its author wrote. starred_at TEXT NOT NULL,
PRIMARY KEY (author_did, rkey));
-- One star per account per mod, however many records say so.CREATE UNIQUE INDEX IF NOT EXISTS mod_star_once ON mod_star (author_did, mod_did, mod_rkey);CREATE INDEX IF NOT EXISTS mod_star_mod ON mod_star (mod_did, mod_rkey, starred_at);