MySQL Create Table SQL
Table Structure: okayapi_wp_users:/tablelist/okayapi_wp_users.html
-- MySQL Table okayapi_wp_users
-- From: OkayAPI.com
CREATE TABLE `okayapi_wp_users` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_login` varchar(60) NOT NULL COMMENT '',
`user_pass` varchar(255) NOT NULL COMMENT '',
`user_nicename` varchar(50) NOT NULL COMMENT '',
`user_email` varchar(100) NOT NULL COMMENT '',
`user_url` varchar(100) NOT NULL COMMENT '',
`user_registered` datetime NOT NULL DEFAULT '1970-01-01 00:00:00' COMMENT '',
`user_activation_key` varchar(255) NOT NULL COMMENT '',
`user_status` int(11) NOT NULL DEFAULT '0' COMMENT '',
`display_name` varchar(250) NOT NULL COMMENT '',
KEY `user_login` (`user_login`),
KEY `user_pass` (`user_pass`),
KEY `user_nicename` (`user_nicename`),
KEY `user_email` (`user_email`),
KEY `user_url` (`user_url`),
KEY `user_registered` (`user_registered`),
KEY `user_activation_key` (`user_activation_key`),
KEY `user_status` (`user_status`),
KEY `display_name` (`display_name`),
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-9 of 9 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
user_login | varchar(60) | 否 | Normal Index | |||
user_pass | varchar(255) | 否 | ||||
user_nicename | varchar(50) | 否 | Normal Index | |||
user_email | varchar(100) | 否 | Normal Index | |||
user_url | varchar(100) | 否 | ||||
user_registered | datetime | 1970-01-01 00:00:00 | 否 | 1970-01-01 00:00:00 | ||
user_activation_key | varchar(255) | 否 | ||||
user_status | int(11) | 0 | 否 | 0 | ||
display_name | varchar(250) | 否 |