表单安装 安装后可存放1000万+条数据
表字段预览 除系统字段外，okayapi_jieqi_system_users数据库表 共有 39 个表字段
Displaying 1-39 of 39 results.
| 字段名称 | 字段类型 | 字段默认值 | 是否允许为空 | 字段描述 | 索引 | 字段数据示例 |
|---|---|---|---|---|---|---|
| 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 |
