A chill Bluesky bot, with responses powered by Gemini.
1CREATE TABLE `interactions` (
2 `id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
3 `uri` text,
4 `did` text,
5 `created_at` integer DEFAULT CURRENT_TIMESTAMP
6);
7--> statement-breakpoint
8CREATE UNIQUE INDEX `interactions_uri_unique` ON `interactions` (`uri`);--> statement-breakpoint
9CREATE TABLE `muted_threads` (
10 `id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
11 `uri` text,
12 `muted_at` integer DEFAULT CURRENT_TIMESTAMP
13);
14--> statement-breakpoint
15CREATE UNIQUE INDEX `muted_threads_uri_unique` ON `muted_threads` (`uri`);