Exosphere is a set of small, modular, self-hostable community tools built on the AT Protocol.
app.exosphere.site
1CREATE TABLE `entity_labels` (
2 `label_id` text NOT NULL,
3 `entity_id` text NOT NULL,
4 `entity_type` text NOT NULL,
5 PRIMARY KEY(`label_id`, `entity_id`),
6 FOREIGN KEY (`label_id`) REFERENCES `sphere_labels`(`id`) ON UPDATE no action ON DELETE cascade
7);
8--> statement-breakpoint
9CREATE INDEX `idx_entity_labels_entity` ON `entity_labels` (`entity_id`,`entity_type`);--> statement-breakpoint
10CREATE TABLE `sphere_labels` (
11 `id` text PRIMARY KEY NOT NULL,
12 `sphere_id` text NOT NULL,
13 `name` text NOT NULL,
14 `description` text,
15 `color` text NOT NULL,
16 `position` integer DEFAULT 0 NOT NULL,
17 `created_at` text DEFAULT (datetime('now')) NOT NULL,
18 FOREIGN KEY (`sphere_id`) REFERENCES `spheres`(`id`) ON UPDATE no action ON DELETE no action
19);
20--> statement-breakpoint
21CREATE UNIQUE INDEX `idx_sphere_labels_sphere_name` ON `sphere_labels` (`sphere_id`,`name`);--> statement-breakpoint
22CREATE INDEX `idx_sphere_labels_sphere_position` ON `sphere_labels` (`sphere_id`,`position`);