Copy Post to forum

DROP TABLE IF EXISTS `fcsapxmy_forum4hk`.`mybb_posts`;

CREATE TABLE `fcsapxmy_forum4hk`.`mybb_posts` (

  `pid` int UNSIGNED NOT NULL,

  `tid` int UNSIGNED NOT NULL DEFAULT '0',

  `replyto` int UNSIGNED NOT NULL DEFAULT '0',

  `fid` smallint UNSIGNED NOT NULL DEFAULT '0',

  `subject` varchar(120) NOT NULL DEFAULT '',

  `icon` smallint UNSIGNED NOT NULL DEFAULT '0',

  `uid` int UNSIGNED NOT NULL DEFAULT '0',

  `username` varchar(80) NOT NULL DEFAULT '',

  `dateline` int UNSIGNED NOT NULL DEFAULT '0',

  `message` text NOT NULL,

  `ipaddress` varbinary(16) NOT NULL DEFAULT '',

  `includesig` tinyint(1) NOT NULL DEFAULT '0',

  `smilieoff` tinyint(1) NOT NULL DEFAULT '0',

  `edituid` int UNSIGNED NOT NULL DEFAULT '0',

  `edittime` int UNSIGNED NOT NULL DEFAULT '0',

  `editreason` varchar(150) NOT NULL DEFAULT '',

  `visible` tinyint(1) NOT NULL DEFAULT '0'

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

ALTER TABLE `fcsapxmy_forum4hk`.`mybb_posts` ADD PRIMARY KEY (`pid`), ADD KEY `tid` (`tid`,`uid`), ADD KEY `uid` (`uid`), ADD KEY `visible` (`visible`), ADD KEY `dateline` (`dateline`), ADD KEY `ipaddress` (`ipaddress`), ADD KEY `tiddate` (`tid`,`dateline`);ALTER TABLE `fcsapxmy_forum4hk`.`mybb_posts` ADD FULLTEXT KEY `message` (`message`);

ALTER TABLE `fcsapxmy_forum4hk`.`mybb_posts` MODIFY `pid` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=258664;

SET SQL_MODE='NO_AUTO_VALUE_ON_ZERO';

INSERT INTO `fcsapxmy_forum4hk`.`mybb_posts`(`pid`, `tid`, `replyto`, `fid`, `subject`, `icon`, `uid`, `username`, `dateline`, `message`, `ipaddress`, `includesig`, `smilieoff`, `edituid`, `edittime`, `editreason`, `visible`) SELECT `pid`, `tid`, `replyto`, `fid`, `subject`, `icon`, `uid`, `username`, `dateline`, `message`, `ipaddress`, `includesig`, `smilieoff`, `edituid`, `edittime`, `editreason`, `visible` FROM `fcsapxmy_close`.`mybb_posts`;