bbPress.org

I’m moving a social site into BuddyPress and the forums used a now defunct DeluxeBB. It doesn’t seem to be one of the options for the Importer Tools. Do any of you know if the structure of DeluxeBB matches that of one of the options listed?

Here are the forums, threads, and posts tables which contain most of the information needed for this migration.

--
-- Table structure for table <code>deluxebb_forums</code>
--

CREATE TABLE IF NOT EXISTS <code>deluxebb_forums</code> (
  <code>ordered</code> int(5) DEFAULT '0',
  <code>cid</code> varchar(225) DEFAULT NULL,
  <code>name</code> varchar(225) DEFAULT NULL,
  <code>fid</code> int(6) NOT NULL AUTO_INCREMENT,
  <code>topics</code> varchar(225) DEFAULT NULL,
  <code>replies</code> varchar(225) DEFAULT NULL,
  <code>viewstatus</code> varchar(10) DEFAULT NULL,
  <code>poststatus</code> varchar(10) DEFAULT NULL,
  <code>replystatus</code> varchar(10) DEFAULT NULL,
  <code>lastpost</code> varchar(225) DEFAULT NULL,
  <code>lastpostby</code> int(10) DEFAULT '0',
  <code>description</code> tinytext,
  <code>lastpid</code> int(6) DEFAULT '0',
  <code>lastpidtime</code> varchar(255) DEFAULT NULL,
  <code>password</code> varchar(32) DEFAULT NULL,
  <code>userlist</code> mediumtext NOT NULL,
  <code>moderators</code> mediumtext NOT NULL,
  <code>ficon</code> varchar(25) NOT NULL,
  PRIMARY KEY (<code>fid</code>),
  KEY <code>cid</code> (<code>cid</code>),
  KEY <code>lastpostby</code> (<code>lastpostby</code>),
  KEY <code>lastpid</code> (<code>lastpid</code>)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;

-- --------------------------------------------------------

--
-- Table structure for table <code>deluxebb_posts</code>
--

CREATE TABLE IF NOT EXISTS <code>deluxebb_posts</code> (
  <code>pid</code> bigint(10) NOT NULL AUTO_INCREMENT,
  <code>tid</code> bigint(10) NOT NULL DEFAULT '0',
  <code>author</code> int(10) NOT NULL DEFAULT '0',
  <code>subject</code> varchar(285) CHARACTER SET latin1 NOT NULL,
  <code>message</code> text NOT NULL,
  <code>picon</code> varchar(50) CHARACTER SET latin1 NOT NULL DEFAULT '',
  <code>postdate</code> int(10) NOT NULL DEFAULT '0',
  <code>ip</code> varchar(50) CHARACTER SET latin1 NOT NULL DEFAULT '',
  <code>smiliesoff</code> smallint(1) DEFAULT '0',
  PRIMARY KEY (<code>pid</code>),
  KEY <code>author</code> (<code>author</code>),
  KEY <code>tid</code> (<code>tid</code>,<code>postdate</code>,<code>ip</code>)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=495424 ;

-- --------------------------------------------------------

--
-- Table structure for table <code>deluxebb_threads</code>
--

CREATE TABLE IF NOT EXISTS <code>deluxebb_threads</code> (
  <code>tid</code> bigint(10) NOT NULL AUTO_INCREMENT,
  <code>fid</code> int(5) NOT NULL DEFAULT '0',
  <code>author</code> int(10) NOT NULL DEFAULT '0',
  <code>subject</code> varchar(285) NOT NULL,
  <code>picon</code> varchar(50) NOT NULL DEFAULT '',
  <code>views</code> int(3) NOT NULL DEFAULT '0',
  <code>replies</code> int(3) NOT NULL DEFAULT '0',
  <code>closed</code> smallint(1) NOT NULL DEFAULT '0',
  <code>pinned</code> smallint(1) NOT NULL DEFAULT '0',
  <code>moved</code> int(10) unsigned DEFAULT '0',
  <code>flame</code> tinyint(1) NOT NULL DEFAULT '0',
  <code>lastpostby</code> varchar(255) NOT NULL DEFAULT '0',
  <code>lastpostdate</code> int(10) NOT NULL DEFAULT '0',
  <code>hiddenby</code> text NOT NULL,
  <code>likedby</code> text NOT NULL,
  PRIMARY KEY (<code>tid</code>),
  KEY <code>fid</code> (<code>fid</code>),
  KEY <code>pinned</code> (<code>pinned</code>),
  KEY <code>lastpostdate</code> (<code>lastpostdate</code>),
  KEY <code>author</code> (<code>author</code>),
  KEY <code>moved</code> (<code>moved</code>),
  KEY <code>ashouts</code> (<code>fid</code>,<code>tid</code>,<code>author</code>)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=406651 ;