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 "theme_policies" (
2 "id" bigserial PRIMARY KEY NOT NULL,
3 "did" text NOT NULL,
4 "rkey" text NOT NULL,
5 "cid" text NOT NULL,
6 "default_light_theme_uri" text NOT NULL,
7 "default_dark_theme_uri" text NOT NULL,
8 "allow_user_choice" boolean NOT NULL,
9 "indexed_at" timestamp with time zone NOT NULL
10);
11--> statement-breakpoint
12CREATE TABLE "theme_policy_available_themes" (
13 "policy_id" bigint NOT NULL,
14 "theme_uri" text NOT NULL,
15 "theme_cid" text NOT NULL,
16 CONSTRAINT "theme_policy_available_themes_policy_id_theme_uri_pk" PRIMARY KEY("policy_id","theme_uri")
17);
18--> statement-breakpoint
19CREATE TABLE "themes" (
20 "id" bigserial PRIMARY KEY NOT NULL,
21 "did" text NOT NULL,
22 "rkey" text NOT NULL,
23 "cid" text NOT NULL,
24 "name" text NOT NULL,
25 "color_scheme" text NOT NULL,
26 "tokens" jsonb NOT NULL,
27 "css_overrides" text,
28 "font_urls" text[],
29 "created_at" timestamp with time zone NOT NULL,
30 "indexed_at" timestamp with time zone NOT NULL
31);
32--> statement-breakpoint
33ALTER TABLE "theme_policy_available_themes" ADD CONSTRAINT "theme_policy_available_themes_policy_id_theme_policies_id_fk" FOREIGN KEY ("policy_id") REFERENCES "public"."theme_policies"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
34CREATE UNIQUE INDEX "theme_policies_did_rkey_idx" ON "theme_policies" USING btree ("did","rkey");--> statement-breakpoint
35CREATE UNIQUE INDEX "themes_did_rkey_idx" ON "themes" USING btree ("did","rkey");