baileytownsend.dev
forked from
baileytownsend.dev/atproto-sveltekit-template
WIP: Another at:// production from me
1CREATE TABLE "record_pokes" (
2 "id" serial PRIMARY KEY NOT NULL,
3 "recordId" integer,
4 "pokersRepo" text NOT NULL,
5 "atUri" text NOT NULL,
6 "indexedAt" time DEFAULT now() NOT NULL
7);
8--> statement-breakpoint
9CREATE TABLE "records" (
10 "id" serial PRIMARY KEY NOT NULL,
11 "rkey" varchar NOT NULL,
12 "collection" varchar NOT NULL,
13 "repo" varchar NOT NULL,
14 "atUri" text NOT NULL,
15 "data" jsonb NOT NULL,
16 "indexedAt" timestamp DEFAULT now() NOT NULL
17);
18--> statement-breakpoint
19CREATE TABLE "user_pokes" (
20 "id" serial PRIMARY KEY NOT NULL,
21 "subject" text NOT NULL,
22 "poker" text NOT NULL,
23 "at_uri" text NOT NULL,
24 "indexedAt" time DEFAULT now() NOT NULL
25);
26--> statement-breakpoint
27ALTER TABLE "record_pokes" ADD CONSTRAINT "record_pokes_recordId_records_id_fk" FOREIGN KEY ("recordId") REFERENCES "public"."records"("id") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
28CREATE INDEX "record_pokes_pokersRepo_index" ON "record_pokes" USING btree ("pokersRepo");--> statement-breakpoint
29CREATE INDEX "record_pokes_atUri_index" ON "record_pokes" USING btree ("atUri");--> statement-breakpoint
30CREATE INDEX "records_rkey_index" ON "records" USING btree ("rkey");--> statement-breakpoint
31CREATE INDEX "records_collection_index" ON "records" USING btree ("collection");--> statement-breakpoint
32CREATE INDEX "records_repo_index" ON "records" USING btree ("repo");--> statement-breakpoint
33CREATE UNIQUE INDEX "records_atUri_index" ON "records" USING btree ("atUri");--> statement-breakpoint
34CREATE INDEX "user_pokes_subject_index" ON "user_pokes" USING btree ("subject");--> statement-breakpoint
35CREATE INDEX "user_pokes_poker_index" ON "user_pokes" USING btree ("poker");