+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_wp_posts:/tablelist/okayapi_wp_posts.html


-- MySQL Table okayapi_wp_posts
-- From: OkayAPI.com
CREATE TABLE `okayapi_wp_posts` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `ID` bigint(20) NOT NULL COMMENT '',
    `post_author` bigint(20) NOT NULL DEFAULT '0' COMMENT '',
    `post_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '',
    `post_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '',
    `post_content` longtext NOT NULL COMMENT '',
    `post_title` text NOT NULL COMMENT '',
    `post_excerpt` text NOT NULL COMMENT '',
    `post_status` varchar(20) NOT NULL DEFAULT 'publish' COMMENT '',
    `comment_status` varchar(20) NOT NULL DEFAULT 'open' COMMENT '',
    `ping_status` varchar(20) NOT NULL DEFAULT 'open' COMMENT '',
    `post_password` varchar(255) NOT NULL COMMENT '',
    `post_name` varchar(200) NOT NULL COMMENT '',
    `to_ping` text NOT NULL COMMENT '',
    `pinged` text NOT NULL COMMENT '',
    `post_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '',
    `post_modified_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '',
    `post_content_filtered` longtext NOT NULL COMMENT '',
    `post_parent` bigint(20) NOT NULL DEFAULT '0' COMMENT '',
    `guid` varchar(255) NOT NULL COMMENT '',
    `menu_order` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `post_type` varchar(20) NOT NULL DEFAULT 'post' COMMENT '',
    `post_mime_type` varchar(100) NOT NULL COMMENT '',
    `comment_count` bigint(20) NOT NULL DEFAULT '0' COMMENT '',
    KEY `ID` (`ID`),
    KEY `post_author` (`post_author`),
    KEY `post_date` (`post_date`),
    KEY `post_date_gmt` (`post_date_gmt`),
    KEY `post_content` (`post_content`),
    KEY `post_title` (`post_title`),
    KEY `post_excerpt` (`post_excerpt`),
    KEY `post_status` (`post_status`),
    KEY `comment_status` (`comment_status`),
    KEY `ping_status` (`ping_status`),
    KEY `post_password` (`post_password`),
    KEY `post_name` (`post_name`),
    KEY `to_ping` (`to_ping`),
    KEY `pinged` (`pinged`),
    KEY `post_modified` (`post_modified`),
    KEY `post_modified_gmt` (`post_modified_gmt`),
    KEY `post_content_filtered` (`post_content_filtered`),
    KEY `post_parent` (`post_parent`),
    KEY `guid` (`guid`),
    KEY `menu_order` (`menu_order`),
    KEY `post_type` (`post_type`),
    KEY `post_mime_type` (`post_mime_type`),
    KEY `comment_count` (`comment_count`),
    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-23 of 23 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
IDbigint(20)
post_authorbigint(20)0Normal Index0
post_datedatetime0000-00-00 00:00:000000-00-00 00:00:00
post_date_gmtdatetime0000-00-00 00:00:000000-00-00 00:00:00
post_contentlongtext
post_titletext
post_excerpttext
post_statusvarchar(20)publishpublish
comment_statusvarchar(20)openopen
ping_statusvarchar(20)openopen
post_passwordvarchar(255)
post_namevarchar(200)Normal Index
to_pingtext
pingedtext
post_modifieddatetime0000-00-00 00:00:000000-00-00 00:00:00
post_modified_gmtdatetime0000-00-00 00:00:000000-00-00 00:00:00
post_content_filteredlongtext
post_parentbigint(20)0Normal Index0
guidvarchar(255)
menu_orderint(11)00
post_typevarchar(20)postNormal Indexpost
post_mime_typevarchar(100)
comment_countbigint(20)00

Guess You Like

MySQL Table Design okayapi_wp_commentmeta

MySQL Table Design okayapi_wp_comments

MySQL Table Design okayapi_wp_links

MySQL Table Design okayapi_wp_options

MySQL Table Design okayapi_wp_postmeta

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 ↑