| xengallery_comment | CREATE TABLE `xengallery_comment` (
`comment_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`content_id` int(10) unsigned NOT NULL DEFAULT '0',
`content_type` enum('media','album') NOT NULL DEFAULT 'media',
`message` mediumtext NOT NULL,
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
`username` varchar(50) NOT NULL DEFAULT '',
`ip_id` int(10) unsigned NOT NULL DEFAULT '0',
`comment_date` int(10) unsigned NOT NULL DEFAULT '0',
`comment_state` enum('visible','moderated','deleted') NOT NULL DEFAULT 'visible',
`rating_id` int(10) unsigned NOT NULL DEFAULT '0',
`likes` int(10) unsigned NOT NULL DEFAULT '0',
`like_users` blob,
`warning_id` int(10) unsigned NOT NULL DEFAULT '0',
`warning_message` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`comment_id`)
) ENGINE=InnoDB AUTO_INCREMENT=46205 DEFAULT CHARSET=utf8 |