CREATE TABLE `receipts` (
	`id` int AUTO_INCREMENT NOT NULL,
	`deal_id` int NOT NULL,
	`client_id` int NOT NULL,
	`amount` decimal(15,2) NOT NULL,
	`receipt_date` varchar(20) NOT NULL,
	`notes` text,
	`file_name` varchar(500),
	`file_key` text,
	`file_url` text,
	`file_size` bigint,
	`mime_type` varchar(100),
	`document_id` int,
	`uploaded_at` timestamp NOT NULL DEFAULT (now()),
	`created_at` timestamp NOT NULL DEFAULT (now()),
	`deleted_at` timestamp,
	CONSTRAINT `receipts_id` PRIMARY KEY(`id`)
);
--> statement-breakpoint
CREATE TABLE `trs_receipts` (
	`id` int AUTO_INCREMENT NOT NULL,
	`receipt_number` int NOT NULL,
	`receipt_date` varchar(20) NOT NULL,
	`receipt_year` int NOT NULL,
	`vendor` varchar(500) NOT NULL,
	`amount` decimal(15,2) NOT NULL,
	`has_vat` boolean NOT NULL DEFAULT false,
	`vat_amount` decimal(15,2),
	`file_name` varchar(500),
	`file_key` text,
	`file_url` text,
	`file_size` bigint,
	`mime_type` varchar(100),
	`created_at` timestamp NOT NULL DEFAULT (now()),
	`deleted_at` timestamp,
	CONSTRAINT `trs_receipts_id` PRIMARY KEY(`id`)
);
--> statement-breakpoint
ALTER TABLE `activity_logs` MODIFY COLUMN `event_type` enum('client_created','client_updated','deal_added','deal_updated','deal_status_changed','document_uploaded','document_deleted','note_updated','receipt_added','receipt_deleted') NOT NULL;--> statement-breakpoint
ALTER TABLE `documents` MODIFY COLUMN `document_type` enum('eoi','oqood','booking','spa','kyc','name_screening','emirates_id','apartment_details','receipts','passport','other','booking_form','payment_plan','receipt') NOT NULL;--> statement-breakpoint
ALTER TABLE `deals` ADD `dld_fee` decimal(15,2) DEFAULT '0';--> statement-breakpoint
ALTER TABLE `deals` ADD `admin_fee` decimal(15,2) DEFAULT '0';