由于X2.0使用的附件分表，所以1.5的语句失效，应分别设置

本地附件转为远程附件：（注意相关的附件上传设置）
update pre_forum_attachment_0 set remote = ’1′;
update pre_forum_attachment_1 set remote = ’1′;
update pre_forum_attachment_2 set remote = ’1′;
update pre_forum_attachment_3 set remote = ’1′;
update pre_forum_attachment_4 set remote = ’1′;
update pre_forum_attachment_5 set remote = ’1′;
update pre_forum_attachment_6 set remote = ’1′;
update pre_forum_attachment_7 set remote = ’1′;
update pre_forum_attachment_8 set remote = ’1′;
update pre_forum_attachment_9 set remote = ’1′;
复制代码
远程附件转为本地附件：
update pre_forum_attachment_0 set remote = ’0′;
update pre_forum_attachment_1 set remote = ’0′;
update pre_forum_attachment_2 set remote = ’0′;
update pre_forum_attachment_3 set remote = ’0′;
update pre_forum_attachment_4 set remote = ’0′;
update pre_forum_attachment_5 set remote = ’0′;
update pre_forum_attachment_6 set remote = ’0′;
update pre_forum_attachment_7 set remote = ’0′;
update pre_forum_attachment_8 set remote = ’0′;
update pre_forum_attachment_9 set remote = ’0′;

相册

UPDATE `pre_home_pic` SET `remote` =1