MySQL Create Table SQL
Table Structure: okayapi_zheng_upms_user:/tablelist/okayapi_zheng_upms_user.html
-- MySQL Table okayapi_zheng_upms_user
-- From: OkayAPI.com
CREATE TABLE `okayapi_zheng_upms_user` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(20) NULL COMMENT '帐号',
`okayapi_zheng_upms_user_password` varchar(32) NULL COMMENT '密码MD5(密码+盐)',
`salt` varchar(32) NULL COMMENT '盐',
`realname` varchar(20) NULL COMMENT '姓名',
`avatar` varchar(150) NULL COMMENT '头像',
`phone` varchar(20) NULL COMMENT '电话',
`email` varchar(50) NULL COMMENT '邮箱',
`sex` tinyint(4) NULL COMMENT '性别',
`locked` tinyint(4) NULL COMMENT '状态(0:正常,1:锁定)',
`ctime` bigint(20) NULL COMMENT '创建时间',
KEY `username` (`username`),
KEY `okayapi_zheng_upms_user_password` (`okayapi_zheng_upms_user_password`),
KEY `salt` (`salt`),
KEY `realname` (`realname`),
KEY `avatar` (`avatar`),
KEY `phone` (`phone`),
KEY `email` (`email`),
KEY `sex` (`sex`),
KEY `locked` (`locked`),
KEY `ctime` (`ctime`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'zheng敏捷开发-用户';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-10 of 10 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
username | varchar(20) | 否 | 帐号 | |||
okayapi_zheng_upms_user_password | varchar(32) | 否 | 密码MD5(密码+盐) | |||
salt | varchar(32) | 是 | 盐 | |||
realname | varchar(20) | 是 | 姓名 | |||
avatar | varchar(150) | 是 | 头像 | |||
phone | varchar(20) | 是 | 电话 | |||
varchar(50) | 是 | 邮箱 | ||||
sex | tinyint(4) | 是 | 性别 | |||
locked | tinyint(4) | 是 | 状态(0:正常,1:锁定) | |||
ctime | bigint(20) | 是 | 创建时间 |