CREATE TABLE `chatbotSessions` (
	`id` int AUTO_INCREMENT NOT NULL,
	`sessionKey` varchar(120) NOT NULL,
	`userType` varchar(64),
	`recommendedRoute` varchar(80) NOT NULL,
	`summary` text,
	`createdAt` timestamp NOT NULL DEFAULT (now()),
	CONSTRAINT `chatbotSessions_id` PRIMARY KEY(`id`),
	CONSTRAINT `chatbotSessions_sessionKey_unique` UNIQUE(`sessionKey`)
);
--> statement-breakpoint
CREATE TABLE `serviceRequests` (
	`id` int AUTO_INCREMENT NOT NULL,
	`requestType` enum('member_support','corporate_inquiry','provider_network','home_care','ground_ambulance','air_ambulance','investor_relations') NOT NULL,
	`fullName` varchar(120) NOT NULL,
	`phone` varchar(40) NOT NULL,
	`email` varchar(320),
	`companyName` varchar(180),
	`city` varchar(120),
	`preferredLanguage` varchar(16) NOT NULL DEFAULT 'ar',
	`urgency` enum('low','medium','high','critical') NOT NULL DEFAULT 'medium',
	`details` text,
	`leadStatus` enum('new','reviewing','contacted','closed') NOT NULL DEFAULT 'new',
	`createdAt` timestamp NOT NULL DEFAULT (now()),
	`updatedAt` timestamp NOT NULL DEFAULT (now()) ON UPDATE CURRENT_TIMESTAMP,
	CONSTRAINT `serviceRequests_id` PRIMARY KEY(`id`)
);
