вот SQL-запрос для этой таблицы в 8-м нюке. сравните со своей:
Код:
CREATE TABLE nuke_stories (
sid int(11) NOT NULL auto_increment,
catid int(11) DEFAULT '0' NOT NULL,
aid varchar(30) NOT NULL,
title varchar(80),
time datetime,
hometext text,
bodytext text NOT NULL,
comments int(11) DEFAULT '0',
counter mediumint(8) unsigned,
topic int(3) DEFAULT '1' NOT NULL,
informant varchar(20) NOT NULL,
notes text NOT NULL,
ihome int(1) DEFAULT '0' NOT NULL,
alanguage varchar(30) NOT NULL,
acomm int(1) DEFAULT '0' NOT NULL,
haspoll int(1) DEFAULT '0' NOT NULL,
pollID int(10) DEFAULT '0' NOT NULL,
score int(10) DEFAULT '0' NOT NULL,
ratings int(10) DEFAULT '0' NOT NULL,
rating_ip varchar(15) DEFAULT '0',
associated text NOT NULL,
PRIMARY KEY (sid),
KEY sid (sid),
KEY catid (catid),
KEY counter (counter),
KEY topic (topic)
);