1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
|
--
-- Tabellenstruktur für Tabelle `bb1_threads`
--
CREATE TABLE `bb1_threads` (
`threadid` int(11) unsigned NOT NULL auto_increment,
`boardid` int(11) unsigned NOT NULL default '0',
`prefix` varchar(250) NOT NULL default '',
`topic` varchar(250) NOT NULL default '',
`iconid` int(11) unsigned NOT NULL default '0',
`starttime` int(11) unsigned NOT NULL default '0',
`starterid` int(11) unsigned NOT NULL default '0',
`starter` varchar(50) NOT NULL default '',
`lastposttime` int(11) unsigned NOT NULL default '0',
`lastposterid` int(11) unsigned NOT NULL default '0',
`lastposter` varchar(50) NOT NULL default '',
`replycount` mediumint(7) unsigned NOT NULL default '0',
`views` mediumint(7) unsigned NOT NULL default '0',
`closed` tinyint(1) NOT NULL default '0',
`voted` smallint(5) unsigned NOT NULL default '0',
`votepoints` mediumint(7) unsigned NOT NULL default '0',
`attachments` smallint(5) unsigned NOT NULL default '0',
`pollid` int(11) unsigned NOT NULL default '0',
`important` tinyint(1) NOT NULL default '0',
`visible` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`threadid`),
KEY `iconid` (`iconid`),
KEY `boardid` (`boardid`,`visible`,`important`,`lastposttime`),
KEY `visible` (`visible`,`lastposttime`,`closed`)
) TYPE=MyISAM AUTO_INCREMENT=16 ;
--
-- Daten für Tabelle `bb1_threads`
--
INSERT INTO `bb1_threads` VALUES (11, 6, '', 'Contest', 0, 1170277680, 4, 'LifeForce', 1170277680, 4, 'LifeForce', 0, 7, 0, 0, 0, 0, 0, 0, 1);
INSERT INTO `bb1_threads` VALUES (13, 72, '', 'Ränge', 0, 1170364686, 4, 'LifeForce', 1170364686, 4, 'LifeForce', 0, 3, 1, 0, 0, 0, 0, 1, 1);
INSERT INTO `bb1_threads` VALUES (15, 72, '', '02.02.2006', 0, 1170420591, 4, 'LifeForce', 1170420591, 4, 'LifeForce', 0, 4, 0, 0, 0, 0, 0, 0, 1);
INSERT INTO `bb1_threads` VALUES (7, 43, '', 'Service Wünsche', 0, 1167858592, 4, 'LifeForce', 1167858592, 4, 'LifeForce', 0, 10, 0, 0, 0, 0, 0, 1, 1);
|
