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 Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
ID | bigint(20) | 否 | ||||
post_author | bigint(20) | 0 | 否 | Normal Index | 0 | |
post_date | datetime | 0000-00-00 00:00:00 | 否 | 0000-00-00 00:00:00 | ||
post_date_gmt | datetime | 0000-00-00 00:00:00 | 否 | 0000-00-00 00:00:00 | ||
post_content | longtext | 否 | ||||
post_title | text | 否 | ||||
post_excerpt | text | 否 | ||||
post_status | varchar(20) | publish | 否 | publish | ||
comment_status | varchar(20) | open | 否 | open | ||
ping_status | varchar(20) | open | 否 | open | ||
post_password | varchar(255) | 否 | ||||
post_name | varchar(200) | 否 | Normal Index | |||
to_ping | text | 否 | ||||
pinged | text | 否 | ||||
post_modified | datetime | 0000-00-00 00:00:00 | 否 | 0000-00-00 00:00:00 | ||
post_modified_gmt | datetime | 0000-00-00 00:00:00 | 否 | 0000-00-00 00:00:00 | ||
post_content_filtered | longtext | 否 | ||||
post_parent | bigint(20) | 0 | 否 | Normal Index | 0 | |
guid | varchar(255) | 否 | ||||
menu_order | int(11) | 0 | 否 | 0 | ||
post_type | varchar(20) | post | 否 | Normal Index | post | |
post_mime_type | varchar(100) | 否 | ||||
comment_count | bigint(20) | 0 | 否 | 0 |