malpercio.dev
WIP! A BB-style forum, on the ATmosphere!
We're still working... we'll be back soon when we have something to show off!
node
typescript
hono
htmx
atproto
1CREATE TABLE "boards" (
2 "id" bigserial PRIMARY KEY NOT NULL,
3 "did" text NOT NULL,
4 "rkey" text NOT NULL,
5 "cid" text NOT NULL,
6 "name" text NOT NULL,
7 "description" text,
8 "slug" text,
9 "sort_order" integer,
10 "category_id" bigint,
11 "category_uri" text NOT NULL,
12 "created_at" timestamp with time zone NOT NULL,
13 "indexed_at" timestamp with time zone NOT NULL
14);
15--> statement-breakpoint
16ALTER TABLE "boards" ADD CONSTRAINT "boards_category_id_categories_id_fk" FOREIGN KEY ("category_id") REFERENCES "public"."categories"("id") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
17CREATE UNIQUE INDEX "boards_did_rkey_idx" ON "boards" USING btree ("did","rkey");--> statement-breakpoint
18CREATE INDEX "boards_category_id_idx" ON "boards" USING btree ("category_id");