+ Use This Table All Design

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 NameField TypeDefaultIS NULLField CommentIndexDemo Data
meta_idbigint(20)
post_idbigint(20)0Normal Index0
meta_keyvarchar(255)Normal Index
meta_valuelongtext

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_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 ↑