## 后台管理员表
<table width="100%" border="0">
<tbody>
<tr>
<th width="10%">
字段</th>
<th width="20%">
类型</th>
<th width="5%">
Null</th>
<th width="5%">
默认</th>
<th width="5%">
额外</th>
<th width="40%">
注释</th>
</tr>
<tr>
<td>
userid</td>
<td>
mediumint(6) unsigned</td>
<td>
<b>PK</b></td>
<td>
</td>
<td>
auto_increment</td>
<td>
用户id</td>
</tr>
<tr>
<td>
username</td>
<td>
varchar(20)</td>
<td>
YES</td>
<td>
</td>
<td>
</td>
<td>
用户名</td>
</tr>
<tr>
<td>
password</td>
<td>
varchar(32)</td>
<td>
YES</td>
<td>
</td>
<td>
</td>
<td>
密码</td>
</tr>
<tr>
<td>
roleid</td>
<td>
smallint(5)</td>
<td>
YES</td>
<td>
0</td>
<td>
</td>
<td>
角色</td>
</tr>
<tr>
<td>
encrypt</td>
<td>
varchar(6)</td>
<td>
YES</td>
<td>
</td>
<td>
</td>
<td>
加密因子</td>
</tr>
<tr>
<td>
lastloginip</td>
<td>
varchar(15)</td>
<td>
YES</td>
<td>
</td>
<td>
</td>
<td>
最后登录ip</td>
</tr>
<tr>
<td>
lastlogintime</td>
<td>
int(10) unsigned</td>
<td>
YES</td>
<td>
0</td>
<td>
</td>
<td>
最后登录时间</td>
</tr>
<tr>
<td>
email</td>
<td>
varchar(40)</td>
<td>
YES</td>
<td>
</td>
<td>
</td>
<td>
Email</td>
</tr>
<tr>
<td>
realname</td>
<td>
varchar(50)</td>
<td>
NO</td>
<td>
</td>
<td>
</td>
<td>
真是姓名</td>
</tr>
<tr>
<td>
card</td>
<td>
varchar(255)</td>
<td>
NO</td>
<td>
</td>
<td>
</td>
<td>
密保卡</td>
</tr>
<tr>
<td>siteid</td>
<td>SMALLINT(5)</td>
<td>NO</td>
<td>1</td>
<td> </td>
<td>站点ID</td>
</tr>
</tbody>
</table>
<table width="60%" border="0">
<tbody>
<tr>
<th>
键名</th>
<th>
类型</th>
<th>
字段</th>
</tr>
<tr>
<td>
PRIMARY</td>
<td>
PRIMARY</td>
<td>
userid</td>
</tr>
<tr>
<td>
username</td>
<td>
INDEX</td>
<td>
username</td>
</tr>
</tbody>
</table>
