# Will Run as a SQL Upgrade from newbb to xforum TRUNCATE prefix_xf_attachments; TRUNCATE prefix_xf_categories; TRUNCATE prefix_xf_digest; TRUNCATE prefix_xf_forums; TRUNCATE prefix_xf_moderates; TRUNCATE prefix_xf_online; TRUNCATE prefix_xf_posts; TRUNCATE prefix_xf_posts_text; TRUNCATE prefix_xf_reads_forum; TRUNCATE prefix_xf_reads_topic; TRUNCATE prefix_xf_report; TRUNCATE prefix_xf_topics; TRUNCATE prefix_xf_votedata; INSERT INTO prefix_xf_votedata SELECT * FROM prefix_bb_votedata; INSERT INTO prefix_xf_topics SELECT * FROM prefix_bb_topics; INSERT INTO prefix_xf_report SELECT * FROM prefix_bb_report; INSERT INTO prefix_xf_reads_topic SELECT * FROM prefix_bb_reads_topic; INSERT INTO prefix_xf_reads_forum SELECT * FROM prefix_bb_reads_forum; INSERT INTO prefix_xf_posts_text SELECT * FROM prefix_bb_posts_text; INSERT INTO prefix_xf_posts (post_id,pid,topic_id,forum_id,post_time,uid,poster_name,poster_ip,`subject`,dohtml,dosmiley,doxcode,dobr,doimage,icon,attachsig,approved,post_karma,attachment,require_reply,`subject`) SELECT (post_id,pid,topic_id,forum_id,post_time,uid,poster_name,poster_ip,`subject`,dohtml,dosmiley,doxcode,dobr,doimage,icon,attachsig,approved,post_karma,attachment,require_reply,`tags`) FROM prefix_bb_posts; INSERT INTO prefix_xf_online SELECT * FROM prefix_bb_online; INSERT INTO prefix_xf_moderates SELECT * FROM prefix_bb_moderates; INSERT INTO prefix_xf_forums SELECT * FROM prefix_bb_forums; INSERT INTO prefix_xf_digest SELECT * FROM prefix_bb_digest; INSERT INTO prefix_xf_categories SELECT * FROM prefix_bb_categories; INSERT INTO prefix_xf_attachments SELECT * FROM prefix_bb_attachments; INSERT INTO prefix_xf_archive SELECT * FROM prefix_bb_archive;