AgentServer/apps/server/drizzle/0012_background_calls.sql

CREATE TABLE `background_calls` (
	`id` text PRIMARY KEY NOT NULL,
	`session_id` text NOT NULL,
	`team_id` text,
	`bot_id` text,
	`task_id` text,
	`server_id` text NOT NULL,
	`server_name` text NOT NULL,
	`server_title` text NOT NULL,
	`tool` text NOT NULL,
	`args` text NOT NULL,
	`status` text DEFAULT 'running' NOT NULL,
	`started_at` text DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')) NOT NULL,
	`ended_at` text,
	`result` text,
	`error` text,
	`delivered` integer DEFAULT false NOT NULL
);
--> statement-breakpoint
CREATE INDEX `background_calls_session_idx` ON `background_calls` (`session_id`);--> statement-breakpoint
CREATE INDEX `background_calls_team_idx` ON `background_calls` (`team_id`);--> statement-breakpoint
CREATE INDEX `background_calls_status_idx` ON `background_calls` (`status`,`delivered`);--> statement-breakpoint
ALTER TABLE `mcp_servers` ADD `background_tools` text DEFAULT '[]' NOT NULL;--> statement-breakpoint
ALTER TABLE `tasks` ADD `follow_up` text;