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 Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
option_id | bigint(20) | 否 | ||||
option_name | varchar(191) | 否 | Unique Index | |||
option_value | longtext | 否 | ||||
autoload | varchar(20) | yes | 否 | Normal Index | yes |