ALTER TABLE `transtrack`.`vehicle_expenses_entry` CHANGE COLUMN `expense_mode_id` `expense_mode_id` INT(11) NOT NULL  AFTER `expense_name` , CHANGE COLUMN `expense_name` `expense_name` VARCHAR(60) NULL  , ADD COLUMN `expense_scroll_id` INT NOT NULL  AFTER `remarks` 
, ADD UNIQUE INDEX `expense_scroll_id_UNIQUE` (`expense_scroll_id` ASC) ;


ALTER TABLE `transtrack`.`vehicle_expenses_entry` CHANGE COLUMN `vehicle_id` `vehicle_id` INT(11) NOT NULL  AFTER `expense_date` , CHANGE COLUMN `recieve_from` `paid_to` INT NOT NULL  ;

ALTER TABLE `transtrack`.`vehicle_expenses_entry` CHANGE COLUMN `expense_scroll_id` `expense_scroll_id` INT(11) NOT NULL  AFTER `id` , CHANGE COLUMN `expense_date` `expense_date` DATE NULL  , CHANGE COLUMN `expense_name` `expense_name` INT NOT NULL  , CHANGE COLUMN `expense_amount` `expense_amount` DECIMAL(10,2) NULL  , CHANGE COLUMN `remarks` `remarks1` VARCHAR(60) NULL  , ADD COLUMN `cheque_info` VARCHAR(45) NULL  AFTER `expense_mode_id` , ADD COLUMN `remarks2` VARCHAR(45) NULL  AFTER `remarks1` ;

ALTER TABLE `transtrack`.`vehicle_expenses_entry` ADD COLUMN `paid_by` INT NOT NULL  AFTER `paid_to` ;

ALTER TABLE `transtrack`.`vehicle_expenses_entry` 
  ADD CONSTRAINT `fk3_expense_name`
  FOREIGN KEY (`expense_name` )
  REFERENCES `transtrack`.`task_master` (`id` )
  ON DELETE NO ACTION
  ON UPDATE NO ACTION
, ADD INDEX `fk3_expense_name_idx` (`expense_name` ASC) ;


ALTER TABLE `transtrack`.`vehicle_expenses_entry` 
  ADD CONSTRAINT `fk4_paid_to`
  FOREIGN KEY (`paid_to` )
  REFERENCES `transtrack`.`party_master` (`id` )
  ON DELETE NO ACTION
  ON UPDATE NO ACTION, 
  ADD CONSTRAINT `fk5_paid_by`
  FOREIGN KEY (`paid_by` )
  REFERENCES `transtrack`.`employee_master` (`id` )
  ON DELETE NO ACTION
  ON UPDATE NO ACTION
, ADD INDEX `fk4_paid_to_idx` (`paid_to` ASC) 
, ADD INDEX `fk5_paid_by_idx` (`paid_by` ASC) ;


ALTER TABLE `transtrack`.`vehicle_maintenance_to_do` CHANGE COLUMN `remarks` `remarks1` VARCHAR(90) NULL DEFAULT NULL  , ADD COLUMN `remarks2` VARCHAR(90) NULL  AFTER `remarks1` ;

ALTER TABLE `transtrack`.`vehicle_maintenance_to_do` CHANGE COLUMN `remind_me_on` `remind_me_on` DATE NULL DEFAULT NULL  AFTER `next_job_date` , CHANGE COLUMN `remind_me_before` `maintenance_status` VARCHAR(45) NULL DEFAULT NULL  ;