https://www.icyphoenix.com/viewtopic.php?f=35&t=7982&p=53365#p53365
-----------------------------------
spydie
Mon 08 Aug, 2011 00:16

Re: Change Cms From Nuke Evolution To Icy Phoenix
-----------------------------------
have a look at database update script or sql files in install folder from version 1.3.0.53.x 

there is a merge from posts and posts_text tables 

you should fuind what you need there

something like this
[code linenumbers=false]INSERT INTO `___posts___`
SELECT p.post_id, p.topic_id, p.forum_id, p.poster_id, p.post_time, p.poster_ip, p.post_username, t.post_subject, t.post_text, t.post_text_compiled, p.enable_bbcode, p.enable_html, p.enable_smilies, p.enable_sig, t.edit_notes, p.post_edit_time, p.post_edit_count, p.post_edit_id, p.post_attachment, p.post_bluecard, p.enable_autolinks_acronyms
FROM `phpbb_posts` p, `phpbb_posts_text` t
WHERE p.post_id = t.post_id
ORDER BY p.post_id;

RENAME TABLE `phpbb_posts` TO `_old_phpbb_posts`;
RENAME TABLE `phpbb_posts_text` TO `_old_phpbb_posts_text`;
RENAME TABLE `___posts___` TO `phpbb_posts`;[/code]

you got to sort out, what of this you need


