## 后臺管理員表
<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>
