hu ?!
nope I have :
CREATE TABLE `zorg_minibb_topics` (
`topic_id` int(10) NOT NULL auto_increment,
`topic_title` varchar(100) NOT NULL default '',
`topic_poster` int(10) NOT NULL default '0',
`topic_poster_name` varchar(40) NOT NULL default 'Anonymous',
`topic_time` datetime NOT NULL default '0000-00-00 00:00:00',
`forum_id` int(10) NOT NULL default '1',
`topic_status` tinyint(1) NOT NULL default '0',
`topic_last_post_id` int(10) NOT NULL default '1',
`posts_count` int(10) NOT NULL default '0',
`sticky` int(1) NOT NULL default '0',
PRIMARY KEY (`topic_id`),
KEY `topic_id` (`topic_id`),
KEY `forum_id` (`forum_id`),
KEY `sticky` (`sticky`),
KEY `topic_last_post_id` (`topic_last_post_id`)
) TYPE=MyISAM AUTO_INCREMENT=219 ;
after an update from 1.7 (I think) to 2.0 (the very first one)... |