MySQL Create Table SQL
Table Structure: okayapi_wp_usermeta：/tablelist/okayapi_wp_usermeta.html
-- MySQL Table okayapi_wp_usermeta
-- From: OkayAPI.com
CREATE TABLE `okayapi_wp_usermeta` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`umeta_id` bigint(20) NULL COMMENT '',
`user_id` bigint(20) NULL DEFAULT '0' COMMENT '',
`meta_key` varchar(255) NULL COMMENT '',
`meta_value` longtext NULL COMMENT '',
KEY `umeta_id` (`umeta_id`),
KEY `user_id` (`user_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 |
|---|---|---|---|---|---|---|
| umeta_id | bigint(20) | 否 | ||||
| user_id | bigint(20) | 0 | 否 | Normal Index | 0 | |
| meta_key | varchar(255) | 是 | Normal Index | |||
| meta_value | longtext | 是 |
