apps/api/drizzle/0002_robust_wong.sql at main

rocksky.app / rocksky

fork atom

A decentralized music tracking and discovery platform built on AT Protocol 🎵 rocksky.app

spotify atproto lastfm musicbrainz scrobbling listenbrainz

fork atom

rocksky / apps / api / drizzle / 0002_robust_wong.sql

at main 12 lines 478 B view raw

wrap content

tsiry-sandratraina.com Add follows graph, DB table and endpoints 2mo ago

bc3c2d45

 1CREATE TABLE "follows" (
 2	"xata_id" text PRIMARY KEY DEFAULT xata_id() NOT NULL,
 3	"uri" text NOT NULL,
 4	"follower_did" text NOT NULL,
 5	"subject_did" text NOT NULL,
 6	"xata_version" integer,
 7	"xata_createdat" timestamp DEFAULT now() NOT NULL,
 8	"xata_updatedat" timestamp DEFAULT now() NOT NULL,
 9	CONSTRAINT "follows_uri_unique" UNIQUE("uri")
10);
11--> statement-breakpoint
12CREATE UNIQUE INDEX "follows_follower_subject_unique" ON "follows" USING btree ("follower_did","subject_did");