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) NOT NULL DEFAULT '0',

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

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

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

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

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

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

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

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

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

  `password` varchar(50) NOT NULL DEFAULT '',

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

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

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

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

  `rulestitle` varchar(200) NOT NULL DEFAULT '',

  `rules` text NOT NULL,

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

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

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

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

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

  `defaultsortby` varchar(10) NOT NULL DEFAULT '',

  `defaultsortorder` varchar(4) NOT NULL DEFAULT ''

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

ALTER TABLE `fcsapxmy_forum4hk`.`mybb_forums` ADD PRIMARY KEY (`fid`);

ALTER TABLE `fcsapxmy_forum4hk`.`mybb_forums` MODIFY `fid` smallint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=42;


SET SQL_MODE='NO_AUTO_VALUE_ON_ZERO';


INSERT INTO `fcsapxmy_forum4hk`.`mybb_forums`(`fid`, `name`, `description`, `linkto`, `type`, `pid`, `parentlist`, `disporder`, `active`, `open`, `threads`, `posts`, `lastpost`, `lastposter`, `lastposteruid`, `lastposttid`, `lastpostsubject`, `allowhtml`, `allowmycode`, `allowsmilies`, `allowimgcode`, `allowvideocode`, `allowpicons`, `allowtratings`, `usepostcounts`, `usethreadcounts`, `requireprefix`, `password`, `showinjump`, `style`, `overridestyle`, `rulestype`, `rulestitle`, `rules`, `unapprovedthreads`, `unapprovedposts`, `deletedthreads`, `deletedposts`, `defaultdatecut`, `defaultsortby`, `defaultsortorder`) SELECT `fid`, `name`, `description`, `linkto`, `type`, `pid`, `parentlist`, `disporder`, `active`, `open`, `threads`, `posts`, `lastpost`, `lastposter`, `lastposteruid`, `lastposttid`, `lastpostsubject`, `allowhtml`, `allowmycode`, `allowsmilies`, `allowimgcode`, `allowvideocode`, `allowpicons`, `allowtratings`, `usepostcounts`, `usethreadcounts`, `requireprefix`, `password`, `showinjump`, `style`, `overridestyle`, `rulestype`, `rulestitle`, `rules`, `unapprovedthreads`, `unapprovedposts`, `deletedthreads`, `deletedposts`, `defaultdatecut`, `defaultsortby`, `defaultsortorder` FROM `fcsapxmy_close`.`mybb_forums`;

Comments

Post a Comment

Popular posts from this blog

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