Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE `wp_comments` (
- `comment_ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
- `comment_post_ID` bigint(20) unsigned NOT NULL DEFAULT '0',
- `comment_author` tinytext NOT NULL,
- `comment_author_email` varchar(100) NOT NULL DEFAULT '',
- `comment_author_url` varchar(200) NOT NULL DEFAULT '',
- `comment_author_IP` varchar(100) NOT NULL DEFAULT '',
- `comment_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `comment_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `comment_content` text NOT NULL,
- `comment_karma` int(11) NOT NULL DEFAULT '0',
- `comment_approved` varchar(20) NOT NULL DEFAULT '1',
- `comment_agent` varchar(255) NOT NULL DEFAULT '',
- `comment_type` varchar(20) NOT NULL DEFAULT '',
- `comment_parent` bigint(20) unsigned NOT NULL DEFAULT '0',
- `user_id` bigint(20) unsigned NOT NULL DEFAULT '0',
- `comment_subscribe` enum('Y','C','N') NOT NULL DEFAULT 'N',
- PRIMARY KEY (`comment_ID`),
- KEY `comment_approved` (`comment_approved`),
- KEY `comment_post_ID` (`comment_post_ID`),
- KEY `comment_date_gmt` (`comment_date_gmt`),
- KEY `comment_approved_date_gmt` (`comment_approved`,`comment_date_gmt`),
- KEY `comment_parent` (`comment_parent`),
- KEY `idx_comment_author_email` (`comment_author_email`(20))
- ) ENGINE=InnoDB AUTO_INCREMENT=127791 DEFAULT CHARSET=utf8
Add Comment
Please, Sign In to add comment