MySQL Create Table SQL
Table Structure: okayapi_wp_postmeta:/tablelist/okayapi_wp_postmeta.html
-- MySQL Table okayapi_wp_postmeta
-- From: OkayAPI.com
CREATE TABLE `okayapi_wp_postmeta` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`meta_id` bigint(20) NULL COMMENT '',
`post_id` bigint(20) NULL DEFAULT '0' COMMENT '',
`meta_key` varchar(255) NULL COMMENT '',
`meta_value` longtext NULL COMMENT '',
KEY `meta_id` (`meta_id`),
KEY `post_id` (`post_id`),
KEY `meta_key` (`meta_key`),
KEY `meta_value` (`meta_value`),
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-4 of 4 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
meta_id | bigint(20) | 否 | ||||
post_id | bigint(20) | 0 | 否 | Normal Index | 0 | |
meta_key | varchar(255) | 是 | Normal Index | |||
meta_value | longtext | 是 |