AgentServer/apps/server/drizzle/0008_team_cases.sql

CREATE TABLE `team_cases` (
	`id` text PRIMARY KEY NOT NULL,
	`name` text NOT NULL,
	`lead_bot_id` text,
	`worker_bot_ids` text DEFAULT '[]' NOT NULL,
	`stub_bot_ids` text DEFAULT '[]' NOT NULL,
	`limits` text,
	`human_name` text NOT NULL,
	`text` text NOT NULL,
	`mentions` text DEFAULT '[]' NOT NULL,
	`files` text DEFAULT '[]' NOT NULL,
	`created_at` text DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')) NOT NULL,
	`updated_at` text DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')) NOT NULL
);
--> statement-breakpoint
ALTER TABLE `teams` ADD `case_id` text;--> statement-breakpoint
CREATE INDEX `teams_case_idx` ON `teams` (`case_id`);