A chill Bluesky bot, with responses powered by Gemini.
1CREATE TABLE `memory_block_entries` (
2 `id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
3 `block_id` integer NOT NULL,
4 `label` text NOT NULL,
5 `value` text NOT NULL,
6 `added_by` text,
7 `created_at` integer DEFAULT CURRENT_TIMESTAMP,
8 FOREIGN KEY (`block_id`) REFERENCES `memory_blocks`(`id`) ON UPDATE no action ON DELETE no action
9);
10--> statement-breakpoint
11CREATE TABLE `memory_blocks` (
12 `id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
13 `did` text NOT NULL,
14 `name` text DEFAULT 'memory' NOT NULL,
15 `description` text DEFAULT 'User memory' NOT NULL,
16 `mutable` integer DEFAULT false NOT NULL
17);