alter table file rename to file_20171124;

insert into file ( id, name, content, data, size, version, type, 
parent_id, related, ctime, mtime, atime, visited_cnt, is_deleted, is_public, is_marked,
creator, modifier, groups, priority) 

select id, name, content, data, size, version, type, 
parent_id, related, sctime, smtime, satime, visited_cnt, is_deleted, is_public, is_marked,
creator, modifier, groups, priority from file_20171124;

-- 重命名表名
ALTER TABLE message rename TO message_old;

-- 移动部分字段到新表
INSERT INTO message (id, ctime, mtime, user, status, content)
SELECT id, ctime, mtime, user, status, content FROM message_old;

-- 如果OK，删除旧表