ALTER TABLE `task_feedback` ADD COLUMN `create_time` datetime NULL AFTER `taskpersonid`, ADD COLUMN `update_time` datetime NULL AFTER `create_time`; update task_feedback tf,task t set tf.create_time=t.create_time,tf.update_time=t.update_time where tf.task_id = t.id; ALTER TABLE `task` ADD COLUMN `rawid` int(11) NULL AFTER `areaCode`; ALTER TABLE `task_feedback` ADD COLUMN `rawid` int(11) NULL AFTER `update_time`; ALTER TABLE `user` ADD COLUMN `rawid` int(11) NULL AFTER `logindate`; ALTER TABLE `task` ADD COLUMN `inrawid` int(11) NULL AFTER `rawid`; ALTER TABLE `task_feedback` ADD COLUMN `inrawid` int(11) NULL AFTER `rawid`; ALTER TABLE `user` ADD COLUMN `inrawid` int(11) NULL AFTER `rawid`;