myBB Conversion Problem

[J. Williams]

Since the converter for myBB didn't work, I'm stuck on it. It didn't get passed members as I guess the structure has changed

Anyone going to help?

[Oldiesmann]

Can you provide more details? What happens when you get to the members? Does it just sit there in an endless loop or do you get an error?

[J. Williams]

Well we've seemed to get around it with the problem of "A's", the RC3 converter I think is based on 1.0, since it didn't get past members.

[Oldiesmann]

That still doesn't help me much. What exactly do you mean by "it doesn't get past members"? Does it just not convert anything other than members or does it actually give you an error?

[J. Williams]

I'll try and recreate the error, it may take a second. To replicate, try converting using the RC3 converter on the downloads page on an 1.2.1 installation of myBB

[PsychoWolf]

Hi all,
The Problem i have with the converter is as follows :

Converting...
Converting members... Unsuccessful!
This query:

    SELECT
    uid AS ID_MEMBER, SUBSTRING(username, 1, 255) AS memberName,
    SUBSTRING(username, 1, 255) AS realName,
    SUBSTRING(password, 1, 64) AS passwd, email AS emailAddress,
    postnum AS posts, SUBSTRING(usertitle, 1, 255) AS usertitle,
    lastvisit AS lastLogin, IF(usergroup = 4, 1, 0) AS ID_GROUP,
    regdate AS dateRegistered, SUBSTRING(website, 1, 255) AS websiteUrl,
    SUBSTRING(website, 1, 255) AS websiteTitle,
    SUBSTRING(icq, 1, 255) AS ICQ, SUBSTRING(aim, 1, 16) AS AIM,
    SUBSTRING(yahoo, 1, 32) AS YIM, SUBSTRING(msn AS MSN, 1, 255) AS MSN,
    SUBSTRING(signature, 1, 65534) AS signature, hideemail AS hideEmail,
    SUBSTRING(buddylist, 1, 255) AS buddy_list,
    SUBSTRING(regip, 1, 255) AS memberIP, SUBSTRING(regip, 1, 255) AS memberIP2,
    SUBSTRING(ignorelist, 1, 255) AS pm_ignore_list,
    timeonline AS totalTimeLoggedIn,
    IF(birthday = '', '0001-01-01', CONCAT_WS('-', RIGHT(birthday, 4), SUBSTRING(birthday, LOCATE('-', birthday) + 1, LOCATE('-', birthday, LOCATE('-', birthday) + 1) - LOCATE('-', birthday) - 1), LEFT(birthday, LOCATE('-', birthday) - 1))) AS birthdate
    FROM `usr_web344_3`.mybb_users
    LIMIT 0, 500;

Caused the error:

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS MSN, 1, 255) AS MSN,
    SUBSTRING(signature, 1, 65534) AS signature, hideemail ' at line 10

whats the problem ? MyBB Version is 1.2.1 and SMF is Version 1.1 RC3


greets PW

[J. Williams]

Thats mainly the error I got, the only workaround will leave you with password problems and the conventional "a's".

[PsychoWolf]

No Converter in sight ?
Ok so i can't go to SMF and have to stay with the MyBB 

[Oldiesmann]

Give me a minute to go fix that

[Oldiesmann]

Ok. Try this one.

[PsychoWolf]

Thx Oldiesman,
Downloaded and trying it out tomorrow, for so far thanks a lot for your reply 


hreets PW

[PsychoWolf]

Trying it and have to say it won't work 
I have this one at Polls -->

Code Select Expand

Converting polls... Unsuccessful!
This query:

    INSERT INTO `usr_web344_3`.smf_polls
    (ID_POLL, SUBSTRING(p.question, 1, 255), votingLocked, ID_MEMBER, expireTime, posterName)
    VALUES ('1', 'Wie gefällt euch die Webseite ?', 'yes', '2', '0', 'Tuxinator'),
    ('2', 'Was für eine Bandbreite habt ihr ?', 'yes', '2', '225110176211', 'Tuxinator'),
    ('3', 'Was hört ihr persönlich für musik?', 'yes', '71', '0', 'baaastii'),
    ('5', 'Wer ist euer Favorit beim Songcontest ?', 'yes', '2', '0', 'Tuxinator');

Caused the error:

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SUBSTRING(p.question, 1, 255), votingLocked, ID_MEMBER, expireTime, posterName)
    ' at line 2

After i deleted the Polls in the Database, there are only 4 in it, no big dataloss i get this error then 

Code Select Expand

