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)... |