+ Use This Table All Design

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 NameField TypeDefaultIS NULLField CommentIndexDemo Data
user_loginvarchar(60)Normal Index
user_passvarchar(255)
user_nicenamevarchar(50)Normal Index
user_emailvarchar(100)Normal Index
user_urlvarchar(100)
user_registereddatetime1970-01-01 00:00:001970-01-01 00:00:00
user_activation_keyvarchar(255)
user_statusint(11)00
display_namevarchar(250)

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

TOP ↑