Converting topic view logs... Unsuccessful!
This query:

    INSERT INTO `usr_web344_3`.smf_log_topics
    (ID_TOPIC, ID_MEMBER, logTime)
    VALUES ('149', '3', '1163107633'),
    ('147', '20', '1163284157'),
    ('150', '6', '1163098543'),
    ('62', '4', '1163087508'),
    ('150', '8', '1163021543'),
    ('130', '12', '1163176986'),
    ('150', '5', '1163065532'),
    ('159', '43', '1163248466'),
    ('149', '5', '1163166412'),
    ('149', '2', '1163113260'),
    ('149', '12', '1163159554'),
    ('159', '79', '1163417738'),
    ('150', '7', '1163064010'),
    ('150', '12', '1163004656'),
    ('136', '2', '1163437916'),
    ('130', '4', '1163233259'),
    ('150', '75', '1163099830'),
    ('158', '7', '1163145206'),
    ('147', '65', '1163268960'),
    ('75', '65', '1163361620'),
    ('133', '13', '1163410337'),
    ('158', '57', '1163091172'),
    ('153', '74', '1163100407'),
    ('130', '79', '1163417853'),
    ('155', '72', '1163416982'),
    ('155', '57', '1163154915'),
    ('155', '5', '1163166461'),
    ('154', '5', '1162844002'),
    ('159', '2', '1163175439'),
    ('153', '8', '1163021238'),
    ('159', '8', '1163021149'),
    ('155', '8', '1163267409'),
    ('130', '74', '1163205972'),
    ('150', '65', '1163268918'),
    ('159', '35', '1163137660'),
    ('158', '35', '1163435461'),
    ('158', '13', '1163002690'),
    ('104', '13', '1163293232'),
    ('150', '13', '1163002537'),
    ('19', '74', '1163001151'),
    ('128', '12', '1162992684'),
    ('159', '74', '1163172070'),
    ('158', '23', '1162842721'),
    ('153', '23', '1162842441'),
    ('158', '6', '1163098500'),
    ('6', '16', '1163091213'),
    ('154', '6', '1162923302'),
    ('159', '4', '1163261504'),
    ('158', '43', '1163088041'),
    ('104', '2', '1162834335'),
    ('158', '12', '1163434521'),
    ('14', '65', '1163107272'),
    ('136', '71', '1163329780'),
    ('134', '71', '1163138489'),
    ('104', '4', '1163261666'),
    ('131', '65', '1163105415'),
    ('158', '4', '1163418925'),
    ('158', '3', '1162912821'),
    ('158', '74', '1163434421'),
    ('158', '2', '1163427794'),
    ('153', '79', '1163417796'),
    ('156', '6', '1163336742'),
    ('153', '13', '1163002838'),
    ('158', '75', '1162848471'),
    ('158', '71', '1162879112'),
    ('158', '52', '1163090701'),
    ('158', '72', '1163416965'),
    ('143', '5', '1162989003'),
    ('111', '89', '1163186570'),
    ('130', '2', '1163437897'),
    ('153', '3', '1162834013'),
    ('153', '65', '1163010238'),
    ('159', '75', '1163237935'),
    ('159', '3', '1163107554'),
    ('159', '65', '1163105910'),
    ('159', '5', '1163166423'),
    ('159', '57', '1163154848'),
    ('104', '5', '1162930843'),
    ('158', '5', '1163420070'),
    ('142', '5', '1162902191'),
    ('147', '6', '1162923725'),
    ('159', '6', '1163098461'),
    ('157', '6', '1163336731'),
    ('149', '35', '1163137722'),
    ('159', '72', '1162896329'),
    ('159', '71', '1163138346'),
    ('159', '12', '1163276365'),
    ('159', '20', '1163358874'),
    ('83', '72', '1163417080'),
    ('128', '8', '1163054666'),
    ('63', '65', '1163105344'),
    ('130', '71', '1163177041'),
    ('130', '5', '1163187521'),
    ('62', '13', '1163169404'),
    ('6', '13', '1163167971'),
    ('99', '57', '1163155018'),
    ('149', '87', '1163118037'),
    ('143', '4', '1163113310'),
    ('124', '65', '1163105478'),
    ('157', '13', '1163347538'),
    ('134', '65', '1163105328'),
    ('103', '65', '1163105305'),
    ('137', '65', '1163105282'),
    ('5', '65', '1163105266'),
    ('159', '66', '1163419539'),
    ('133', '4', '1163418869'),
    ('155', '65', '1163105116'),
    ('155', '79', '1163418049'),
    ('149', '65', '1163107301'),
    ('130', '75', '1163193793'),
    ('64', '89', '1163187349'),
    ('63', '89', '1163187229'),
    ('159', '89', '1163185928'),
    ('130', '89', '1163185313'),
    ('130', '72', '1163181348'),
    ('14', '7', '1163064719'),
    ('62', '7', '1163064774'),
    ('6', '7', '1163064785'),
    ('86', '20', '1163283904'),
    ('130', '20', '1163268364'),
    ('149', '20', '1163268339'),
    ('130', '8', '1163267291'),
    ('149', '75', '1163237923'),
    ('149', '74', '1163206012'),
    ('150', '4', '1163005530'),
    ('62', '3', '1162919952'),
    ('6', '4', '1163340203'),
    ('150', '40', '1163023776'),
    ('6', '74', '1163001122'),
    ('150', '72', '1163074038'),
    ('149', '71', '1163138441'),
    ('153', '2', '1162833179'),
    ('150', '57', '1163066609'),
    ('149', '57', '1163154873'),
    ('99', '2', '1163437932'),
    ('153', '5', '1162844044'),
    ('50', '13', '1163259603'),
    ('153', '20', '1162847663'),
    ('86', '43', '1163320369'),
    ('153', '43', '1163087436'),
    ('150', '43', '1163087099'),
    ('149', '43', '1163248547'),
    ('153', '35', '1163002974'),
    ('150', '35', '1163002869'),
    ('153', '12', '1163169647'),
    ('72', '20', '1163358815'),
    ('158', '79', '1163418498'),
    ('154', '35', '1163002941'),
    ('155', '61', '1163358941'),
    ('27', '20', '1163358796'),
    ('155', '78', '1163164215'),
    ('155', '35', '1163137603'),
    ('155', '52', '1163067614'),
    ('155', '74', '1163171999'),
    ('151', '79', '1163419178'),
    ('154', '74', '1162845307'),
    ('69', '13', '1163432627'),
    ('154', '3', '1162856822'),
    ('133', '5', '1163420201'),
    ('154', '2', '1162854574'),
    ('155', '13', '1162858230'),
    ('155', '2', '1163113104'),
    ('149', '79', '1163417973'),
    ('154', '65', '1163269161'),
    ('147', '79', '1163419043'),
    ('155', '12', '1163105089'),
    ('154', '79', '1163418860'),
    ('150', '79', '1163418788'),
    ('158', '8', '1163021945'),
    ('151', '8', '1163053927'),
    ('38', '8', '1163054642'),
    ('79', '8', '1163055177'),
    ('67', '8', '1163055183'),
    ('20', '8', '1163055196'),
    ('15', '8', '1163055290'),
    ('4', '8', '1163056484'),
    ('159', '7', '1163063933'),
    ('59', '7', '1163064218'),
    ('15', '7', '1163064525'),
    ('153', '52', '1163067020'),
    ('150', '52', '1163067504'),
    ('157', '52', '1163067560'),
    ('158', '29', '1163070836'),
    ('150', '29', '1163070898'),
    ('153', '29', '1163070987'),
    ('159', '29', '1163071006'),
    ('83', '26', '1163078801'),
    ('150', '26', '1163078583'),
    ('153', '26', '1163078641'),
    ('155', '26', '1163078666'),
    ('157', '43', '1163087111'),
    ('155', '43', '1163248526'),
    ('83', '43', '1163087390'),
    ('133', '12', '1163434475'),
    ('133', '74', '1163434524'),
    ('130', '35', '1163435420'),
    ('133', '35', '1163435425'),
    ('152', '2', '1163437861');

Caused the error:

    Unknown column 'logTime' in 'field list'


greets PW

[Oldiesmann]

Ok. Try this one.

[PsychoWolf]

Thx again for your Quik Reply, but now Problems with pollvotes are happens and i tried to go around them and deleted them in the databse, then i had a Problem with empty attachment database so i deleted this in the .sql file and the conversion finished, but now there are no usernames in the database are set. i tried to let me send a new password and this worked, but i can't login so i keeped an eye to the database and there are the fields with the usernames are blank, no entry of usernames there

[Oldiesmann]

What error(s) did you get with the poll votes?

[PsychoWolf]

This one here :

Code Select Expand

