MySQL Create Table SQL
Table Structure: okayapi_user：/tablelist/okayapi_user.html
-- MySQL Table okayapi_user
-- From: OkayAPI.com
CREATE TABLE `okayapi_user` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_account` varchar(50) NULL COMMENT '用户账号',
`user_passwd` varchar(50) NULL COMMENT '用户密码',
`user_name` varchar(50) NULL COMMENT '用户昵称',
`user_desc` varchar(255) NULL COMMENT '用户描述',
KEY `user_account` (`user_account`),
KEY `user_passwd` (`user_passwd`),
KEY `user_name` (`user_name`),
KEY `user_desc` (`user_desc`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '用户';
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 |
|---|---|---|---|---|---|---|
| user_account | varchar(50) | 是 | 用户账号 | |||
| user_passwd | varchar(50) | 是 | 用户密码 | |||
| user_name | varchar(50) | 是 | 用户昵称 | |||
| user_desc | varchar(255) | 是 | 用户描述 |
