TRUNCATE `xoops_plzxoo_category`;
TRUNCATE `xoops_plzxoo_question`;
TRUNCATE `xoops_plzxoo_answer`;

REPLACE INTO xoops_plzxoo_category (cid, pid, name, description, size, weight) SELECT categoryid, parentid, name, description, 1, weight FROM xoops_smartfaq_categories;

REPLACE INTO xoops_plzxoo_question (qid, cid, uid, subject, body, input_date, modified_date, priority, status, size, for_search) SELECT faqid, categoryid, uid, question, question, datesub, datesub, 1, 1, 1, '' FROM xoops_smartfaq_faq;

REPLACE INTO xoops_plzxoo_answer (aid, qid, uid, input_date, modified_date, body, comment, point) SELECT answerid, faqid, uid, datesub, datesub, answer, '', 0 FROM xoops_smartfaq_answers;

UPDATE xoops_smartfaq_answers s, xoops_plzxoo_question x SET x.for_search = s.answer WHERE x.qid = s.faqid;