CREATE TABLE `ibf_1_1_2_topics` (
`tid` int(10) NOT NULL AUTO_INCREMENT,
`title` varchar(70) NOT NULL DEFAULT '',
`description` varchar(70) DEFAULT NULL,
`state` varchar(8) DEFAULT NULL,
`posts` int(10) DEFAULT NULL,
`starter_id` mediumint(8) NOT NULL DEFAULT '0',
`start_date` int(10) DEFAULT NULL,
`last_poster_id` mediumint(8) NOT NULL DEFAULT '0',
`last_post` int(10) NOT NULL DEFAULT '0',
`icon_id` tinyint(2) DEFAULT NULL,
`starter_name` varchar(32) DEFAULT NULL,
`last_poster_name` varchar(32) DEFAULT NULL,
`poll_state` varchar(8) DEFAULT NULL,
`last_vote` int(10) DEFAULT NULL,
`views` int(10) DEFAULT '0',
`forum_id` smallint(5) NOT NULL DEFAULT '0',
`approved` tinyint(1) NOT NULL DEFAULT '0',
`author_mode` tinyint(1) DEFAULT NULL,
`pinned` tinyint(1) NOT NULL DEFAULT '0',
`moved_to` varchar(64) DEFAULT NULL,
`rating` text,
`total_votes` int(5) NOT NULL DEFAULT '0',
PRIMARY KEY (`tid`),
KEY `forum_id` (`forum_id`,`approved`,`pinned`),
KEY `last_post` (`last_post`)
) ENGINE=MyISAM AUTO_INCREMENT=216 DEFAULT CHARSET=latin1;
15
EXAMPLE POST TITLE 1
EXAMPLE POST DESCRIPTION 1
TOPIC_STARTER_NAME
2003-06-01 06:52:28
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut scelerisque sollicitudin mattis. Sed laoreet nisl a magna semper porta. Nulla facilisi. Ut metus erat, fringilla nec semper nec, consequat in nisi.
15
EXAMPLE POST TITLE 1
open
0
1
1054475548
1
1054475548
0
TOPIC_STARTER_NAME
TOPIC_STARTER_NAME
0
0
73
1
1
1
0
NULL
NULL
0
0
1054475635
39
1
TOPIC_STARTER_NAME
1
1
10.0.0.1
1054475548
0
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut scelerisque sollicitudin mattis. Sed laoreet nisl a magna semper porta. Nulla facilisi. Ut metus erat, fringilla nec semper nec, consequat in nisi.
0
15
1
0
NULL
1
TOPIC_STARTER_NAME
16
EXAMPLE POST TITLE 2
EXAMPLE POST DESCRIPTION 2
OTHER_TOPIC_STARTER_NAME
2003-06-17 13:45:43
Praesent in risus eget metus mollis congue. Nullam lacinia lobortis leo, a vulputate mi ullamcorper ac. Fusce lacus massa, ultricies et vulputate ut, placerat dapibus orci. Quisque rutrum elementum venenatis. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam lobortis feugiat augue sed lacinia. Sed ac lorem id nibh congue ullamcorper. Curabitur aliquam sapien et diam blandit nec euismod dolor mattis.
16
EXAMPLE POST TITLE 2
open
0
2
1055882743
2
1055882743
0
OTHER_TOPIC_STARTER_NAME
OTHER_TOPIC_STARTER_NAME
0
0
61
1
1
1
0
NULL
NULL
0
0
NULL
45
2
OTHER_TOPIC_STARTER_NAME
1
1
10.0.0.2
1055882743
0
Praesent in risus eget metus mollis congue. Nullam lacinia lobortis leo, a vulputate mi ullamcorper ac. Fusce lacus massa, ultricies et vulputate ut, placerat dapibus orci. Quisque rutrum elementum venenatis. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam lobortis feugiat augue sed lacinia. Sed ac lorem id nibh congue ullamcorper. Curabitur aliquam sapien et diam blandit nec euismod dolor mattis.
0
16
1
0
NULL
1
NULL