+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_wp_options:/tablelist/okayapi_wp_options.html


-- MySQL Table okayapi_wp_options
-- From: OkayAPI.com
CREATE TABLE `okayapi_wp_options` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `option_id` bigint(20) NOT NULL COMMENT '',
    `option_name` varchar(191) NOT NULL COMMENT '',
    `option_value` longtext NOT NULL COMMENT '',
    `autoload` varchar(20) NOT NULL DEFAULT 'yes' COMMENT '',
    KEY `option_id` (`option_id`),
    KEY `option_name` (`option_name`),
    KEY `option_value` (`option_value`),
    KEY `autoload` (`autoload`),
    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
option_idbigint(20)
option_namevarchar(191)Unique Index
option_valuelongtext
autoloadvarchar(20)yesNormal Indexyes

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