MySQL Create Table SQL
Table Structure: okayapi_landi_user：/tablelist/okayapi_landi_user.html
-- MySQL Table okayapi_landi_user
-- From: OkayAPI.com
CREATE TABLE `okayapi_landi_user` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(64) NULL COMMENT '',
`passwd` varchar(64) NULL COMMENT '',
`okayapi_landi_user_name` varchar(64) NULL COMMENT '',
`num` varchar(64) NULL COMMENT '',
`depart` varchar(64) NULL COMMENT '',
`role` int(10) NULL DEFAULT '0' COMMENT '',
`auth` int(10) NULL DEFAULT '0' COMMENT '',
`ctime` date NULL COMMENT '',
`ltime` date NULL COMMENT '',
`state` int(10) NULL DEFAULT '1' COMMENT '',
`reset_passwd` tinyint(3) NULL DEFAULT '0' COMMENT '是否修改过密码（初始为0）',
KEY `username` (`username`),
KEY `passwd` (`passwd`),
KEY `okayapi_landi_user_name` (`okayapi_landi_user_name`),
KEY `num` (`num`),
KEY `depart` (`depart`),
KEY `role` (`role`),
KEY `auth` (`auth`),
KEY `ctime` (`ctime`),
KEY `ltime` (`ltime`),
KEY `state` (`state`),
KEY `reset_passwd` (`reset_passwd`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'LD酒店租房管理-会员';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-11 of 11 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| username | varchar(64) | 否 | Unique Index | |||
| passwd | varchar(64) | 否 | ||||
| okayapi_landi_user_name | varchar(64) | 否 | ||||
| num | varchar(64) | 是 | ||||
| depart | varchar(64) | 是 | ||||
| role | int(10) | 0 | 否 | 0 | ||
| auth | int(10) | 0 | 否 | 0 | ||
| ctime | date | 是 | ||||
| ltime | date | 是 | ||||
| state | int(10) | 1 | 否 | 1 | ||
| reset_passwd | tinyint(3) | 0 | 是 | 是否修改过密码（初始为0） | 0 |
