copy thread

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

CREATE TABLE `fcsapxmy_forum4hk`.`mybb_threads` (

  `tid` int UNSIGNED NOT NULL,

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

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

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

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

  `poll` int 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',

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

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

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

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

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

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

  `closed` varchar(30) NOT NULL DEFAULT '',

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

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

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

  `notes` text NOT NULL,

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

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

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

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

  `deletetime` int UNSIGNED NOT NULL DEFAULT '0'

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

ALTER TABLE `fcsapxmy_forum4hk`.`mybb_threads` ADD PRIMARY KEY (`tid`), ADD KEY `fid` (`fid`,`visible`,`sticky`), ADD KEY `dateline` (`dateline`), ADD KEY `lastpost` (`lastpost`,`fid`), ADD KEY `firstpost` (`firstpost`), ADD KEY `uid` (`uid`);ALTER TABLE `fcsapxmy_forum4hk`.`mybb_threads` ADD FULLTEXT KEY `subject` (`subject`);

ALTER TABLE `fcsapxmy_forum4hk`.`mybb_threads` MODIFY `tid` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14626856;


SET SQL_MODE='NO_AUTO_VALUE_ON_ZERO';


INSERT INTO `fcsapxmy_forum4hk`.`mybb_threads`(`tid`, `fid`, `subject`, `prefix`, `icon`, `poll`, `uid`, `username`, `dateline`, `firstpost`, `lastpost`, `lastposter`, `lastposteruid`, `views`, `replies`, `closed`, `sticky`, `numratings`, `totalratings`, `notes`, `visible`, `unapprovedposts`, `deletedposts`, `attachmentcount`, `deletetime`) SELECT `tid`, `fid`, `subject`, `prefix`, `icon`, `poll`, `uid`, `username`, `dateline`, `firstpost`, `lastpost`, `lastposter`, `lastposteruid`, `views`, `replies`, `closed`, `sticky`, `numratings`, `totalratings`, `notes`, `visible`, `unapprovedposts`, `deletedposts`, `attachmentcount`, `deletetime` FROM `fcsapxmy_close`.`mybb_threads`;

Comments

Post a Comment

Popular posts from this blog

Drop Table

DROP TABLE IF EXISTS `fcsapxmy_forum4hk`.`mybb_forums`; CREATE TABLE `fcsapxmy_forum4hk`.`mybb_forums` (   `fid` smallint UNSIGNED NOT NULL,   `name` varchar(120) NOT NULL DEFAULT '',   `description` text NOT NULL,   `linkto` varchar(180) NOT NULL DEFAULT '',   `type` char(1) NOT NULL DEFAULT '',   `pid` smallint UNSIGNED NOT NULL DEFAULT '0',   `parentlist` text NOT NULL,   `disporder` smallint UNSIGNED NOT NULL DEFAULT '0',   `active` tinyint(1) NOT NULL DEFAULT '0',   `open` tinyint(1) NOT NULL DEFAULT '0',   `threads` int UNSIGNED NOT NULL DEFAULT '0',   `posts` int UNSIGNED NOT NULL DEFAULT '0',   `lastpost` int UNSIGNED NOT NULL DEFAULT '0',   `lastposter` varchar(120) NOT NULL DEFAULT '',   `lastposteruid` int UNSIGNED NOT NULL DEFAULT '0',   `lastposttid` int UNSIGNED NOT NULL DEFAULT '0',   `lastpostsubject` varchar(120) NOT NULL DEFAULT '',   `allowhtml` tinyint(1) ...
Read more

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 D...
Read more