вопрос
--
-- Структура таблицы `dle_comments`
--
CREATE TABLE IF NOT EXISTS `dle_comments` (
`id` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
`post_id` INT( 11 ) NOT NULL DEFAULT '0',
`user_id` INT( 11 ) NOT NULL DEFAULT '0',
`date` DATETIME NOT NULL DEFAULT '2000-01-01 00:00:00',
`autor` VARCHAR( 40 ) NOT NULL DEFAULT '',
`email` VARCHAR( 40 ) NOT NULL DEFAULT '',
`text` TEXT NOT NULL ,
`ip` VARCHAR( 40 ) NOT NULL DEFAULT '',
`is_register` TINYINT( 1 ) NOT NULL DEFAULT '0',
`approve` TINYINT( 1 ) NOT NULL DEFAULT '1',
`rating` INT( 11 ) NOT NULL DEFAULT '0',
`vote_num` INT( 11 ) NOT NULL DEFAULT '0',
`parent` INT( 11 ) NOT NULL DEFAULT '0',
PRIMARY KEY ( `id` ) ,
KEY `user_id` ( `user_id` ) ,
KEY `post_id` ( `post_id` ) ,
KEY `approve` ( `approve` ) ,
KEY `parent` ( `parent` ) ,
KEY `rating` ( `rating` ) ,
FULLTEXT KEY `text` ( `text` )
) ENGINE = INNODB DEFAULT CHARSET = utf8 AUTO_INCREMENT =25;