CREATE TABLE `mt_comment` (
`comment_id` INT(11) NOT NULL AUTO_INCREMENT,
`comment_author` VARCHAR(100) NULL DEFAULT NULL,
`comment_blog_id` INT(11) NOT NULL,
`comment_commenter_id` INT(11) NULL DEFAULT NULL,
`comment_created_by` INT(11) NULL DEFAULT NULL,
`comment_created_on` DATETIME NULL DEFAULT NULL,
`comment_email` VARCHAR(127) NULL DEFAULT NULL,
`comment_entry_id` INT(11) NOT NULL,
`comment_ip` VARCHAR(50) NULL DEFAULT NULL,
`comment_junk_log` MEDIUMTEXT NULL,
`comment_junk_score` FLOAT NULL DEFAULT NULL,
`comment_junk_status` SMALLINT(6) NULL DEFAULT '1',
`comment_last_moved_on` DATETIME NOT NULL DEFAULT '2000-01-01 00:00:00',
`comment_modified_by` INT(11) NULL DEFAULT NULL,
`comment_modified_on` DATETIME NULL DEFAULT NULL,
`comment_parent_id` INT(11) NULL DEFAULT NULL,
`comment_text` MEDIUMTEXT NULL,
`comment_url` VARCHAR(255) NULL DEFAULT NULL,
`comment_visible` TINYINT(4) NULL DEFAULT NULL,
PRIMARY KEY (`comment_id`),
INDEX `mt_comment_blog_stat` (`comment_blog_id`, `comment_junk_status`, `comment_created_on`),
INDEX `mt_comment_commenter_id` (`comment_commenter_id`),
INDEX `mt_comment_dd_coment_vis_mod` (`comment_visible`, `comment_modified_on`),
INDEX `mt_comment_visible_date` (`comment_visible`, `comment_created_on`),
INDEX `mt_comment_author` (`comment_author`),
INDEX `mt_comment_entry_visible` (`comment_entry_id`, `comment_visible`, `comment_created_on`),
INDEX `mt_comment_email` (`comment_email`),
INDEX `mt_comment_last_moved_on` (`comment_last_moved_on`),
INDEX `mt_comment_blog_visible` (`comment_blog_id`, `comment_visible`, `comment_created_on`, `comment_id`),
INDEX `mt_comment_blog_ip_date` (`comment_blog_id`, `comment_ip`, `comment_created_on`),
INDEX `mt_comment_blog_url` (`comment_blog_id`, `comment_visible`, `comment_url`)
)
