Exosphere is a set of small, modular, self-hostable community tools built on the AT Protocol.
app.exosphere.site
1CREATE TABLE `kanban_columns` (
2 `id` text PRIMARY KEY NOT NULL,
3 `sphere_id` text NOT NULL,
4 `slug` text NOT NULL,
5 `label` text NOT NULL,
6 `position` integer NOT NULL,
7 `created_at` text DEFAULT (datetime('now')) NOT NULL,
8 FOREIGN KEY (`sphere_id`) REFERENCES `spheres`(`id`) ON UPDATE no action ON DELETE no action
9);
10--> statement-breakpoint
11CREATE UNIQUE INDEX `idx_kanban_columns_sphere_slug` ON `kanban_columns` (`sphere_id`,`slug`);--> statement-breakpoint
12CREATE INDEX `idx_kanban_columns_sphere_position` ON `kanban_columns` (`sphere_id`,`position`);