ALTER TABLE `task_feedback` ADD COLUMN `task_status` varchar(11) NOT NULL DEFAULT 1 COMMENT '任务状态' AFTER `task_id`, ADD COLUMN `task_start` varchar(20) NOT NULL AFTER `task_date`, ADD COLUMN `task_end` varchar(20) NOT NULL AFTER `task_start`, DROP COLUMN `accept`, DROP COLUMN `reject_reason`; ALTER TABLE `task_person` ADD COLUMN `accept_status` int(11) NOT NULL DEFAULT 0 COMMENT '接受状态 :0-未接受(即新任务)、1-已接受、2-已拒绝' AFTER `create_time`, ADD COLUMN `reject_reason` varchar(500) NULL AFTER `accept_status`, ADD COLUMN `update_time` datetime NULL AFTER `reject_reason`, ADD UNIQUE INDEX `ak_task_task_person` (`task_id`, `person_id`) USING BTREE ;