22/10/2018 updates ALTER TABLE `service` ADD `send_to_sc_status` VARCHAR(40) NOT NULL AFTER `hand_over_user`, ADD `send_to_sc_date_time` DATETIME NOT NULL AFTER `send_to_sc_status`, ADD `send_to_sc_user` INT NOT NULL AFTER `send_to_sc_date_time`, ADD `reserved_to_sc_status` VARCHAR(40) NOT NULL AFTER `send_to_sc_user`, ADD `reserved_to_sc_date_time` DATETIME NOT NULL AFTER `reserved_to_sc_status`, ADD `reserved_to_sc_user` INT NOT NULL AFTER `reserved_to_sc_date_time`, ADD `hand_over_to_tech_status` VARCHAR(40) NOT NULL AFTER `reserved_to_sc_user`, ADD `hand_over_to_tech_date_time` DATETIME NOT NULL AFTER `hand_over_to_tech_status`, ADD `hand_over_to_tech_user` INT NOT NULL AFTER `hand_over_to_tech_date_time`, ADD `return_from_tech_status` VARCHAR(40) NOT NULL AFTER `hand_over_to_tech_user`, ADD `return_from_tech_date_time` DATETIME NOT NULL AFTER `return_from_tech_status`, ADD `return_from_tech_user` INT NOT NULL AFTER `return_from_tech_date_time`, ADD `return_to_branch_status` VARCHAR(40) NOT NULL AFTER `return_from_tech_user`, ADD `return_to_branch_date_time` DATETIME NOT NULL AFTER `return_to_branch_status`, ADD `return_to_branch_user` INT NOT NULL AFTER `return_to_branch_date_time`, ADD `reserved_to_branch_status` VARCHAR(40) NOT NULL AFTER `return_to_branch_user`, ADD `reserved_to_branch_date_time` DATETIME NOT NULL AFTER `reserved_to_branch_status`, ADD `reserved_to_branch_user` INT NOT NULL AFTER `reserved_to_branch_date_time`; //Done