+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_wp_comments:/tablelist/okayapi_wp_comments.html


-- MySQL Table okayapi_wp_comments
-- From: OkayAPI.com
CREATE TABLE `okayapi_wp_comments` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `comment_ID` bigint(20) NOT NULL COMMENT '',
    `comment_post_ID` bigint(20) NOT NULL DEFAULT '0' COMMENT '',
    `comment_author` tinytext NOT NULL COMMENT '',
    `comment_author_email` varchar(100) NOT NULL COMMENT '',
    `comment_author_url` varchar(200) NOT NULL COMMENT '',
    `comment_author_IP` varchar(100) NOT NULL COMMENT '',
    `comment_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '',
    `comment_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '',
    `comment_content` text NOT NULL COMMENT '',
    `comment_karma` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `comment_approved` varchar(20) NOT NULL DEFAULT '1' COMMENT '',
    `comment_agent` varchar(255) NOT NULL COMMENT '',
    `comment_type` varchar(20) NOT NULL COMMENT '',
    `comment_parent` bigint(20) NOT NULL DEFAULT '0' COMMENT '',
    `user_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '',
    KEY `comment_ID` (`comment_ID`),
    KEY `comment_post_ID` (`comment_post_ID`),
    KEY `comment_author` (`comment_author`),
    KEY `comment_author_email` (`comment_author_email`),
    KEY `comment_author_url` (`comment_author_url`),
    KEY `comment_author_IP` (`comment_author_IP`),
    KEY `comment_date` (`comment_date`),
    KEY `comment_date_gmt` (`comment_date_gmt`),
    KEY `comment_content` (`comment_content`),
    KEY `comment_karma` (`comment_karma`),
    KEY `comment_approved` (`comment_approved`),
    KEY `comment_agent` (`comment_agent`),
    KEY `comment_type` (`comment_type`),
    KEY `comment_parent` (`comment_parent`),
    KEY `user_id` (`user_id`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'WordPress-评论';

After replication, you can go to the database to create the database table.


MySQL database table structure design

Displaying 1-15 of 15 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
comment_IDbigint(20)
comment_post_IDbigint(20)0Normal Index0
comment_authortinytext
comment_author_emailvarchar(100)Normal Index
comment_author_urlvarchar(200)
comment_author_IPvarchar(100)
comment_datedatetime0000-00-00 00:00:000000-00-00 00:00:00
comment_date_gmtdatetime0000-00-00 00:00:00Normal Index0000-00-00 00:00:00
comment_contenttext
comment_karmaint(11)00
comment_approvedvarchar(20)1Normal Index1
comment_agentvarchar(255)
comment_typevarchar(20)
comment_parentbigint(20)0Normal Index0
user_idbigint(20)00

Guess You Like

MySQL Table Design okayapi_wp_commentmeta

MySQL Table Design okayapi_wp_links

MySQL Table Design okayapi_wp_options

MySQL Table Design okayapi_wp_postmeta

MySQL Table Design okayapi_wp_posts

MySQL Table Design okayapi_wp_term_relationships

MySQL Table Design okayapi_wp_term_taxonomy

MySQL Table Design okayapi_wp_termmeta

MySQL Table Design okayapi_wp_terms

MySQL Table Design okayapi_wp_usermeta

MySQL Table Design okayapi_wp_users

TOP ↑