CREATE TABLE `proll_travel_expense_detail` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`employee_id` INT(11) NOT NULL,
	`client_id` INT(11) NOT NULL,
	`travel_id` INT(11) NOT NULL,
	`daily_expense_type_id` INT(11) NULL DEFAULT NULL,
	`daily_expense_currency_id` INT(11) NULL DEFAULT NULL,
	`daily_expense_amount` INT(11) NULL DEFAULT NULL,
	`daily_expense_percentage` INT(11) NULL DEFAULT NULL,
	`daily_expense_receipt` VARCHAR(255) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
	`transportation_expense_type_id` INT(11) NULL DEFAULT NULL,
	`transportation_expense_currency_id` INT(11) NULL DEFAULT NULL,
	`transportation_expense_amount` INT(11) NULL DEFAULT NULL,
	`transportation_expense_percentage` INT(11) NULL DEFAULT NULL,
	`transportation_expense_receipt` VARCHAR(255) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
	`accommodation_expense_type_id` INT(11) NULL DEFAULT NULL,
	`accommodation_expense_currency_id` INT(11) NULL DEFAULT NULL,
	`accommodation_expense_amount` INT(11) NULL DEFAULT NULL,
	`accommodation_expense_percentage` INT(11) NULL DEFAULT NULL,
	`accommodation_expense_receipt` VARCHAR(255) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
	`transfer_fee_type_id` INT(11) NULL DEFAULT NULL,
	`transfer_fee_currency_id` INT(11) NULL DEFAULT NULL,
	`transfer_fee_amount` INT(11) NULL DEFAULT NULL,
	`transfer_fee_percentage` INT(11) NULL DEFAULT NULL,
	`transfer_fee_receipt` VARCHAR(255) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
	`created_at` TIMESTAMP NULL DEFAULT NULL,
	`updated_at` TIMESTAMP NULL DEFAULT NULL,
	PRIMARY KEY (`id`) USING BTREE
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB
AUTO_INCREMENT=2
;


ALTER TABLE `proll_travel`
	ADD COLUMN `comments` LONGTEXT NULL AFTER `is_draft`;