CREATE TABLE `contact_messages` (
	`id` int AUTO_INCREMENT NOT NULL,
	`type` varchar(50) NOT NULL,
	`name` varchar(255) NOT NULL,
	`email` varchar(255) NOT NULL,
	`subject` varchar(255),
	`message` text NOT NULL,
	`status` varchar(50) NOT NULL DEFAULT 'PENDING',
	`priority` varchar(20) DEFAULT 'MEDIUM',
	`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
	`updated_at` timestamp ON UPDATE CURRENT_TIMESTAMP,
	CONSTRAINT `contact_messages_id` PRIMARY KEY(`id`)
);
--> statement-breakpoint
DROP TABLE `settings`;--> statement-breakpoint
ALTER TABLE `payments` ADD `metadata` text;--> statement-breakpoint
ALTER TABLE `softwares` ADD `download_count` int DEFAULT 0 NOT NULL;