MySQL Create Table SQL
Table Structure: okayapi_jieqi_system_users:/tablelist/okayapi_jieqi_system_users.html
-- MySQL Table okayapi_jieqi_system_users
-- From: OkayAPI.com
CREATE TABLE `okayapi_jieqi_system_users` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`siteid` smallint(6) NOT NULL DEFAULT '0' COMMENT '',
`uname` varchar(30) NOT NULL COMMENT '',
`okayapi_jieqi_system_users_name` varchar(60) NOT NULL COMMENT '',
`pass` varchar(32) NOT NULL COMMENT '',
`groupid` tinyint(3) NOT NULL DEFAULT '0' COMMENT '',
`regdate` int(11) NOT NULL DEFAULT '0' COMMENT '',
`initial` char(1) NOT NULL COMMENT '',
`sex` tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
`email` varchar(60) NOT NULL COMMENT '',
`url` varchar(100) NOT NULL COMMENT '',
`avatar` int(11) NOT NULL DEFAULT '0' COMMENT '',
`workid` tinyint(3) NOT NULL DEFAULT '0' COMMENT '',
`qq` varchar(15) NOT NULL COMMENT '',
`icq` varchar(15) NOT NULL COMMENT '',
`msn` varchar(60) NOT NULL COMMENT '',
`mobile` varchar(20) NOT NULL COMMENT '',
`sign` text NOT NULL COMMENT '',
`intro` text NOT NULL COMMENT '',
`setting` text NOT NULL COMMENT '',
`badges` text NOT NULL COMMENT '',
`lastlogin` int(10) NOT NULL DEFAULT '0' COMMENT '',
`showsign` tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
`viewemail` tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
`notifymode` tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
`adminemail` tinyint(1) NOT NULL DEFAULT '1' COMMENT '',
`monthscore` int(11) NOT NULL DEFAULT '0' COMMENT '',
`weekscore` int(11) NOT NULL DEFAULT '0' COMMENT '',
`dayscore` int(11) NOT NULL DEFAULT '0' COMMENT '',
`lastscore` int(11) NOT NULL DEFAULT '0' COMMENT '',
`experience` int(11) NOT NULL DEFAULT '0' COMMENT '',
`score` int(11) NOT NULL DEFAULT '0' COMMENT '',
`egold` int(11) NOT NULL DEFAULT '0' COMMENT '',
`esilver` int(11) NOT NULL DEFAULT '0' COMMENT '',
`credit` int(11) NOT NULL DEFAULT '0' COMMENT '',
`goodnum` int(11) NOT NULL DEFAULT '0' COMMENT '',
`badnum` int(11) NOT NULL DEFAULT '0' COMMENT '',
`isvip` tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
`overtime` int(11) NOT NULL DEFAULT '0' COMMENT '',
`state` tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
KEY `siteid` (`siteid`),
KEY `uname` (`uname`),
KEY `okayapi_jieqi_system_users_name` (`okayapi_jieqi_system_users_name`),
KEY `pass` (`pass`),
KEY `groupid` (`groupid`),
KEY `regdate` (`regdate`),
KEY `initial` (`initial`),
KEY `sex` (`sex`),
KEY `email` (`email`),
KEY `url` (`url`),
KEY `avatar` (`avatar`),
KEY `workid` (`workid`),
KEY `qq` (`qq`),
KEY `icq` (`icq`),
KEY `msn` (`msn`),
KEY `mobile` (`mobile`),
KEY `sign` (`sign`),
KEY `intro` (`intro`),
KEY `setting` (`setting`),
KEY `badges` (`badges`),
KEY `lastlogin` (`lastlogin`),
KEY `showsign` (`showsign`),
KEY `viewemail` (`viewemail`),
KEY `notifymode` (`notifymode`),
KEY `adminemail` (`adminemail`),
KEY `monthscore` (`monthscore`),
KEY `weekscore` (`weekscore`),
KEY `dayscore` (`dayscore`),
KEY `lastscore` (`lastscore`),
KEY `experience` (`experience`),
KEY `score` (`score`),
KEY `egold` (`egold`),
KEY `esilver` (`esilver`),
KEY `credit` (`credit`),
KEY `goodnum` (`goodnum`),
KEY `badnum` (`badnum`),
KEY `isvip` (`isvip`),
KEY `overtime` (`overtime`),
KEY `state` (`state`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'jieqi小说-用户';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-39 of 39 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
siteid | smallint(6) | 0 | 否 | 0 | ||
uname | varchar(30) | 否 | ||||
okayapi_jieqi_system_users_name | varchar(60) | 否 | ||||
pass | varchar(32) | 否 | ||||
groupid | tinyint(3) | 0 | 否 | Normal Index | 0 | |
regdate | int(11) | 0 | 否 | 0 | ||
initial | char(1) | 否 | ||||
sex | tinyint(1) | 0 | 否 | 0 | ||
varchar(60) | 否 | Unique Index | ||||
url | varchar(100) | 否 | ||||
avatar | int(11) | 0 | 否 | 0 | ||
workid | tinyint(3) | 0 | 否 | 0 | ||
varchar(15) | 否 | |||||
icq | varchar(15) | 否 | ||||
msn | varchar(60) | 否 | ||||
mobile | varchar(20) | 否 | ||||
sign | text | 否 | ||||
intro | text | 否 | ||||
setting | text | 否 | ||||
badges | text | 否 | ||||
lastlogin | int(10) | 0 | 否 | 0 | ||
showsign | tinyint(1) | 0 | 否 | 0 | ||
viewemail | tinyint(1) | 0 | 否 | 0 | ||
notifymode | tinyint(1) | 0 | 否 | 0 | ||
adminemail | tinyint(1) | 1 | 否 | 1 | ||
monthscore | int(11) | 0 | 否 | 0 | ||
weekscore | int(11) | 0 | 否 | 0 | ||
dayscore | int(11) | 0 | 否 | 0 | ||
lastscore | int(11) | 0 | 否 | 0 | ||
experience | int(11) | 0 | 否 | 0 | ||
score | int(11) | 0 | 否 | 0 | ||
egold | int(11) | 0 | 否 | 0 | ||
esilver | int(11) | 0 | 否 | 0 | ||
credit | int(11) | 0 | 否 | 0 | ||
goodnum | int(11) | 0 | 否 | 0 | ||
badnum | int(11) | 0 | 否 | 0 | ||
isvip | tinyint(1) | 0 | 否 | 0 | ||
overtime | int(11) | 0 | 否 | 0 | ||
state | tinyint(1) | 0 | 否 | Normal Index | 0 |