chatbot/drizzle/0006_lowly_sinister_six.sql

CREATE TABLE `workflow_suggestions` (
	`id` int AUTO_INCREMENT NOT NULL,
	`workflowId` varchar(64) NOT NULL,
	`suggestedNodeType` varchar(64) NOT NULL,
	`label` varchar(255) NOT NULL,
	`description` text,
	`config` json,
	`faqQuestion` text,
	`frequency` int NOT NULL DEFAULT 0,
	`suggestionStatus` enum('pending','approved','declined','waiting') NOT NULL DEFAULT 'pending',
	`reviewedById` int,
	`reviewedAt` timestamp,
	`createdAt` timestamp NOT NULL DEFAULT (now()),
	`updatedAt` timestamp NOT NULL DEFAULT (now()) ON UPDATE CURRENT_TIMESTAMP,
	CONSTRAINT `workflow_suggestions_id` PRIMARY KEY(`id`)
);
--> statement-breakpoint
ALTER TABLE `workflow_nodes` MODIFY COLUMN `type` enum('greeting','intent','response','condition','escalation','action','end','customer_data','sales_order','guardrail') NOT NULL;