· 8 years ago · Jul 21, 2018, 11:10 PM
1CREATE TABLE IF NOT EXISTS `topics` (
2 `id` int(11) NOT NULL auto_increment,
3 `author_id` int(11) default NULL,
4 `author_staff` int(1) NOT NULL default '0',
5 `forum_id` int(11) NOT NULL,
6 `created` int(11) NOT NULL,
7 `timestamp` int(11) default NULL,
8 `locked` int(1) NOT NULL default '0',
9 `stickied` int(1) default '0',
10 `title` varchar(255) default NULL,
11 `content` text,
12 `replies` int(11) NOT NULL default '0',
13 `last_poster_id` int(11) default NULL,
14 `last_poster` varchar(255) default NULL,
15 `last_poster_staff` int(1) NOT NULL default '0',
16 `char_data` varchar(255) default NULL,
17 `author_char` varchar(255) default NULL,
18 PRIMARY KEY (`id`)
19) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=57 ;