AgentServer/apps/server/drizzle/0016_interactions_form.sql

PRAGMA foreign_keys=OFF;--> statement-breakpoint
CREATE TABLE `__new_interactions` (
	`id` text PRIMARY KEY NOT NULL,
	`session_id` text NOT NULL,
	`run_id` text,
	`kind` text NOT NULL,
	`request` text NOT NULL,
	`response` text,
	`status` text NOT NULL,
	`created_at` text DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')) NOT NULL,
	`resolved_at` text,
	`expires_at` text NOT NULL
);
--> statement-breakpoint
INSERT INTO `__new_interactions`("id", "session_id", "run_id", "kind", "request", "response", "status", "created_at", "resolved_at", "expires_at") SELECT "id", "session_id", "run_id", "kind", "request", "response", "status", "created_at", "resolved_at", "expires_at" FROM `interactions`;--> statement-breakpoint
DROP TABLE `interactions`;--> statement-breakpoint
ALTER TABLE `__new_interactions` RENAME TO `interactions`;--> statement-breakpoint
PRAGMA foreign_keys=ON;--> statement-breakpoint
CREATE INDEX `interactions_session_idx` ON `interactions` (`session_id`,`status`);