CREATE TABLE `companyProfileDownloads` (
	`id` int AUTO_INCREMENT NOT NULL,
	`companyProfileId` int NOT NULL,
	`downloadedAt` timestamp NOT NULL DEFAULT (now()),
	CONSTRAINT `companyProfileDownloads_id` PRIMARY KEY(`id`)
);
--> statement-breakpoint
CREATE TABLE `companyProfileMessages` (
	`id` int AUTO_INCREMENT NOT NULL,
	`name` varchar(120) NOT NULL,
	`email` varchar(320) NOT NULL,
	`phone` varchar(40),
	`subject` varchar(160) NOT NULL,
	`message` text NOT NULL,
	`createdAt` timestamp NOT NULL DEFAULT (now()),
	CONSTRAINT `companyProfileMessages_id` PRIMARY KEY(`id`)
);