CREATE TABLE `developer_agreements` (
	`id` int AUTO_INCREMENT NOT NULL,
	`developer_name` varchar(255) NOT NULL,
	`agreement_date` varchar(20),
	`file_name` varchar(500),
	`file_url` text,
	`file_key` text,
	`file_size` bigint,
	`mime_type` varchar(100),
	`uploaded_at` timestamp NOT NULL DEFAULT (now()),
	`created_at` timestamp NOT NULL DEFAULT (now()),
	`deleted_at` timestamp,
	CONSTRAINT `developer_agreements_id` PRIMARY KEY(`id`)
);
--> statement-breakpoint
CREATE TABLE `employment_contracts` (
	`id` int AUTO_INCREMENT NOT NULL,
	`employee_name` varchar(255) NOT NULL,
	`contract_date` varchar(20),
	`file_name` varchar(500),
	`file_url` text,
	`file_key` text,
	`file_size` bigint,
	`mime_type` varchar(100),
	`uploaded_at` timestamp NOT NULL DEFAULT (now()),
	`created_at` timestamp NOT NULL DEFAULT (now()),
	`deleted_at` timestamp,
	CONSTRAINT `employment_contracts_id` PRIMARY KEY(`id`)
);
--> statement-breakpoint
ALTER TABLE `documents` MODIFY COLUMN `document_type` enum('eoi','oqood','booking','spa','apartment_details','receipts','passport','other','booking_form','payment_plan','receipt') NOT NULL;