ALTER TABLE `tblwork_orders` 
ADD `start_time` TIME NULL AFTER `schedule_date`, 
ADD `end_time` TIME NULL AFTER `start_time`, 
ADD `is_any_time` TINYINT(1) NOT NULL DEFAULT '0' AFTER `end_time`;
ALTER TABLE `tblwork_orders` ADD `schedule_end_date` DATE NULL AFTER `schedule_date`;

ALTER TABLE `tblwork_orders` CHANGE `property_street` `property_street` VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `property_city` `property_city` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `property_state` `property_state` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `property_zip` `property_zip` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;

ALTER TABLE `tblwork_orders` CHANGE `status` `status` ENUM('pending','inprogress','completed','cancelled','sent','delegated') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'pending';