This query:

    INSERT INTO `usr_web344_3`.smf_log_polls
    (ID_POLL, ID_MEMBER, ID_CHOICE)
    VALUES ('1', '3', '0'),
    ('1', '40', '0'),
    ('1', '5', '0'),
    ('1', '2', '0'),
    ('1', '7', '0'),
    ('1', '4', '0'),
    ('1', '13', '0'),
    ('1', '23', '0'),
    ('1', '8', '0'),
    ('1', '35', '0'),
    ('1', '21', '0'),
    ('1', '74', '0'),
    ('1', '63', '0'),
    ('1', '78', '0'),
    ('1', '71', '0'),
    ('1', '65', '0'),
    ('1', '72', '0'),
    ('1', '43', '0'),
    ('2', '2', '0'),
    ('2', '23', '0'),
    ('2', '40', '0'),
    ('2', '13', '0'),
    ('2', '3', '0'),
    ('2', '75', '0'),
    ('2', '74', '0'),
    ('2', '12', '0'),
    ('2', '4', '0'),
    ('2', '7', '0'),
    ('2', '35', '0'),
    ('2', '72', '0'),
    ('2', '5', '0'),
    ('2', '58', '0'),
    ('2', '64', '0'),
    ('2', '79', '0'),
    ('2', '71', '0'),
    ('2', '29', '0'),
    ('2', '8', '0'),
    ('2', '57', '0'),
    ('2', '65', '0'),
    ('2', '21', '0'),
    ('2', '43', '0'),
    ('2', '18', '0'),
    ('3', '71', '0'),
    ('3', '74', '0'),
    ('3', '5', '0'),
    ('3', '4', '0'),
    ('3', '64', '0'),
    ('3', '72', '0'),
    ('3', '43', '0'),
    ('3', '18', '0'),
    ('3', '13', '0'),
    ('3', '3', '0'),
    ('3', '35', '0'),
    ('3', '23', '0'),
    ('3', '12', '0'),
    ('3', '2', '1'),
    ('3', '40', '5'),
    ('3', '16', '1'),
    ('2', '16', '7'),
    ('3', '65', '1'),
    ('3', '8', '5'),
    ('3', '57', '5'),
    ('1', '29', '1'),
    ('1', '58', '1'),
    ('3', '7', '5'),
    ('3', '78', '1'),
    ('5', '0', '9'),
    ('5', '0', '1'),
    ('5', '0', '1'),
    ('5', '0', '5'),
    ('5', '4', '3'),
    ('5', '78', '1'),
    ('5', '8', '1'),
    ('5', '20', '7'),
    ('5', '0', '1'),
    ('5', '35', '2'),
    ('5', '23', '9'),
    ('5', '29', '3'),
    ('5', '75', '1'),
    ('5', '62', '1'),
    ('5', '0', '9'),
    ('5', '72', '9'),
    ('5', '0', '7'),
    ('5', '57', '7'),
    ('5', '43', '9'),
    ('5', '40', '5'),
    ('5', '82', '9'),
    ('3', '0', '1'),
    ('3', '0', '4'),
    ('3', '0', '1'),
    ('3', '0', '5'),
    ('1', '57', '2');

Caused the error:

    Duplicate entry '5-0-1' for key 1

if i delete the entry i get :

Code Select Expand

Duplicate entry '1-3-0' for key 1

i can't give you an attachment here so i post the structure as code :

Code Select Expand

--
-- Host: localhost:3306
-- Erstellungszeit: 14. November 2006 um 00:52
-- Server Version: 4.1.20
-- PHP-Version: 5.0.4
--
-- Datenbank: `*******`
--

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

--
-- Tabellenstruktur für Tabelle `mybb_adminlog`
--

