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 `theme_policies` (
2 `id` integer PRIMARY KEY AUTOINCREMENT 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` integer NOT NULL,
9 `indexed_at` integer NOT NULL
10);
11--> statement-breakpoint
12CREATE UNIQUE INDEX `theme_policies_did_rkey_idx` ON `theme_policies` (`did`,`rkey`);--> statement-breakpoint
13CREATE TABLE `theme_policy_available_themes` (
14 `policy_id` integer NOT NULL,
15 `theme_uri` text NOT NULL,
16 `theme_cid` text NOT NULL,
17 PRIMARY KEY(`policy_id`, `theme_uri`),
18 FOREIGN KEY (`policy_id`) REFERENCES `theme_policies`(`id`) ON UPDATE no action ON DELETE cascade
19);
20--> statement-breakpoint
21CREATE TABLE `themes` (
22 `id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
23 `did` text NOT NULL,
24 `rkey` text NOT NULL,
25 `cid` text NOT NULL,
26 `name` text NOT NULL,
27 `color_scheme` text NOT NULL,
28 `tokens` text NOT NULL,
29 `css_overrides` text,
30 `font_urls` text,
31 `created_at` integer NOT NULL,
32 `indexed_at` integer NOT NULL
33);
34--> statement-breakpoint
35CREATE UNIQUE INDEX `themes_did_rkey_idx` ON `themes` (`did`,`rkey`);