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`;