CREATE TABLE `mybb_adminlog` (
  `uid` int(10) unsigned NOT NULL default '0',
  `dateline` bigint(30) NOT NULL default '0',
  `scriptname` varchar(50) NOT NULL default '',
  `action` varchar(50) NOT NULL default '',
  `querystring` varchar(150) NOT NULL default '',
  `ipaddress` varchar(50) NOT NULL default '',
  KEY `scriptname` (`scriptname`,`action`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabellenstruktur für Tabelle `mybb_adminoptions`
--

CREATE TABLE `mybb_adminoptions` (
  `uid` int(10) NOT NULL default '0',
  `cpstyle` varchar(50) NOT NULL default '',
  `notes` text NOT NULL,
  `permsset` int(1) NOT NULL default '0',
  `caneditsettings` char(3) NOT NULL default '',
  `caneditann` char(3) NOT NULL default '',
  `caneditforums` char(3) NOT NULL default '',
  `canmodposts` char(3) NOT NULL default '',
  `caneditsmilies` char(3) NOT NULL default '',
  `caneditpicons` char(3) NOT NULL default '',
  `caneditthemes` char(3) NOT NULL default '',
  `canedittemps` char(3) NOT NULL default '',
  `caneditusers` char(3) NOT NULL default '',
  `caneditpfields` char(3) NOT NULL default '',
  `caneditugroups` char(3) NOT NULL default '',
  `caneditaperms` char(3) NOT NULL default '',
  `caneditutitles` char(3) NOT NULL default '',
  `caneditattach` char(3) NOT NULL default '',
  `canedithelp` char(3) NOT NULL default '',
  `caneditlangs` char(3) NOT NULL default '',
  `canrunmaint` char(3) NOT NULL default '',
  `canrundbtools` char(3) NOT NULL default '',
  `can_manage_fws` char(3) NOT NULL default 'yes',
  PRIMARY KEY  (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabellenstruktur für Tabelle `mybb_adminsessions`
--

CREATE TABLE `mybb_adminsessions` (
  `sid` varchar(32) NOT NULL default '',
  `uid` int(10) unsigned NOT NULL default '0',
  `loginkey` varchar(50) NOT NULL default '',
  `ip` varchar(40) NOT NULL default '',
  `dateline` bigint(30) NOT NULL default '0',
  `lastactive` bigint(30) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabellenstruktur für Tabelle `mybb_announcements`
--

CREATE TABLE `mybb_announcements` (
  `aid` int(10) unsigned NOT NULL auto_increment,
  `fid` int(10) NOT NULL default '0',
  `uid` int(10) unsigned NOT NULL default '0',
  `subject` varchar(120) NOT NULL default '',
  `message` text NOT NULL,
  `startdate` bigint(30) NOT NULL default '0',
  `enddate` bigint(30) NOT NULL default '0',
  `allowhtml` char(3) NOT NULL default '',
  `allowmycode` char(3) NOT NULL default '',
  `allowsmilies` char(3) NOT NULL default '',
  PRIMARY KEY  (`aid`),
  KEY `fid` (`fid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

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

--
-- Tabellenstruktur für Tabelle `mybb_attachments`
--

CREATE TABLE `mybb_attachments` (
  `aid` int(10) unsigned NOT NULL auto_increment,
  `pid` int(10) NOT NULL default '0',
  `posthash` varchar(50) NOT NULL default '',
  `uid` int(10) unsigned NOT NULL default '0',
  `filename` varchar(120) NOT NULL default '',
  `filetype` varchar(120) NOT NULL default '',
  `filesize` int(10) NOT NULL default '0',
  `attachname` varchar(120) NOT NULL default '',
  `downloads` int(10) unsigned NOT NULL default '0',
  `visible` int(1) NOT NULL default '0',
  `thumbnail` varchar(120) NOT NULL default '',
  PRIMARY KEY  (`aid`),
  KEY `posthash` (`posthash`),
  KEY `pid` (`pid`,`visible`),
  KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Tabellenstruktur für Tabelle `mybb_attachtypes`
--

CREATE TABLE `mybb_attachtypes` (
  `atid` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(120) NOT NULL default '',
  `mimetype` varchar(120) NOT NULL default '',
  `extension` varchar(10) NOT NULL default '',
  `maxsize` int(15) NOT NULL default '0',
  `icon` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`atid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;

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

--
-- Tabellenstruktur für Tabelle `mybb_awaitingactivation`
--

CREATE TABLE `mybb_awaitingactivation` (
  `aid` int(10) unsigned NOT NULL auto_increment,
  `uid` int(10) unsigned NOT NULL default '0',
  `dateline` bigint(30) NOT NULL default '0',
  `code` varchar(100) NOT NULL default '',
  `type` char(1) NOT NULL default '',
  `oldgroup` bigint(30) NOT NULL default '0',
  `misc` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

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

--
-- Tabellenstruktur für Tabelle `mybb_badwords`
--

CREATE TABLE `mybb_badwords` (
  `bid` int(10) unsigned NOT NULL auto_increment,
  `badword` varchar(100) NOT NULL default '',
  `replacement` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`bid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Tabellenstruktur für Tabelle `mybb_banned`
--

CREATE TABLE `mybb_banned` (
  `uid` int(10) unsigned NOT NULL default '0',
  `gid` int(10) unsigned NOT NULL default '0',
  `oldgroup` int(10) unsigned NOT NULL default '0',
  `admin` int(10) unsigned NOT NULL default '0',
  `dateline` bigint(30) NOT NULL default '0',
  `bantime` varchar(50) NOT NULL default '',
  `lifted` bigint(30) NOT NULL default '0',
  `reason` varchar(255) NOT NULL default '',
  KEY `uid` (`uid`),
  KEY `dateline` (`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabellenstruktur für Tabelle `mybb_captcha`
--

CREATE TABLE `mybb_captcha` (
  `imagehash` varchar(32) NOT NULL default '',
  `imagestring` varchar(8) NOT NULL default '',
  `dateline` bigint(30) NOT NULL default '0',
  KEY `imagehash` (`imagehash`),
  KEY `dateline` (`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabellenstruktur für Tabelle `mybb_datacache`
--

CREATE TABLE `mybb_datacache` (
  `title` varchar(50) NOT NULL default '',
  `cache` mediumtext NOT NULL,
  PRIMARY KEY  (`title`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabellenstruktur für Tabelle `mybb_events`
--

CREATE TABLE `mybb_events` (
  `eid` int(10) unsigned NOT NULL auto_increment,
  `subject` varchar(120) NOT NULL default '',
  `author` int(10) unsigned NOT NULL default '0',
  `date` varchar(50) NOT NULL default '',
  `description` text NOT NULL,
  `private` char(3) NOT NULL default '',
  PRIMARY KEY  (`eid`),
  KEY `private` (`private`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

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

--
-- Tabellenstruktur für Tabelle `mybb_favorites`
--

CREATE TABLE `mybb_favorites` (
  `fid` int(10) unsigned NOT NULL auto_increment,
  `uid` int(10) unsigned NOT NULL default '0',
  `tid` int(10) unsigned NOT NULL default '0',
  `type` char(1) NOT NULL default '',
  PRIMARY KEY  (`fid`),
  KEY `uid` (`uid`),
  KEY `tid` (`tid`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=35 ;

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

--
-- Tabellenstruktur für Tabelle `mybb_forumpermissions`
--

CREATE TABLE `mybb_forumpermissions` (
  `pid` int(10) unsigned NOT NULL auto_increment,
  `fid` int(10) unsigned NOT NULL default '0',
  `gid` int(10) unsigned NOT NULL default '0',
  `canview` char(3) NOT NULL default '',
  `canviewthreads` char(3) NOT NULL default '',
  `candlattachments` char(3) NOT NULL default '',
  `canpostthreads` char(3) NOT NULL default '',
  `canpostreplys` char(3) NOT NULL default '',
  `canpostattachments` char(3) NOT NULL default '',
  `canratethreads` char(3) NOT NULL default '',
  `caneditposts` char(3) NOT NULL default '',
  `candeleteposts` char(3) NOT NULL default '',
  `candeletethreads` char(3) NOT NULL default '',
  `caneditattachments` char(3) NOT NULL default '',
  `canpostpolls` char(3) NOT NULL default '',
  `canvotepolls` char(3) NOT NULL default '',
  `cansearch` char(3) NOT NULL default '',
  PRIMARY KEY  (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=315 ;

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

--
-- Tabellenstruktur für Tabelle `mybb_forums`
--

CREATE TABLE `mybb_forums` (
  `fid` smallint(5) unsigned NOT NULL auto_increment,
  `name` varchar(120) NOT NULL default '',
  `description` text NOT NULL,
  `linkto` varchar(180) NOT NULL default '',
  `type` char(1) NOT NULL default '',
  `pid` smallint(5) unsigned NOT NULL default '0',
  `parentlist` text NOT NULL,
  `disporder` smallint(5) unsigned NOT NULL default '0',
  `active` char(3) NOT NULL default '',
  `open` char(3) NOT NULL default '',
  `threads` int(10) unsigned NOT NULL default '0',
  `posts` int(10) unsigned NOT NULL default '0',
  `lastpost` int(10) unsigned NOT NULL default '0',
  `lastposter` varchar(120) NOT NULL default '',
  `lastposteruid` int(10) unsigned NOT NULL default '0',
  `lastposttid` int(10) NOT NULL default '0',
  `lastpostsubject` varchar(120) NOT NULL default '',
  `allowhtml` char(3) NOT NULL default '',
  `allowmycode` char(3) NOT NULL default '',
  `allowsmilies` char(3) NOT NULL default '',
  `allowimgcode` char(3) NOT NULL default '',
  `allowpicons` char(3) NOT NULL default '',
  `allowtratings` char(3) NOT NULL default '',
  `status` int(4) NOT NULL default '1',
  `usepostcounts` char(3) NOT NULL default '',
  `password` varchar(50) NOT NULL default '',
  `showinjump` char(3) NOT NULL default '',
  `modposts` char(3) NOT NULL default '',
  `modthreads` char(3) NOT NULL default '',
  `modattachments` char(3) NOT NULL default '',
  `style` smallint(5) unsigned NOT NULL default '0',
  `overridestyle` char(3) NOT NULL default '',
  `rulestype` smallint(1) NOT NULL default '0',
  `rulestitle` varchar(200) NOT NULL default '',
  `rules` text NOT NULL,
  `unapprovedthreads` int(10) unsigned NOT NULL default '0',
  `unapprovedposts` int(10) unsigned NOT NULL default '0',
  `defaultdatecut` smallint(4) unsigned NOT NULL default '0',
  `defaultsortby` varchar(10) NOT NULL default '',
  `defaultsortorder` varchar(4) NOT NULL default '',
  PRIMARY KEY  (`fid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=37 ;

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

--
-- Tabellenstruktur für Tabelle `mybb_forumsubscriptions`
--

CREATE TABLE `mybb_forumsubscriptions` (
  `fsid` int(10) unsigned NOT NULL auto_increment,
  `fid` smallint(5) unsigned NOT NULL default '0',
  `uid` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`fsid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Tabellenstruktur für Tabelle `mybb_fws_types`
--

CREATE TABLE `mybb_fws_types` (
  `tid` smallint(6) NOT NULL auto_increment,
  `name` varchar(50) NOT NULL default '',
  `description` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

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

--
-- Tabellenstruktur für Tabelle `mybb_fws_warnings`
--

CREATE TABLE `mybb_fws_warnings` (
  `wid` smallint(6) NOT NULL auto_increment,
  `uid` smallint(6) NOT NULL default '0',
  `adduid` smallint(6) NOT NULL default '0',
  `points` smallint(5) NOT NULL default '0',
  `dateline` varchar(30) NOT NULL default '',
  `type` smallint(6) NOT NULL default '0',
  `customtype` varchar(50) NOT NULL default '',
  `post` varchar(50) NOT NULL default '',
  `reason` varchar(255) NOT NULL default '',
  `exp_time` varchar(120) NOT NULL default '',
  `expired` char(3) NOT NULL default 'no',
  PRIMARY KEY  (`wid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Tabellenstruktur für Tabelle `mybb_groupleaders`
--

CREATE TABLE `mybb_groupleaders` (
  `lid` smallint(5) unsigned NOT NULL auto_increment,
  `gid` smallint(5) unsigned NOT NULL default '0',
  `uid` int(10) unsigned NOT NULL default '0',
  `canmanagemembers` char(3) NOT NULL default '',
  `canmanagerequests` char(3) NOT NULL default '',
  PRIMARY KEY  (`lid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Tabellenstruktur für Tabelle `mybb_helpdocs`
--

CREATE TABLE `mybb_helpdocs` (
  `hid` smallint(5) unsigned NOT NULL auto_increment,
  `sid` smallint(5) unsigned NOT NULL default '0',
  `name` varchar(120) NOT NULL default '',
  `description` text NOT NULL,
  `document` text NOT NULL,
  `usetranslation` char(3) NOT NULL default '',
  `enabled` char(3) NOT NULL default '',
  `disporder` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`hid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

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

--
-- Tabellenstruktur für Tabelle `mybb_helpsections`
--

CREATE TABLE `mybb_helpsections` (
  `sid` smallint(5) unsigned NOT NULL auto_increment,
  `name` varchar(120) NOT NULL default '',
  `description` text NOT NULL,
  `usetranslation` char(3) NOT NULL default '',
  `enabled` char(3) NOT NULL default '',
  `disporder` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`sid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

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

--
-- Tabellenstruktur für Tabelle `mybb_icons`
--

CREATE TABLE `mybb_icons` (
  `iid` smallint(5) unsigned NOT NULL auto_increment,
  `name` varchar(120) NOT NULL default '',
  `path` varchar(220) NOT NULL default '',
  PRIMARY KEY  (`iid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=27 ;

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

--
-- Tabellenstruktur für Tabelle `mybb_joinrequests`
--

CREATE TABLE `mybb_joinrequests` (
  `rid` int(10) unsigned NOT NULL auto_increment,
  `uid` int(10) unsigned NOT NULL default '0',
  `gid` smallint(5) unsigned NOT NULL default '0',
  `reason` varchar(250) NOT NULL default '',
  `dateline` bigint(30) NOT NULL default '0',
  PRIMARY KEY  (`rid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Tabellenstruktur für Tabelle `mybb_mailqueue`
--

CREATE TABLE `mybb_mailqueue` (
  `mid` int(10) unsigned NOT NULL auto_increment,
  `mailto` varchar(200) NOT NULL default '',
  `mailfrom` varchar(200) NOT NULL default '',
  `subject` varchar(200) NOT NULL default '',
  `message` text NOT NULL,
  `headers` text NOT NULL,
  PRIMARY KEY  (`mid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=40 ;

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

--
-- Tabellenstruktur für Tabelle `mybb_moderatorlog`
--

CREATE TABLE `mybb_moderatorlog` (
  `uid` int(10) unsigned NOT NULL default '0',
  `dateline` bigint(30) NOT NULL default '0',
  `fid` smallint(5) unsigned NOT NULL default '0',
  `tid` int(10) unsigned NOT NULL default '0',
  `pid` int(10) unsigned NOT NULL default '0',
  `action` text NOT NULL,
  `data` text NOT NULL,
  `ipaddress` varchar(50) NOT NULL default '',
  KEY `tid` (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabellenstruktur für Tabelle `mybb_moderators`
--

CREATE TABLE `mybb_moderators` (
  `mid` smallint(5) unsigned NOT NULL auto_increment,
  `fid` smallint(5) unsigned NOT NULL default '0',
  `uid` int(10) unsigned NOT NULL default '0',
  `caneditposts` char(3) NOT NULL default '',
  `candeleteposts` char(3) NOT NULL default '',
  `canviewips` char(3) NOT NULL default '',
  `canopenclosethreads` char(3) NOT NULL default '',
  `canmanagethreads` char(3) NOT NULL default '',
  `canmovetononmodforum` char(3) NOT NULL default '',
  PRIMARY KEY  (`mid`),
  KEY `uid` (`uid`,`fid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

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

--
-- Tabellenstruktur für Tabelle `mybb_modtools`
--

CREATE TABLE `mybb_modtools` (
  `tid` smallint(5) unsigned NOT NULL auto_increment,
  `name` varchar(200) NOT NULL default '',
  `description` text NOT NULL,
  `forums` text NOT NULL,
  `type` char(1) NOT NULL default '',
  `postoptions` text NOT NULL,
  `threadoptions` text NOT NULL,
  PRIMARY KEY  (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Tabellenstruktur für Tabelle `mybb_mycode`
--

CREATE TABLE `mybb_mycode` (
  `cid` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(100) NOT NULL default '',
  `description` text NOT NULL,
  `regex` text NOT NULL,
  `replacement` text NOT NULL,
  `active` char(3) NOT NULL default '',
  PRIMARY KEY  (`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Tabellenstruktur für Tabelle `mybb_polls`
--

CREATE TABLE `mybb_polls` (
  `pid` int(10) unsigned NOT NULL auto_increment,
  `tid` int(10) unsigned NOT NULL default '0',
  `question` varchar(200) NOT NULL default '',
  `dateline` bigint(30) NOT NULL default '0',
  `options` text NOT NULL,
  `votes` text NOT NULL,
  `numoptions` smallint(5) unsigned NOT NULL default '0',
  `numvotes` smallint(5) unsigned NOT NULL default '0',
  `timeout` bigint(30) NOT NULL default '0',
  `closed` char(3) NOT NULL default '',
  `multiple` char(3) NOT NULL default '',
  `public` char(3) NOT NULL default '',
  PRIMARY KEY  (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

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

--
-- Tabellenstruktur für Tabelle `mybb_pollvotes`
--

CREATE TABLE `mybb_pollvotes` (
  `vid` int(10) unsigned NOT NULL auto_increment,
  `pid` int(10) unsigned NOT NULL default '0',
  `uid` int(10) unsigned NOT NULL default '0',
  `voteoption` smallint(5) unsigned NOT NULL default '0',
  `dateline` bigint(30) NOT NULL default '0',
  PRIMARY KEY  (`vid`),
  KEY `pid` (`pid`,`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=93 ;

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

--
-- Tabellenstruktur für Tabelle `mybb_posts`
--

CREATE TABLE `mybb_posts` (
  `pid` int(10) unsigned NOT NULL auto_increment,
  `tid` int(10) unsigned NOT NULL default '0',
  `replyto` int(10) unsigned NOT NULL default '0',
  `fid` smallint(5) unsigned NOT NULL default '0',
  `subject` varchar(120) NOT NULL default '',
  `icon` smallint(5) unsigned NOT NULL default '0',
  `uid` int(10) unsigned NOT NULL default '0',
  `username` varchar(80) NOT NULL default '',
  `dateline` bigint(30) NOT NULL default '0',
  `message` text NOT NULL,
  `ipaddress` varchar(30) NOT NULL default '',
  `includesig` char(3) NOT NULL default '',
  `smilieoff` char(3) NOT NULL default '',
  `edituid` int(10) unsigned NOT NULL default '0',
  `edittime` int(10) NOT NULL default '0',
  `visible` int(1) NOT NULL default '0',
  `posthash` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`pid`),
  KEY `tid` (`tid`,`uid`),
  KEY `uid` (`uid`),
  KEY `dateline` (`dateline`),
  FULLTEXT KEY `message` (`message`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=528 ;

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

--
-- Tabellenstruktur für Tabelle `mybb_privatemessages`
--

CREATE TABLE `mybb_privatemessages` (
  `pmid` int(10) unsigned NOT NULL auto_increment,
  `uid` int(10) unsigned NOT NULL default '0',
  `toid` int(10) unsigned NOT NULL default '0',
  `fromid` int(10) unsigned NOT NULL default '0',
  `folder` smallint(5) unsigned NOT NULL default '1',
  `subject` varchar(120) NOT NULL default '',
  `icon` smallint(5) unsigned NOT NULL default '0',
  `message` text NOT NULL,
  `dateline` bigint(30) NOT NULL default '0',
  `status` int(1) NOT NULL default '0',
  `includesig` char(3) NOT NULL default '',
  `smilieoff` char(3) NOT NULL default '',
  `receipt` int(1) NOT NULL default '0',
  `readtime` bigint(30) NOT NULL default '0',
  PRIMARY KEY  (`pmid`),
  KEY `pmid` (`pmid`),
  KEY `uid` (`uid`,`folder`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=35 ;

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

--
-- Tabellenstruktur für Tabelle `mybb_profilefields`
--

CREATE TABLE `mybb_profilefields` (
  `fid` smallint(5) unsigned NOT NULL auto_increment,
  `name` varchar(100) NOT NULL default '',
  `description` text NOT NULL,
  `disporder` smallint(5) unsigned NOT NULL default '0',
  `type` text NOT NULL,
  `length` smallint(5) unsigned NOT NULL default '0',
  `maxlength` smallint(5) unsigned NOT NULL default '0',
  `required` char(3) NOT NULL default '',
  `editable` char(3) NOT NULL default '',
  `hidden` char(3) NOT NULL default '',
  PRIMARY KEY  (`fid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

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

--
-- Tabellenstruktur für Tabelle `mybb_reportedposts`
--

CREATE TABLE `mybb_reportedposts` (
  `rid` int(10) unsigned NOT NULL auto_increment,
  `pid` int(10) unsigned NOT NULL default '0',
  `tid` int(10) unsigned NOT NULL default '0',
  `fid` int(10) unsigned NOT NULL default '0',
  `uid` int(10) unsigned NOT NULL default '0',
  `reportstatus` int(1) NOT NULL default '0',
  `reason` varchar(250) NOT NULL default '',
  `dateline` bigint(30) NOT NULL default '0',
  PRIMARY KEY  (`rid`),
  KEY `fid` (`fid`),
  KEY `dateline` (`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Tabellenstruktur für Tabelle `mybb_reputation`
--

CREATE TABLE `mybb_reputation` (
  `rid` int(10) unsigned NOT NULL auto_increment,
  `uid` int(10) unsigned NOT NULL default '0',
  `adduid` int(10) unsigned NOT NULL default '0',
  `reputation` bigint(30) NOT NULL default '0',
  `dateline` bigint(30) NOT NULL default '0',
  `comments` text NOT NULL,
  PRIMARY KEY  (`rid`),
  KEY `uid` (`uid`),
  KEY `dateline` (`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

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

--
-- Tabellenstruktur für Tabelle `mybb_searchlog`
--

CREATE TABLE `mybb_searchlog` (
  `sid` varchar(32) NOT NULL default '',
  `uid` int(10) unsigned NOT NULL default '0',
  `dateline` bigint(30) NOT NULL default '0',
  `ipaddress` varchar(120) NOT NULL default '',
  `threads` text NOT NULL,
  `posts` text NOT NULL,
  `searchtype` varchar(10) NOT NULL default '',
  `resulttype` varchar(10) NOT NULL default '',
  `querycache` text NOT NULL,
  PRIMARY KEY  (`sid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabellenstruktur für Tabelle `mybb_sessions`
--

CREATE TABLE `mybb_sessions` (
  `sid` varchar(32) NOT NULL default '',
  `uid` int(10) unsigned NOT NULL default '0',
  `ip` varchar(40) NOT NULL default '',
  `time` bigint(30) NOT NULL default '0',
  `location` varchar(150) NOT NULL default '',
  `useragent` varchar(100) NOT NULL default '',
  `anonymous` int(1) NOT NULL default '0',
  `nopermission` int(1) NOT NULL default '0',
  `location1` int(10) NOT NULL default '0',
  `location2` int(10) NOT NULL default '0',
  `loginattempts` tinyint(2) NOT NULL default '1',
  `failedlogin` bigint(30) NOT NULL default '0',
  PRIMARY KEY  (`sid`),
  KEY `location1` (`location1`),
  KEY `location2` (`location2`),
  KEY `time` (`time`),
  KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabellenstruktur für Tabelle `mybb_settinggroups`
--

CREATE TABLE `mybb_settinggroups` (
  `gid` smallint(5) unsigned NOT NULL auto_increment,
  `name` varchar(100) NOT NULL default '',
  `title` varchar(220) NOT NULL default '',
  `description` text NOT NULL,
  `disporder` smallint(5) unsigned NOT NULL default '0',
  `isdefault` char(3) NOT NULL default '',
  PRIMARY KEY  (`gid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=48 ;

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

--
-- Tabellenstruktur für Tabelle `mybb_settings`
--

CREATE TABLE `mybb_settings` (
  `sid` smallint(5) unsigned NOT NULL auto_increment,
  `name` varchar(120) NOT NULL default '',
  `title` varchar(120) NOT NULL default '',
  `description` text NOT NULL,
  `optionscode` text NOT NULL,
  `value` text NOT NULL,
  `disporder` smallint(5) unsigned NOT NULL default '0',
  `gid` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`sid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=323 ;

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

--
-- Tabellenstruktur für Tabelle `mybb_smilies`
--

CREATE TABLE `mybb_smilies` (
  `sid` smallint(5) unsigned NOT NULL auto_increment,
  `name` varchar(120) NOT NULL default '',
  `find` varchar(120) NOT NULL default '',
  `image` varchar(220) NOT NULL default '',
  `disporder` smallint(5) unsigned NOT NULL default '0',
  `showclickable` char(3) NOT NULL default '',
  PRIMARY KEY  (`sid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=123 ;

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

--
-- Tabellenstruktur für Tabelle `mybb_templategroups`
--

CREATE TABLE `mybb_templategroups` (
  `gid` int(10) unsigned NOT NULL auto_increment,
  `prefix` varchar(50) NOT NULL default '',
  `title` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`gid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=27 ;

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

--
-- Tabellenstruktur für Tabelle `mybb_templates`
--

CREATE TABLE `mybb_templates` (
  `tid` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(120) NOT NULL default '',
  `template` text NOT NULL,
  `sid` int(10) NOT NULL default '0',
  `version` varchar(20) NOT NULL default '0',
  `status` varchar(10) NOT NULL default '',
  `dateline` int(10) NOT NULL default '0',
  PRIMARY KEY  (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=529 ;

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

--
-- Tabellenstruktur für Tabelle `mybb_templatesets`
--

CREATE TABLE `mybb_templatesets` (
  `sid` smallint(5) unsigned NOT NULL auto_increment,
  `title` varchar(120) NOT NULL default '',
  PRIMARY KEY  (`sid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

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

--
-- Tabellenstruktur für Tabelle `mybb_themes`
--

CREATE TABLE `mybb_themes` (
  `tid` smallint(5) unsigned NOT NULL auto_increment,
  `name` varchar(100) NOT NULL default '',
  `pid` smallint(5) unsigned NOT NULL default '0',
  `def` smallint(1) NOT NULL default '0',
  `css` text NOT NULL,
  `cssbits` text NOT NULL,
  `themebits` text NOT NULL,
  `extracss` text NOT NULL,
  `allowedgroups` text NOT NULL,
  `csscached` bigint(30) NOT NULL default '0',
  PRIMARY KEY  (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

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

--
-- Tabellenstruktur für Tabelle `mybb_threadratings`
--

CREATE TABLE `mybb_threadratings` (
  `rid` int(10) unsigned NOT NULL auto_increment,
  `tid` int(10) unsigned NOT NULL default '0',
  `uid` int(10) unsigned NOT NULL default '0',
  `rating` smallint(5) unsigned NOT NULL default '0',
  `ipaddress` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`rid`),
  KEY `tid` (`tid`,`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Tabellenstruktur für Tabelle `mybb_threads`
--

CREATE TABLE `mybb_threads` (
  `tid` int(10) unsigned NOT NULL auto_increment,
  `fid` smallint(5) unsigned NOT NULL default '0',
  `subject` varchar(120) NOT NULL default '',
  `icon` smallint(5) unsigned NOT NULL default '0',
  `poll` int(10) unsigned NOT NULL default '0',
  `uid` int(10) unsigned NOT NULL default '0',
  `username` varchar(80) NOT NULL default '',
  `dateline` bigint(30) NOT NULL default '0',
  `firstpost` int(10) unsigned NOT NULL default '0',
  `lastpost` bigint(30) NOT NULL default '0',
  `lastposter` varchar(120) NOT NULL default '',
  `lastposteruid` int(10) unsigned NOT NULL default '0',
  `views` int(100) NOT NULL default '0',
  `replies` int(100) NOT NULL default '0',
  `closed` varchar(30) NOT NULL default '',
  `sticky` int(1) NOT NULL default '0',
  `numratings` smallint(5) unsigned NOT NULL default '0',
  `totalratings` smallint(5) unsigned NOT NULL default '0',
  `notes` text NOT NULL,
  `visible` int(1) NOT NULL default '0',
  `unapprovedposts` int(10) unsigned NOT NULL default '0',
  `attachmentcount` int(10) unsigned NOT NULL default '0',
  `deletetime` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`tid`),
  KEY `fid` (`fid`,`visible`,`sticky`),
  KEY `dateline` (`dateline`),
  KEY `lastpost` (`lastpost`,`fid`),
  KEY `firstpost` (`firstpost`),
  KEY `uid` (`uid`),
  FULLTEXT KEY `subject` (`subject`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=160 ;

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

--
-- Tabellenstruktur für Tabelle `mybb_threadsread`
--

CREATE TABLE `mybb_threadsread` (
  `tid` int(10) unsigned NOT NULL default '0',
  `uid` int(10) unsigned NOT NULL default '0',
  `dateline` int(10) NOT NULL default '0',
  UNIQUE KEY `tiduid` (`tid`,`uid`),
  KEY `dateline` (`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabellenstruktur für Tabelle `mybb_userfields`
--

CREATE TABLE `mybb_userfields` (
  `ufid` int(10) unsigned NOT NULL default '0',
  `fid1` text NOT NULL,
  `fid2` text NOT NULL,
  `fid3` text NOT NULL,
  `fid4` text NOT NULL,
  `fid5` text NOT NULL,
  PRIMARY KEY  (`ufid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabellenstruktur für Tabelle `mybb_usergroups`
--

CREATE TABLE `mybb_usergroups` (
  `gid` smallint(5) unsigned NOT NULL auto_increment,
  `type` smallint(2) NOT NULL default '2',
  `title` varchar(120) NOT NULL default '',
  `description` text NOT NULL,
  `namestyle` varchar(200) NOT NULL default '{username}',
  `usertitle` varchar(120) NOT NULL default '',
  `stars` smallint(4) NOT NULL default '0',
  `starimage` varchar(120) NOT NULL default '',
  `image` varchar(120) NOT NULL default '',
  `disporder` smallint(6) unsigned NOT NULL default '0',
  `isbannedgroup` char(3) NOT NULL default '',
  `canview` char(3) NOT NULL default '',
  `canviewthreads` char(3) NOT NULL default '',
  `canviewprofiles` char(3) NOT NULL default '',
  `candlattachments` char(3) NOT NULL default '',
  `canpostthreads` char(3) NOT NULL default '',
  `canpostreplys` char(3) NOT NULL default '',
  `canpostattachments` char(3) NOT NULL default '',
  `canratethreads` char(3) NOT NULL default '',
  `caneditposts` char(3) NOT NULL default '',
  `candeleteposts` char(3) NOT NULL default '',
  `candeletethreads` char(3) NOT NULL default '',
  `caneditattachments` char(3) NOT NULL default '',
  `canpostpolls` char(3) NOT NULL default '',
  `canvotepolls` char(3) NOT NULL default '',
  `canusepms` char(3) NOT NULL default '',
  `cansendpms` char(3) NOT NULL default '',
  `cantrackpms` char(3) NOT NULL default '',
  `candenypmreceipts` char(3) NOT NULL default '',
  `pmquota` int(3) NOT NULL default '0',
  `cansendemail` char(3) NOT NULL default '',
  `canviewmemberlist` char(3) NOT NULL default '',
  `canviewcalendar` char(3) NOT NULL default '',
  `canaddpublicevents` char(3) NOT NULL default '',
  `canaddprivateevents` char(3) NOT NULL default '',
  `canviewonline` char(3) NOT NULL default '',
  `canviewwolinvis` char(3) NOT NULL default '',
  `canviewonlineips` char(3) NOT NULL default '',
  `cancp` char(3) NOT NULL default '',
  `issupermod` char(3) NOT NULL default '',
  `cansearch` char(3) NOT NULL default '',
  `canusercp` char(3) NOT NULL default '',
  `canuploadavatars` char(3) NOT NULL default '',
  `canratemembers` char(3) NOT NULL default '',
  `canchangename` char(3) NOT NULL default '',
  `showforumteam` char(3) NOT NULL default '',
  `usereputationsystem` char(3) NOT NULL default '',
  `cangivereputations` char(3) NOT NULL default '',
  `reputationpower` bigint(30) NOT NULL default '0',
  `maxreputationsday` bigint(30) NOT NULL default '0',
  `candisplaygroup` char(3) NOT NULL default '',
  `attachquota` bigint(30) NOT NULL default '0',
  `cancustomtitle` char(3) NOT NULL default '',
  PRIMARY KEY  (`gid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

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

--
-- Tabellenstruktur für Tabelle `mybb_users`
--

CREATE TABLE `mybb_users` (
  `uid` int(10) unsigned NOT NULL auto_increment,
  `username` varchar(120) NOT NULL default '',
  `password` varchar(120) NOT NULL default '',
  `salt` varchar(10) NOT NULL default '',
  `loginkey` varchar(50) NOT NULL default '',
  `email` varchar(220) NOT NULL default '',
  `postnum` int(10) NOT NULL default '0',
  `avatar` varchar(200) NOT NULL default '',
  `avatardimensions` varchar(10) NOT NULL default '',
  `avatartype` varchar(10) NOT NULL default '0',
  `usergroup` smallint(5) unsigned NOT NULL default '0',
  `additionalgroups` varchar(200) NOT NULL default '',
  `displaygroup` smallint(5) unsigned NOT NULL default '0',
  `usertitle` varchar(250) NOT NULL default '',
  `regdate` bigint(30) NOT NULL default '0',
  `lastactive` bigint(30) NOT NULL default '0',
  `lastvisit` bigint(30) NOT NULL default '0',
  `lastpost` bigint(30) NOT NULL default '0',
  `website` varchar(200) NOT NULL default '',
  `icq` varchar(10) NOT NULL default '',
  `aim` varchar(50) NOT NULL default '',
  `yahoo` varchar(50) NOT NULL default '',
  `msn` varchar(75) NOT NULL default '',
  `birthday` varchar(15) NOT NULL default '',
  `signature` text NOT NULL,
  `allownotices` char(3) NOT NULL default '',
  `hideemail` char(3) NOT NULL default '',
  `emailnotify` char(3) NOT NULL default '',
  `invisible` char(3) NOT NULL default '',
  `receivepms` char(3) NOT NULL default '',
  `pmpopup` char(3) NOT NULL default '',
  `pmnotify` char(3) NOT NULL default '',
  `remember` char(3) NOT NULL default '',
  `threadmode` varchar(8) NOT NULL default '',
  `showsigs` char(3) NOT NULL default '',
  `showavatars` char(3) NOT NULL default '',
  `showquickreply` char(3) NOT NULL default '',
  `showredirect` char(3) NOT NULL default '',
  `ppp` smallint(6) NOT NULL default '0',
  `tpp` smallint(6) NOT NULL default '0',
  `daysprune` smallint(6) NOT NULL default '0',
  `dateformat` varchar(4) NOT NULL default '',
  `timeformat` varchar(4) NOT NULL default '',
  `timezone` varchar(4) NOT NULL default '',
  `dst` varchar(4) NOT NULL default '',
  `buddylist` text NOT NULL,
  `ignorelist` text NOT NULL,
  `style` smallint(5) unsigned NOT NULL default '0',
  `away` char(3) NOT NULL default '',
  `awaydate` int(10) unsigned NOT NULL default '0',
  `returndate` varchar(15) NOT NULL default '',
  `awayreason` varchar(200) NOT NULL default '',
  `pmfolders` text NOT NULL,
  `notepad` text NOT NULL,
  `referrer` int(10) unsigned NOT NULL default '0',
  `reputation` bigint(30) NOT NULL default '0',
  `regip` varchar(50) NOT NULL default '',
  `language` varchar(50) NOT NULL default '',
  `timeonline` bigint(30) NOT NULL default '0',
  `showcodebuttons` int(1) NOT NULL default '1',
  `totalpms` int(10) NOT NULL default '0',
  `newpms` int(10) NOT NULL default '0',
  `unreadpms` int(10) NOT NULL default '0',
  `fws_warnings` varchar(6) NOT NULL default '0',
  `fws_bans` smallint(6) NOT NULL default '0',
  `fws_last_exp_check` varchar(30) NOT NULL default '0',
  PRIMARY KEY  (`uid`),
  KEY `username` (`username`),
  KEY `usergroup` (`usergroup`),
  KEY `birthday` (`birthday`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=90 ;

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

--
-- Tabellenstruktur für Tabelle `mybb_usertitles`
--

CREATE TABLE `mybb_usertitles` (
  `utid` smallint(5) unsigned NOT NULL auto_increment,
  `posts` int(10) unsigned NOT NULL default '0',
  `title` varchar(250) NOT NULL default '',
  `stars` smallint(4) NOT NULL default '0',
  `starimage` varchar(120) NOT NULL default '',
  PRIMARY KEY  (`utid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

[Oldiesmann]

Does MyBB allow guests to vote in polls? Several of those votes are from member ID 0, which is causing the problems - there are multiple votes for the same option from the same member ID.

What exactly is the problem with the attachments?

EDIT: This file should fix the issue with poll votes - it skips over votes where the member ID is 0 (since SMF doesn't let guests vote in polls).

[PsychoWolf]

Yab youre right Oldiesman, MyBB has the Option to let Guests vote in Polls and they are switched on, thats why there are the Zore Numbers.
The Attachment Problem is maybe from having no Attachments now in there, i leave them in, convert and give you the Error Listing.
I try to convert this later today, so i reply to it tonight, thx for your quik help here and hopefully i'm soon a smf user for another of my sites, because on other sites we are using smf without any problems and we love it.


greets PW

[EDIT]
This is the Error i get about the Attachments :

Code Select Expand

This query:

    SELECT pid AS ID_MSG, filedata, downloads, filename, filesize
    FROM `usr_web344_3`.mybb_attachments
    LIMIT 0, 500;

Caused the error:

    Unknown column 'filedata' in 'field list'

Great work Oldiesman, Thank you very mouch, all works fine after i didn't take care of the Attachments because there where non. All Members are there and all Threads are shown now !
I only could say Thank you and now i can use my beloved SMF for another Community too, my Members will thank you also


greets PsychoWolf

[Oldiesmann]

You're welcome. I'll look into the attachments issue and get that fixed so that those who do have attachments don't lose them