<style type="text/css">
.toptext {font-family: verdana; color: #000000; font-size: 20px; font-weight: 600; width:550; background-color:#999999; }
.normal { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px; font-weight: normal; color: #000000}
.fieldheader {font-family: verdana; color: #000000; font-size: 12px; font-weight: 600; width:550; background-color:#c0c0c0; }
.fieldcolumn {font-family: verdana; color: #000000; font-size: 10px; font-weight: 600; width:550; background-color:#ffffff; }
.header {background-color: #ECE9D8;}
.headtext {font-family: verdana; color: #000000; font-size: 12; font-weight: 600; width:550; background-color:#999999; }
BR.page {page-break-after: always}
</style>
<table width="100%" border="0" cellspacing="0" cellpadding="5">
<tr>
<td class="toptext"><p align="center">ucenter</td>
</tr>
</table>
<a name="header"> </a>
<ul>
<li><a href="#server_id_seq"><p class="normal">server_id_seq</a></li>
<li><a href="#ucenter_base_app"><p class="normal">ucenter_base_app</a></li>
<li><a href="#ucenter_base_app_server"><p class="normal">ucenter_base_app_server</a></li>
<li><a href="#ucenter_base_district"><p class="normal">ucenter_base_district</a></li>
<li><a href="#ucenter_message_template"><p class="normal">ucenter_message_template</a></li>
<li><a href="#ucenter_reg_option"><p class="normal">ucenter_reg_option</a></li>
<li><a href="#ucenter_reg_option_value"><p class="normal">ucenter_reg_option_value</a></li>
<li><a href="#ucenter_server_id_seq"><p class="normal">ucenter_server_id_seq</a></li>
<li><a href="#ucenter_user_app"><p class="normal">ucenter_user_app</a></li>
<li><a href="#ucenter_user_app_server"><p class="normal">ucenter_user_app_server</a></li>
<li><a href="#ucenter_user_bind_connect"><p class="normal">ucenter_user_bind_connect</a></li>
<li><a href="#ucenter_user_grade"><p class="normal">ucenter_user_grade</a></li>
<li><a href="#ucenter_user_id_seq"><p class="normal">ucenter_user_id_seq</a></li>
<li><a href="#ucenter_user_info"><p class="normal">ucenter_user_info</a></li>
<li><a href="#ucenter_user_info_detail"><p class="normal">ucenter_user_info_detail</a></li>
<li><a href="#ucenter_user_option"><p class="normal">ucenter_user_option</a></li>
<li><a href="#ucenter_user_privacy"><p class="normal">ucenter_user_privacy</a></li>
<li><a href="#ucenter_web_config"><p class="normal">ucenter_web_config</a></li>
<li><a href="#user_id_seq"><p class="normal">user_id_seq</a></li>
</ul>
<hr>
<!-- 我就不寫HTML代碼了！直接MarkDown走起~ -->
<br class=page>
<p><a name='server_id_seq'> </a>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="headtext" width="30%" align="left" valign="top">server_id_seq</td>
<td> </td>
<tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="fieldheader" width="100%" align="left" valign="top">Fields</td>
</tr>
</table>
<table width="100%" cellspacing="0" cellapdding="2" border="1">
<tr>
<td align="center" valign="top" class="fieldcolumn">Field</td>
<td align="center" valign="top" class="fieldcolumn">Type</td>
<td align="center" valign="top" class="fieldcolumn">Collation</td>
<td align="center" valign="top" class="fieldcolumn">Null</td>
<td align="center" valign="top" class="fieldcolumn">Key</td>
<td align="center" valign="top" class="fieldcolumn">Default</td>
<td align="center" valign="top" class="fieldcolumn">Extra</td>
<td align="center" valign="top" class="fieldcolumn">Privileges</td>
<td align="center" valign="top" class="fieldcolumn">Comment</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal"></td>
<td align="left" valign="top"><p class="normal">int(10) unsigned</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal">PRI</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">auto_increment</td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">說明：</td>
<td align="left" valign="top" colspan="8"><p class="normal">rrrrrrr</td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="fieldheader" width="100%" align="left" valign="top">Indexes</td>
</tr>
</table>
<table width="100%" cellspacing="0" cellapdding="2" border="1">
<tr>
<td align="left" valign="top" class="fieldcolumn">Table</td>
<td align="left" valign="top" class="fieldcolumn">Non<br>unique</td>
<td align="left" valign="top" class="fieldcolumn">Key<br>name</td>
<td align="left" valign="top" class="fieldcolumn">Seq<br>in<br>index</td>
<td align="left" valign="top" class="fieldcolumn">Column<br>name</td>
<td align="left" valign="top" class="fieldcolumn">Collation</td>
<td align="left" valign="top" class="fieldcolumn">Cardinality</td>
<td align="left" valign="top" class="fieldcolumn">Sub<br>part</td>
<td align="left" valign="top" class="fieldcolumn">Packed</td>
<td align="left" valign="top" class="fieldcolumn">Null</td>
<td align="left" valign="top" class="fieldcolumn">Index<br>type</td>
<td align="left" valign="top" class="fieldcolumn">Comment</td>
<td align="left" valign="top" class="fieldcolumn">Index<br>comment</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">server_id_seq</td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal">PRIMARY</td>
<td align="left" valign="top"><p class="normal">1</td>
<td align="left" valign="top"><p class="normal">id</td>
<td align="left" valign="top"><p class="normal">A</td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">BTREE</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
</table>
<a href="#header"><p class="normal">Back</a><br class=page>
<p><a name='ucenter_base_app'> </a>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="headtext" width="30%" align="left" valign="top">ucenter_base_app</td>
<td> </td>
<tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="fieldheader" width="100%" align="left" valign="top">Fields</td>
</tr>
</table>
<table width="100%" cellspacing="0" cellapdding="2" border="1">
<tr>
<td align="center" valign="top" class="fieldcolumn">Field</td>
<td align="center" valign="top" class="fieldcolumn">Type</td>
<td align="center" valign="top" class="fieldcolumn">Collation</td>
<td align="center" valign="top" class="fieldcolumn">Null</td>
<td align="center" valign="top" class="fieldcolumn">Key</td>
<td align="center" valign="top" class="fieldcolumn">Default</td>
<td align="center" valign="top" class="fieldcolumn">Extra</td>
<td align="center" valign="top" class="fieldcolumn">Privileges</td>
<td align="center" valign="top" class="fieldcolumn">Comment</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">app_id</td>
<td align="left" valign="top"><p class="normal">int(11) unsigned</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal">PRI</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">auto_increment</td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">服務ID</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">app_name</td>
<td align="left" valign="top"><p class="normal">varchar(40)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">YES</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">服務名稱</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">app_type</td>
<td align="left" valign="top"><p class="normal">smallint(5) unsigned</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">服務類型</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">app_seq</td>
<td align="left" valign="top"><p class="normal">int(11)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">順序號</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">app_key</td>
<td align="left" valign="top"><p class="normal">varchar(50)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">YES</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">服務密鑰</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">app_ip_list</td>
<td align="left" valign="top"><p class="normal">text</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">YES</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">服務 IP 列表</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">app_url</td>
<td align="left" valign="top"><p class="normal">varchar(255)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">YES</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">服務網址</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">app_admin_url</td>
<td align="left" valign="top"><p class="normal">varchar(255)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">YES</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">后臺網址</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">app_url_recharge</td>
<td align="left" valign="top"><p class="normal">varchar(255)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">app_url_order</td>
<td align="left" valign="top"><p class="normal">varchar(255)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">檢查訂單是否存在的url地址</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">app_logo</td>
<td align="left" valign="top"><p class="normal">varchar(255)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">YES</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">LOGO 圖片地址</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">app_hosts</td>
<td align="left" valign="top"><p class="normal">text</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">YES</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">域名列表</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">return_fields</td>
<td align="left" valign="top"><p class="normal">text</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">YES</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">返回字段</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">app_status</td>
<td align="left" valign="top"><p class="normal">tinyint(1)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">1</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">1:啟用 0：禁用</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">說明：</td>
<td align="left" valign="top" colspan="8"><p class="normal">服務配置信息表，多個系統信息是以接口方式達到數據互通 app_id各個接口相互識別的接口id，app_name相同網站的名稱例如 ，ucenter、paycenter 各個網站接口公共app_key 各個網站接口公共地址app_url 此網址對接接口的啟用狀態app_status</td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="fieldheader" width="100%" align="left" valign="top">Indexes</td>
</tr>
</table>
<table width="100%" cellspacing="0" cellapdding="2" border="1">
<tr>
<td align="left" valign="top" class="fieldcolumn">Table</td>
<td align="left" valign="top" class="fieldcolumn">Non<br>unique</td>
<td align="left" valign="top" class="fieldcolumn">Key<br>name</td>
<td align="left" valign="top" class="fieldcolumn">Seq<br>in<br>index</td>
<td align="left" valign="top" class="fieldcolumn">Column<br>name</td>
<td align="left" valign="top" class="fieldcolumn">Collation</td>
<td align="left" valign="top" class="fieldcolumn">Cardinality</td>
<td align="left" valign="top" class="fieldcolumn">Sub<br>part</td>
<td align="left" valign="top" class="fieldcolumn">Packed</td>
<td align="left" valign="top" class="fieldcolumn">Null</td>
<td align="left" valign="top" class="fieldcolumn">Index<br>type</td>
<td align="left" valign="top" class="fieldcolumn">Comment</td>
<td align="left" valign="top" class="fieldcolumn">Index<br>comment</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">ucenter_base_app</td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal">PRIMARY</td>
<td align="left" valign="top"><p class="normal">1</td>
<td align="left" valign="top"><p class="normal">app_id</td>
<td align="left" valign="top"><p class="normal">A</td>
<td align="left" valign="top"><p class="normal">7</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">BTREE</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
</table>
<a href="#header"><p class="normal">Back</a><br class=page>
<p><a name='ucenter_base_app_server'> </a>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="headtext" width="30%" align="left" valign="top">ucenter_base_app_server</td>
<td> </td>
<tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="fieldheader" width="100%" align="left" valign="top">Fields</td>
</tr>
</table>
<table width="100%" cellspacing="0" cellapdding="2" border="1">
<tr>
<td align="center" valign="top" class="fieldcolumn">Field</td>
<td align="center" valign="top" class="fieldcolumn">Type</td>
<td align="center" valign="top" class="fieldcolumn">Collation</td>
<td align="center" valign="top" class="fieldcolumn">Null</td>
<td align="center" valign="top" class="fieldcolumn">Key</td>
<td align="center" valign="top" class="fieldcolumn">Default</td>
<td align="center" valign="top" class="fieldcolumn">Extra</td>
<td align="center" valign="top" class="fieldcolumn">Privileges</td>
<td align="center" valign="top" class="fieldcolumn">Comment</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">server_id</td>
<td align="left" valign="top"><p class="normal">mediumint(9) unsigned</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal">PRI</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">auto_increment</td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">服務器id</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">server_prefix</td>
<td align="left" valign="top"><p class="normal">varchar(50)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">服務器前綴 ：一區</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">server_name</td>
<td align="left" valign="top"><p class="normal">varchar(50)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">服務器名稱</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">server_url</td>
<td align="left" valign="top"><p class="normal">varchar(200)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal">MUL</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">服務器url</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">server_order</td>
<td align="left" valign="top"><p class="normal">int(11)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">服務器列表排序</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">app_id</td>
<td align="left" valign="top"><p class="normal">smallint(6)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal">MUL</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">所屬游戲id</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">company_id</td>
<td align="left" valign="top"><p class="normal">int(11)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal">MUL</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">運營商id</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">server_type</td>
<td align="left" valign="top"><p class="normal">tinyint(4)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">1</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">服類型,1:new,2:hot,3:滿 4:維護</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">server_state</td>
<td align="left" valign="top"><p class="normal">tinyint(4)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">服務器狀態,0:備運 1:開服中 2、停服,3:服務器宕機</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">socket_ip</td>
<td align="left" valign="top"><p class="normal">varchar(15)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">socket 的ip地址</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">socket_port</td>
<td align="left" valign="top"><p class="normal">mediumint(9)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">socket的端口號</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">server_stop_start_time</td>
<td align="left" valign="top"><p class="normal">datetime</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">停服開始時間</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">server_stop_end_time</td>
<td align="left" valign="top"><p class="normal">datetime</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">停服結束時間</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">server_stop_tip</td>
<td align="left" valign="top"><p class="normal">varchar(100)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">服務器宕機提示</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">app_version_package</td>
<td align="left" valign="top"><p class="normal">varchar(100)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">CPP中定義的版本, 決定是否顯示</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">company_name</td>
<td align="left" valign="top"><p class="normal">varchar(255)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">公司名稱</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">company_phone</td>
<td align="left" valign="top"><p class="normal">varchar(255)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">電話</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">contacter</td>
<td align="left" valign="top"><p class="normal">varchar(255)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">聯系人</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">sign_time</td>
<td align="left" valign="top"><p class="normal">datetime</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">簽約時間</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_name</td>
<td align="left" valign="top"><p class="normal">varchar(50)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">管理員賬號</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">account_num</td>
<td align="left" valign="top"><p class="normal">mediumint(8)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">賬號個數</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">db_host</td>
<td align="left" valign="top"><p class="normal">varchar(255)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">數據庫IP</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">db_user</td>
<td align="left" valign="top"><p class="normal">varchar(50)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">db_name</td>
<td align="left" valign="top"><p class="normal">varchar(255)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">數據庫名</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">db_passwd</td>
<td align="left" valign="top"><p class="normal">varchar(255)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">數據庫密碼</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">upload_path</td>
<td align="left" valign="top"><p class="normal">varchar(255)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">附件存放地址</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">business_agent</td>
<td align="left" valign="top"><p class="normal">varchar(255)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">業務代表</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">price</td>
<td align="left" valign="top"><p class="normal">varchar(255)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">費用</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">effective_date_start</td>
<td align="left" valign="top"><p class="normal">date</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">有效期開始與結束</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">effective_date_end</td>
<td align="left" valign="top"><p class="normal">date</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">有效期開始與結束1</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">plantform_url</td>
<td align="left" valign="top"><p class="normal">varchar(200)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">mallbuilder平臺url</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">ucenter_url</td>
<td align="left" valign="top"><p class="normal">varchar(200)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">paycenter_url</td>
<td align="left" valign="top"><p class="normal">varchar(200)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">cloud_type</td>
<td align="left" valign="top"><p class="normal">int(11)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">說明：</td>
<td align="left" valign="top" colspan="8"><p class="normal">Ucenter里配置的服務器信息</td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="fieldheader" width="100%" align="left" valign="top">Indexes</td>
</tr>
</table>
<table width="100%" cellspacing="0" cellapdding="2" border="1">
<tr>
<td align="left" valign="top" class="fieldcolumn">Table</td>
<td align="left" valign="top" class="fieldcolumn">Non<br>unique</td>
<td align="left" valign="top" class="fieldcolumn">Key<br>name</td>
<td align="left" valign="top" class="fieldcolumn">Seq<br>in<br>index</td>
<td align="left" valign="top" class="fieldcolumn">Column<br>name</td>
<td align="left" valign="top" class="fieldcolumn">Collation</td>
<td align="left" valign="top" class="fieldcolumn">Cardinality</td>
<td align="left" valign="top" class="fieldcolumn">Sub<br>part</td>
<td align="left" valign="top" class="fieldcolumn">Packed</td>
<td align="left" valign="top" class="fieldcolumn">Null</td>
<td align="left" valign="top" class="fieldcolumn">Index<br>type</td>
<td align="left" valign="top" class="fieldcolumn">Comment</td>
<td align="left" valign="top" class="fieldcolumn">Index<br>comment</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">ucenter_base_app_server</td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal">PRIMARY</td>
<td align="left" valign="top"><p class="normal">1</td>
<td align="left" valign="top"><p class="normal">server_id</td>
<td align="left" valign="top"><p class="normal">A</td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">BTREE</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">ucenter_base_app_server</td>
<td align="left" valign="top"><p class="normal">1</td>
<td align="left" valign="top"><p class="normal">game_id</td>
<td align="left" valign="top"><p class="normal">1</td>
<td align="left" valign="top"><p class="normal">app_id</td>
<td align="left" valign="top"><p class="normal">A</td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">BTREE</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">ucenter_base_app_server</td>
<td align="left" valign="top"><p class="normal">1</td>
<td align="left" valign="top"><p class="normal">server_url</td>
<td align="left" valign="top"><p class="normal">1</td>
<td align="left" valign="top"><p class="normal">server_url</td>
<td align="left" valign="top"><p class="normal">A</td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">BTREE</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">ucenter_base_app_server</td>
<td align="left" valign="top"><p class="normal">1</td>
<td align="left" valign="top"><p class="normal">company_id</td>
<td align="left" valign="top"><p class="normal">1</td>
<td align="left" valign="top"><p class="normal">company_id</td>
<td align="left" valign="top"><p class="normal">A</td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">BTREE</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
</table>
<a href="#header"><p class="normal">Back</a><br class=page>
<p><a name='ucenter_base_district'> </a>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="headtext" width="30%" align="left" valign="top">ucenter_base_district</td>
<td> </td>
<tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="fieldheader" width="100%" align="left" valign="top">Fields</td>
</tr>
</table>
<table width="100%" cellspacing="0" cellapdding="2" border="1">
<tr>
<td align="center" valign="top" class="fieldcolumn">Field</td>
<td align="center" valign="top" class="fieldcolumn">Type</td>
<td align="center" valign="top" class="fieldcolumn">Collation</td>
<td align="center" valign="top" class="fieldcolumn">Null</td>
<td align="center" valign="top" class="fieldcolumn">Key</td>
<td align="center" valign="top" class="fieldcolumn">Default</td>
<td align="center" valign="top" class="fieldcolumn">Extra</td>
<td align="center" valign="top" class="fieldcolumn">Privileges</td>
<td align="center" valign="top" class="fieldcolumn">Comment</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">district_id</td>
<td align="left" valign="top"><p class="normal">mediumint(8) unsigned</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal">PRI</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">auto_increment</td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">地區id</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">district_name</td>
<td align="left" valign="top"><p class="normal">varchar(255)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">地區名稱</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">district_parent_id</td>
<td align="left" valign="top"><p class="normal">mediumint(8) unsigned</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal">MUL</td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">父id</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">district_displayorder</td>
<td align="left" valign="top"><p class="normal">smallint(6)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">排序</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">district_region</td>
<td align="left" valign="top"><p class="normal">varchar(50)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">區域名稱 - 華北、東北、華東、華南、華中、西南、西北、港澳臺、海外</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">district_is_leaf</td>
<td align="left" valign="top"><p class="normal">tinyint(1)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">1</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">無子類</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">district_is_level</td>
<td align="left" valign="top"><p class="normal">tinyint(1)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">1</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">等級</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">說明：</td>
<td align="left" valign="top" colspan="8"><p class="normal">Ucenter的地區信息列表，里邊包括全國的省市區的信息</td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="fieldheader" width="100%" align="left" valign="top">Indexes</td>
</tr>
</table>
<table width="100%" cellspacing="0" cellapdding="2" border="1">
<tr>
<td align="left" valign="top" class="fieldcolumn">Table</td>
<td align="left" valign="top" class="fieldcolumn">Non<br>unique</td>
<td align="left" valign="top" class="fieldcolumn">Key<br>name</td>
<td align="left" valign="top" class="fieldcolumn">Seq<br>in<br>index</td>
<td align="left" valign="top" class="fieldcolumn">Column<br>name</td>
<td align="left" valign="top" class="fieldcolumn">Collation</td>
<td align="left" valign="top" class="fieldcolumn">Cardinality</td>
<td align="left" valign="top" class="fieldcolumn">Sub<br>part</td>
<td align="left" valign="top" class="fieldcolumn">Packed</td>
<td align="left" valign="top" class="fieldcolumn">Null</td>
<td align="left" valign="top" class="fieldcolumn">Index<br>type</td>
<td align="left" valign="top" class="fieldcolumn">Comment</td>
<td align="left" valign="top" class="fieldcolumn">Index<br>comment</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">ucenter_base_district</td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal">PRIMARY</td>
<td align="left" valign="top"><p class="normal">1</td>
<td align="left" valign="top"><p class="normal">district_id</td>
<td align="left" valign="top"><p class="normal">A</td>
<td align="left" valign="top"><p class="normal">43767</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">BTREE</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">ucenter_base_district</td>
<td align="left" valign="top"><p class="normal">1</td>
<td align="left" valign="top"><p class="normal">upid</td>
<td align="left" valign="top"><p class="normal">1</td>
<td align="left" valign="top"><p class="normal">district_parent_id</td>
<td align="left" valign="top"><p class="normal">A</td>
<td align="left" valign="top"><p class="normal">7294</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">BTREE</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">ucenter_base_district</td>
<td align="left" valign="top"><p class="normal">1</td>
<td align="left" valign="top"><p class="normal">upid</td>
<td align="left" valign="top"><p class="normal">2</td>
<td align="left" valign="top"><p class="normal">district_displayorder</td>
<td align="left" valign="top"><p class="normal">A</td>
<td align="left" valign="top"><p class="normal">7294</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">BTREE</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
</table>
<a href="#header"><p class="normal">Back</a><br class=page>
<p><a name='ucenter_message_template'> </a>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="headtext" width="30%" align="left" valign="top">ucenter_message_template</td>
<td> </td>
<tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="fieldheader" width="100%" align="left" valign="top">Fields</td>
</tr>
</table>
<table width="100%" cellspacing="0" cellapdding="2" border="1">
<tr>
<td align="center" valign="top" class="fieldcolumn">Field</td>
<td align="center" valign="top" class="fieldcolumn">Type</td>
<td align="center" valign="top" class="fieldcolumn">Collation</td>
<td align="center" valign="top" class="fieldcolumn">Null</td>
<td align="center" valign="top" class="fieldcolumn">Key</td>
<td align="center" valign="top" class="fieldcolumn">Default</td>
<td align="center" valign="top" class="fieldcolumn">Extra</td>
<td align="center" valign="top" class="fieldcolumn">Privileges</td>
<td align="center" valign="top" class="fieldcolumn">Comment</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">id</td>
<td align="left" valign="top"><p class="normal">int(10)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal">PRI</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">auto_increment</td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">code</td>
<td align="left" valign="top"><p class="normal">varchar(100)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">name</td>
<td align="left" valign="top"><p class="normal">varchar(100)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">title</td>
<td align="left" valign="top"><p class="normal">varchar(100)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">主題</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">content_email</td>
<td align="left" valign="top"><p class="normal">text</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">郵件內容</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">type</td>
<td align="left" valign="top"><p class="normal">tinyint(1)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">0商家1用戶</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">is_phone</td>
<td align="left" valign="top"><p class="normal">tinyint(1)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">0關閉1開啟</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">is_email</td>
<td align="left" valign="top"><p class="normal">tinyint(1)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">0關閉1開啟</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">is_mail</td>
<td align="left" valign="top"><p class="normal">tinyint(1)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">0關閉1開啟</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">content_mail</td>
<td align="left" valign="top"><p class="normal">text</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">站內信內容</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">content_phone</td>
<td align="left" valign="top"><p class="normal">text</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">短信內容</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">force_phone</td>
<td align="left" valign="top"><p class="normal">tinyint(1)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">手機短信0不強制1強制</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">force_email</td>
<td align="left" valign="top"><p class="normal">tinyint(1)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">郵件0不強制1強制</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">force_mail</td>
<td align="left" valign="top"><p class="normal">tinyint(1)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">站內信0不強制1強制</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">mold</td>
<td align="left" valign="top"><p class="normal">tinyint(1)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">0常用提示1訂單提示2卡券提示3售后提示</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">說明：</td>
<td align="left" valign="top" colspan="8"><p class="normal">信息模板表，信息模板的編號code，用戶功能需要向客戶端發送信息的代碼上綁定相對應的編碼，然后編輯信息模板按照編輯內容進行發送有3種方式，3個方式的狀態，mold為功能性提示</td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="fieldheader" width="100%" align="left" valign="top">Indexes</td>
</tr>
</table>
<table width="100%" cellspacing="0" cellapdding="2" border="1">
<tr>
<td align="left" valign="top" class="fieldcolumn">Table</td>
<td align="left" valign="top" class="fieldcolumn">Non<br>unique</td>
<td align="left" valign="top" class="fieldcolumn">Key<br>name</td>
<td align="left" valign="top" class="fieldcolumn">Seq<br>in<br>index</td>
<td align="left" valign="top" class="fieldcolumn">Column<br>name</td>
<td align="left" valign="top" class="fieldcolumn">Collation</td>
<td align="left" valign="top" class="fieldcolumn">Cardinality</td>
<td align="left" valign="top" class="fieldcolumn">Sub<br>part</td>
<td align="left" valign="top" class="fieldcolumn">Packed</td>
<td align="left" valign="top" class="fieldcolumn">Null</td>
<td align="left" valign="top" class="fieldcolumn">Index<br>type</td>
<td align="left" valign="top" class="fieldcolumn">Comment</td>
<td align="left" valign="top" class="fieldcolumn">Index<br>comment</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">ucenter_message_template</td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal">PRIMARY</td>
<td align="left" valign="top"><p class="normal">1</td>
<td align="left" valign="top"><p class="normal">id</td>
<td align="left" valign="top"><p class="normal">A</td>
<td align="left" valign="top"><p class="normal">9</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">BTREE</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
</table>
<a href="#header"><p class="normal">Back</a><br class=page>
<p><a name='ucenter_reg_option'> </a>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="headtext" width="30%" align="left" valign="top">ucenter_reg_option</td>
<td> </td>
<tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="fieldheader" width="100%" align="left" valign="top">Fields</td>
</tr>
</table>
<table width="100%" cellspacing="0" cellapdding="2" border="1">
<tr>
<td align="center" valign="top" class="fieldcolumn">Field</td>
<td align="center" valign="top" class="fieldcolumn">Type</td>
<td align="center" valign="top" class="fieldcolumn">Collation</td>
<td align="center" valign="top" class="fieldcolumn">Null</td>
<td align="center" valign="top" class="fieldcolumn">Key</td>
<td align="center" valign="top" class="fieldcolumn">Default</td>
<td align="center" valign="top" class="fieldcolumn">Extra</td>
<td align="center" valign="top" class="fieldcolumn">Privileges</td>
<td align="center" valign="top" class="fieldcolumn">Comment</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">reg_option_id</td>
<td align="left" valign="top"><p class="normal">int(11)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal">PRI</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">auto_increment</td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">選項值</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">reg_option_name</td>
<td align="left" valign="top"><p class="normal">varchar(20)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">reg_option_order</td>
<td align="left" valign="top"><p class="normal">int(3)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">option_id</td>
<td align="left" valign="top"><p class="normal">int(11)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">選項id</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">reg_option_required</td>
<td align="left" valign="top"><p class="normal">tinyint(1) unsigned</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">是否必須(BOOL):0-非必填;1-必填</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">reg_option_placeholder</td>
<td align="left" valign="top"><p class="normal">varchar(100)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">placeholder</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">reg_option_datatype</td>
<td align="left" valign="top"><p class="normal">varchar(20)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">data_type</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">reg_option_value</td>
<td align="left" valign="top"><p class="normal">varchar(255)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">配置選項</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">reg_option_active</td>
<td align="left" valign="top"><p class="normal">tinyint(1)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">是否啟用</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">說明：</td>
<td align="left" valign="top" colspan="8"><p class="normal">注冊選項表，設置選項字段控制注冊時那些必填那些非必填</td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="fieldheader" width="100%" align="left" valign="top">Indexes</td>
</tr>
</table>
<table width="100%" cellspacing="0" cellapdding="2" border="1">
<tr>
<td align="left" valign="top" class="fieldcolumn">Table</td>
<td align="left" valign="top" class="fieldcolumn">Non<br>unique</td>
<td align="left" valign="top" class="fieldcolumn">Key<br>name</td>
<td align="left" valign="top" class="fieldcolumn">Seq<br>in<br>index</td>
<td align="left" valign="top" class="fieldcolumn">Column<br>name</td>
<td align="left" valign="top" class="fieldcolumn">Collation</td>
<td align="left" valign="top" class="fieldcolumn">Cardinality</td>
<td align="left" valign="top" class="fieldcolumn">Sub<br>part</td>
<td align="left" valign="top" class="fieldcolumn">Packed</td>
<td align="left" valign="top" class="fieldcolumn">Null</td>
<td align="left" valign="top" class="fieldcolumn">Index<br>type</td>
<td align="left" valign="top" class="fieldcolumn">Comment</td>
<td align="left" valign="top" class="fieldcolumn">Index<br>comment</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">ucenter_reg_option</td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal">PRIMARY</td>
<td align="left" valign="top"><p class="normal">1</td>
<td align="left" valign="top"><p class="normal">reg_option_id</td>
<td align="left" valign="top"><p class="normal">A</td>
<td align="left" valign="top"><p class="normal">13</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">BTREE</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
</table>
<a href="#header"><p class="normal">Back</a><br class=page>
<p><a name='ucenter_reg_option_value'> </a>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="headtext" width="30%" align="left" valign="top">ucenter_reg_option_value</td>
<td> </td>
<tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="fieldheader" width="100%" align="left" valign="top">Fields</td>
</tr>
</table>
<table width="100%" cellspacing="0" cellapdding="2" border="1">
<tr>
<td align="center" valign="top" class="fieldcolumn">Field</td>
<td align="center" valign="top" class="fieldcolumn">Type</td>
<td align="center" valign="top" class="fieldcolumn">Collation</td>
<td align="center" valign="top" class="fieldcolumn">Null</td>
<td align="center" valign="top" class="fieldcolumn">Key</td>
<td align="center" valign="top" class="fieldcolumn">Default</td>
<td align="center" valign="top" class="fieldcolumn">Extra</td>
<td align="center" valign="top" class="fieldcolumn">Privileges</td>
<td align="center" valign="top" class="fieldcolumn">Comment</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">reg_option_value_id</td>
<td align="left" valign="top"><p class="normal">int(11)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal">PRI</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">auto_increment</td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">選項值</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">reg_option_id</td>
<td align="left" valign="top"><p class="normal">int(11)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">選項id</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">reg_option_value_image</td>
<td align="left" valign="top"><p class="normal">varchar(255)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">選項值圖片</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">reg_option_value_order</td>
<td align="left" valign="top"><p class="normal">tinyint(3) unsigned</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">50</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">reg_option_value_name</td>
<td align="left" valign="top"><p class="normal">varchar(255)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">選項值名稱</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">說明：</td>
<td align="left" valign="top" colspan="8"><p class="normal">注冊值表，目前后續版本會用到此表</td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="fieldheader" width="100%" align="left" valign="top">Indexes</td>
</tr>
</table>
<table width="100%" cellspacing="0" cellapdding="2" border="1">
<tr>
<td align="left" valign="top" class="fieldcolumn">Table</td>
<td align="left" valign="top" class="fieldcolumn">Non<br>unique</td>
<td align="left" valign="top" class="fieldcolumn">Key<br>name</td>
<td align="left" valign="top" class="fieldcolumn">Seq<br>in<br>index</td>
<td align="left" valign="top" class="fieldcolumn">Column<br>name</td>
<td align="left" valign="top" class="fieldcolumn">Collation</td>
<td align="left" valign="top" class="fieldcolumn">Cardinality</td>
<td align="left" valign="top" class="fieldcolumn">Sub<br>part</td>
<td align="left" valign="top" class="fieldcolumn">Packed</td>
<td align="left" valign="top" class="fieldcolumn">Null</td>
<td align="left" valign="top" class="fieldcolumn">Index<br>type</td>
<td align="left" valign="top" class="fieldcolumn">Comment</td>
<td align="left" valign="top" class="fieldcolumn">Index<br>comment</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">ucenter_reg_option_value</td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal">PRIMARY</td>
<td align="left" valign="top"><p class="normal">1</td>
<td align="left" valign="top"><p class="normal">reg_option_value_id</td>
<td align="left" valign="top"><p class="normal">A</td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">BTREE</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
</table>
<a href="#header"><p class="normal">Back</a><br class=page>
<p><a name='ucenter_server_id_seq'> </a>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="headtext" width="30%" align="left" valign="top">ucenter_server_id_seq</td>
<td> </td>
<tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="fieldheader" width="100%" align="left" valign="top">Fields</td>
</tr>
</table>
<table width="100%" cellspacing="0" cellapdding="2" border="1">
<tr>
<td align="center" valign="top" class="fieldcolumn">Field</td>
<td align="center" valign="top" class="fieldcolumn">Type</td>
<td align="center" valign="top" class="fieldcolumn">Collation</td>
<td align="center" valign="top" class="fieldcolumn">Null</td>
<td align="center" valign="top" class="fieldcolumn">Key</td>
<td align="center" valign="top" class="fieldcolumn">Default</td>
<td align="center" valign="top" class="fieldcolumn">Extra</td>
<td align="center" valign="top" class="fieldcolumn">Privileges</td>
<td align="center" valign="top" class="fieldcolumn">Comment</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">id</td>
<td align="left" valign="top"><p class="normal">int(10) unsigned</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal">PRI</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">auto_increment</td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="fieldheader" width="100%" align="left" valign="top">Indexes</td>
</tr>
</table>
<table width="100%" cellspacing="0" cellapdding="2" border="1">
<tr>
<td align="left" valign="top" class="fieldcolumn">Table</td>
<td align="left" valign="top" class="fieldcolumn">Non<br>unique</td>
<td align="left" valign="top" class="fieldcolumn">Key<br>name</td>
<td align="left" valign="top" class="fieldcolumn">Seq<br>in<br>index</td>
<td align="left" valign="top" class="fieldcolumn">Column<br>name</td>
<td align="left" valign="top" class="fieldcolumn">Collation</td>
<td align="left" valign="top" class="fieldcolumn">Cardinality</td>
<td align="left" valign="top" class="fieldcolumn">Sub<br>part</td>
<td align="left" valign="top" class="fieldcolumn">Packed</td>
<td align="left" valign="top" class="fieldcolumn">Null</td>
<td align="left" valign="top" class="fieldcolumn">Index<br>type</td>
<td align="left" valign="top" class="fieldcolumn">Comment</td>
<td align="left" valign="top" class="fieldcolumn">Index<br>comment</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">ucenter_server_id_seq</td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal">PRIMARY</td>
<td align="left" valign="top"><p class="normal">1</td>
<td align="left" valign="top"><p class="normal">id</td>
<td align="left" valign="top"><p class="normal">A</td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">BTREE</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
</table>
<a href="#header"><p class="normal">Back</a><br class=page>
<p><a name='ucenter_user_app'> </a>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="headtext" width="30%" align="left" valign="top">ucenter_user_app</td>
<td> </td>
<tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="fieldheader" width="100%" align="left" valign="top">Fields</td>
</tr>
</table>
<table width="100%" cellspacing="0" cellapdding="2" border="1">
<tr>
<td align="center" valign="top" class="fieldcolumn">Field</td>
<td align="center" valign="top" class="fieldcolumn">Type</td>
<td align="center" valign="top" class="fieldcolumn">Collation</td>
<td align="center" valign="top" class="fieldcolumn">Null</td>
<td align="center" valign="top" class="fieldcolumn">Key</td>
<td align="center" valign="top" class="fieldcolumn">Default</td>
<td align="center" valign="top" class="fieldcolumn">Extra</td>
<td align="center" valign="top" class="fieldcolumn">Privileges</td>
<td align="center" valign="top" class="fieldcolumn">Comment</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_name</td>
<td align="left" valign="top"><p class="normal">varchar(100)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal">PRI</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">用戶名</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">app_id</td>
<td align="left" valign="top"><p class="normal">int(11) unsigned</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal">PRI</td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">服務ID</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">app_user_id</td>
<td align="left" valign="top"><p class="normal">int(11) unsigned</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">用戶在該服務的ID</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">app_user_level</td>
<td align="left" valign="top"><p class="normal">int(11) unsigned</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">用戶在該服務的等級</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">active_time</td>
<td align="left" valign="top"><p class="normal">int(11) unsigned</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">激活時間</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">app_quantity</td>
<td align="left" valign="top"><p class="normal">int(11)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">1</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">app數量</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">說明：</td>
<td align="left" valign="top" colspan="8"><p class="normal">服務配置信息表，多個系統信息是以接口方式達到數據互通?app_id各個接口相互識別的接口id，app_name相同網站的名稱例如??，ucenter、paycenter ??各個網站接口公共app_key??各個網站接口公共地址app_url??此網址對接接口的啟用狀態app_status</td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="fieldheader" width="100%" align="left" valign="top">Indexes</td>
</tr>
</table>
<table width="100%" cellspacing="0" cellapdding="2" border="1">
<tr>
<td align="left" valign="top" class="fieldcolumn">Table</td>
<td align="left" valign="top" class="fieldcolumn">Non<br>unique</td>
<td align="left" valign="top" class="fieldcolumn">Key<br>name</td>
<td align="left" valign="top" class="fieldcolumn">Seq<br>in<br>index</td>
<td align="left" valign="top" class="fieldcolumn">Column<br>name</td>
<td align="left" valign="top" class="fieldcolumn">Collation</td>
<td align="left" valign="top" class="fieldcolumn">Cardinality</td>
<td align="left" valign="top" class="fieldcolumn">Sub<br>part</td>
<td align="left" valign="top" class="fieldcolumn">Packed</td>
<td align="left" valign="top" class="fieldcolumn">Null</td>
<td align="left" valign="top" class="fieldcolumn">Index<br>type</td>
<td align="left" valign="top" class="fieldcolumn">Comment</td>
<td align="left" valign="top" class="fieldcolumn">Index<br>comment</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">ucenter_user_app</td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal">PRIMARY</td>
<td align="left" valign="top"><p class="normal">1</td>
<td align="left" valign="top"><p class="normal">user_name</td>
<td align="left" valign="top"><p class="normal">A</td>
<td align="left" valign="top"><p class="normal">56</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">BTREE</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">ucenter_user_app</td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal">PRIMARY</td>
<td align="left" valign="top"><p class="normal">2</td>
<td align="left" valign="top"><p class="normal">app_id</td>
<td align="left" valign="top"><p class="normal">A</td>
<td align="left" valign="top"><p class="normal">56</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">BTREE</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
</table>
<a href="#header"><p class="normal">Back</a><br class=page>
<p><a name='ucenter_user_app_server'> </a>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="headtext" width="30%" align="left" valign="top">ucenter_user_app_server</td>
<td> </td>
<tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="fieldheader" width="100%" align="left" valign="top">Fields</td>
</tr>
</table>
<table width="100%" cellspacing="0" cellapdding="2" border="1">
<tr>
<td align="center" valign="top" class="fieldcolumn">Field</td>
<td align="center" valign="top" class="fieldcolumn">Type</td>
<td align="center" valign="top" class="fieldcolumn">Collation</td>
<td align="center" valign="top" class="fieldcolumn">Null</td>
<td align="center" valign="top" class="fieldcolumn">Key</td>
<td align="center" valign="top" class="fieldcolumn">Default</td>
<td align="center" valign="top" class="fieldcolumn">Extra</td>
<td align="center" valign="top" class="fieldcolumn">Privileges</td>
<td align="center" valign="top" class="fieldcolumn">Comment</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_name</td>
<td align="left" valign="top"><p class="normal">varchar(100)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal">PRI</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">這個user_name是指玩家在運營商那邊的唯一標記，不是官方平臺的賬號</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">app_id</td>
<td align="left" valign="top"><p class="normal">int(11)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal">PRI</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">應用在官方平臺的app_id</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">server_id</td>
<td align="left" valign="top"><p class="normal">int(11)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal">PRI</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">服務器id</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">active_time</td>
<td align="left" valign="top"><p class="normal">int(11)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">激活時間</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">說明：</td>
<td align="left" valign="top" colspan="8"><p class="normal">用戶激活應用的服務器列表</td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="fieldheader" width="100%" align="left" valign="top">Indexes</td>
</tr>
</table>
<table width="100%" cellspacing="0" cellapdding="2" border="1">
<tr>
<td align="left" valign="top" class="fieldcolumn">Table</td>
<td align="left" valign="top" class="fieldcolumn">Non<br>unique</td>
<td align="left" valign="top" class="fieldcolumn">Key<br>name</td>
<td align="left" valign="top" class="fieldcolumn">Seq<br>in<br>index</td>
<td align="left" valign="top" class="fieldcolumn">Column<br>name</td>
<td align="left" valign="top" class="fieldcolumn">Collation</td>
<td align="left" valign="top" class="fieldcolumn">Cardinality</td>
<td align="left" valign="top" class="fieldcolumn">Sub<br>part</td>
<td align="left" valign="top" class="fieldcolumn">Packed</td>
<td align="left" valign="top" class="fieldcolumn">Null</td>
<td align="left" valign="top" class="fieldcolumn">Index<br>type</td>
<td align="left" valign="top" class="fieldcolumn">Comment</td>
<td align="left" valign="top" class="fieldcolumn">Index<br>comment</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">ucenter_user_app_server</td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal">PRIMARY</td>
<td align="left" valign="top"><p class="normal">1</td>
<td align="left" valign="top"><p class="normal">user_name</td>
<td align="left" valign="top"><p class="normal">A</td>
<td align="left" valign="top"><p class="normal">56</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">BTREE</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">ucenter_user_app_server</td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal">PRIMARY</td>
<td align="left" valign="top"><p class="normal">2</td>
<td align="left" valign="top"><p class="normal">app_id</td>
<td align="left" valign="top"><p class="normal">A</td>
<td align="left" valign="top"><p class="normal">56</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">BTREE</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">ucenter_user_app_server</td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal">PRIMARY</td>
<td align="left" valign="top"><p class="normal">3</td>
<td align="left" valign="top"><p class="normal">server_id</td>
<td align="left" valign="top"><p class="normal">A</td>
<td align="left" valign="top"><p class="normal">56</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">BTREE</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
</table>
<a href="#header"><p class="normal">Back</a><br class=page>
<p><a name='ucenter_user_bind_connect'> </a>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="headtext" width="30%" align="left" valign="top">ucenter_user_bind_connect</td>
<td> </td>
<tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="fieldheader" width="100%" align="left" valign="top">Fields</td>
</tr>
</table>
<table width="100%" cellspacing="0" cellapdding="2" border="1">
<tr>
<td align="center" valign="top" class="fieldcolumn">Field</td>
<td align="center" valign="top" class="fieldcolumn">Type</td>
<td align="center" valign="top" class="fieldcolumn">Collation</td>
<td align="center" valign="top" class="fieldcolumn">Null</td>
<td align="center" valign="top" class="fieldcolumn">Key</td>
<td align="center" valign="top" class="fieldcolumn">Default</td>
<td align="center" valign="top" class="fieldcolumn">Extra</td>
<td align="center" valign="top" class="fieldcolumn">Privileges</td>
<td align="center" valign="top" class="fieldcolumn">Comment</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">bind_id</td>
<td align="left" valign="top"><p class="normal">varchar(100)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal">PRI</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">綁定標記：mobie/email/openid 綁定類型+openid</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">bind_type</td>
<td align="left" valign="top"><p class="normal">tinyint(4)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal">PRI</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">綁定類型 1:sinaweibo 2:qq 3:weixin 11:email 12:mobile</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_id</td>
<td align="left" valign="top"><p class="normal">int(10) unsigned</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">用戶id</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">bind_time</td>
<td align="left" valign="top"><p class="normal">timestamp</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">CURRENT_TIMESTAMP</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">綁定時間</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">bind_nickname</td>
<td align="left" valign="top"><p class="normal">varchar(50)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">名稱</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">bind_avator</td>
<td align="left" valign="top"><p class="normal">varchar(255)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">地址</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">bind_gender</td>
<td align="left" valign="top"><p class="normal">tinyint(1)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">1</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">性別 1:男 2:女</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">bind_openid</td>
<td align="left" valign="top"><p class="normal">varchar(200)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">訪問</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">bind_token</td>
<td align="left" valign="top"><p class="normal">varchar(200)</td>
<td align="left" valign="top"><p class="normal">latin1_swedish_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">說明：</td>
<td align="left" valign="top" colspan="8"><p class="normal">用戶綁定表用戶信息與用戶ID的綁定，此用戶綁定用戶信息采用的方式bind_type、索引bind_id采用的是綁定方式_綁定賬戶的方式作為綁定表的索引（例如手機號綁定則為
mobile_13011112222）、user_id與ucenter_user_info、ucenter_user_base中的user_id保持一致、都為此用戶信息、bind_token綁定的此用戶的token值</td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="fieldheader" width="100%" align="left" valign="top">Indexes</td>
</tr>
</table>
<table width="100%" cellspacing="0" cellapdding="2" border="1">
<tr>
<td align="left" valign="top" class="fieldcolumn">Table</td>
<td align="left" valign="top" class="fieldcolumn">Non<br>unique</td>
<td align="left" valign="top" class="fieldcolumn">Key<br>name</td>
<td align="left" valign="top" class="fieldcolumn">Seq<br>in<br>index</td>
<td align="left" valign="top" class="fieldcolumn">Column<br>name</td>
<td align="left" valign="top" class="fieldcolumn">Collation</td>
<td align="left" valign="top" class="fieldcolumn">Cardinality</td>
<td align="left" valign="top" class="fieldcolumn">Sub<br>part</td>
<td align="left" valign="top" class="fieldcolumn">Packed</td>
<td align="left" valign="top" class="fieldcolumn">Null</td>
<td align="left" valign="top" class="fieldcolumn">Index<br>type</td>
<td align="left" valign="top" class="fieldcolumn">Comment</td>
<td align="left" valign="top" class="fieldcolumn">Index<br>comment</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">ucenter_user_bind_connect</td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal">PRIMARY</td>
<td align="left" valign="top"><p class="normal">1</td>
<td align="left" valign="top"><p class="normal">bind_id</td>
<td align="left" valign="top"><p class="normal">A</td>
<td align="left" valign="top"><p class="normal">612</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">BTREE</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">ucenter_user_bind_connect</td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal">PRIMARY</td>
<td align="left" valign="top"><p class="normal">2</td>
<td align="left" valign="top"><p class="normal">bind_type</td>
<td align="left" valign="top"><p class="normal">A</td>
<td align="left" valign="top"><p class="normal">612</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">BTREE</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
</table>
<a href="#header"><p class="normal">Back</a><br class=page>
<p><a name='ucenter_user_grade'> </a>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="headtext" width="30%" align="left" valign="top">ucenter_user_grade</td>
<td> </td>
<tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="fieldheader" width="100%" align="left" valign="top">Fields</td>
</tr>
</table>
<table width="100%" cellspacing="0" cellapdding="2" border="1">
<tr>
<td align="center" valign="top" class="fieldcolumn">Field</td>
<td align="center" valign="top" class="fieldcolumn">Type</td>
<td align="center" valign="top" class="fieldcolumn">Collation</td>
<td align="center" valign="top" class="fieldcolumn">Null</td>
<td align="center" valign="top" class="fieldcolumn">Key</td>
<td align="center" valign="top" class="fieldcolumn">Default</td>
<td align="center" valign="top" class="fieldcolumn">Extra</td>
<td align="center" valign="top" class="fieldcolumn">Privileges</td>
<td align="center" valign="top" class="fieldcolumn">Comment</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_grade_id</td>
<td align="left" valign="top"><p class="normal">int(11)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal">PRI</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">auto_increment</td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_grade_name</td>
<td align="left" valign="top"><p class="normal">varchar(50)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_grade_demand</td>
<td align="left" valign="top"><p class="normal">int(10)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">條件</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_grade_treatment</td>
<td align="left" valign="top"><p class="normal">text</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">權益</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_grade_blogo</td>
<td align="left" valign="top"><p class="normal">varchar(255)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">大圖</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_grade_logo</td>
<td align="left" valign="top"><p class="normal">varchar(255)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">LOGO</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_grade_valid</td>
<td align="left" valign="top"><p class="normal">int(1)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">有效期</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_grade_sum</td>
<td align="left" valign="top"><p class="normal">int(11)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">年費</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_grade_rate</td>
<td align="left" valign="top"><p class="normal">float(3,1)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">0.0</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">折扣率</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_grade_time</td>
<td align="left" valign="top"><p class="normal">datetime</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">創建時間</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">說明：</td>
<td align="left" valign="top" colspan="8"><p class="normal">用戶等級表 ，用戶的等級表記錄的是該用戶是哪一種會員，以及滿足此會員所需要的條件user_grade_demand、還有該會員所享受的權益、該會員身份擁有的年限、以及續費所需要的年費，此會員享有的會員折扣率</td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="fieldheader" width="100%" align="left" valign="top">Indexes</td>
</tr>
</table>
<table width="100%" cellspacing="0" cellapdding="2" border="1">
<tr>
<td align="left" valign="top" class="fieldcolumn">Table</td>
<td align="left" valign="top" class="fieldcolumn">Non<br>unique</td>
<td align="left" valign="top" class="fieldcolumn">Key<br>name</td>
<td align="left" valign="top" class="fieldcolumn">Seq<br>in<br>index</td>
<td align="left" valign="top" class="fieldcolumn">Column<br>name</td>
<td align="left" valign="top" class="fieldcolumn">Collation</td>
<td align="left" valign="top" class="fieldcolumn">Cardinality</td>
<td align="left" valign="top" class="fieldcolumn">Sub<br>part</td>
<td align="left" valign="top" class="fieldcolumn">Packed</td>
<td align="left" valign="top" class="fieldcolumn">Null</td>
<td align="left" valign="top" class="fieldcolumn">Index<br>type</td>
<td align="left" valign="top" class="fieldcolumn">Comment</td>
<td align="left" valign="top" class="fieldcolumn">Index<br>comment</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">ucenter_user_grade</td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal">PRIMARY</td>
<td align="left" valign="top"><p class="normal">1</td>
<td align="left" valign="top"><p class="normal">user_grade_id</td>
<td align="left" valign="top"><p class="normal">A</td>
<td align="left" valign="top"><p class="normal">5</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">BTREE</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
</table>
<a href="#header"><p class="normal">Back</a><br class=page>
<p><a name='ucenter_user_id_seq'> </a>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="headtext" width="30%" align="left" valign="top">ucenter_user_id_seq</td>
<td> </td>
<tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="fieldheader" width="100%" align="left" valign="top">Fields</td>
</tr>
</table>
<table width="100%" cellspacing="0" cellapdding="2" border="1">
<tr>
<td align="center" valign="top" class="fieldcolumn">Field</td>
<td align="center" valign="top" class="fieldcolumn">Type</td>
<td align="center" valign="top" class="fieldcolumn">Collation</td>
<td align="center" valign="top" class="fieldcolumn">Null</td>
<td align="center" valign="top" class="fieldcolumn">Key</td>
<td align="center" valign="top" class="fieldcolumn">Default</td>
<td align="center" valign="top" class="fieldcolumn">Extra</td>
<td align="center" valign="top" class="fieldcolumn">Privileges</td>
<td align="center" valign="top" class="fieldcolumn">Comment</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">id</td>
<td align="left" valign="top"><p class="normal">int(10) unsigned</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal">PRI</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">auto_increment</td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="fieldheader" width="100%" align="left" valign="top">Indexes</td>
</tr>
</table>
<table width="100%" cellspacing="0" cellapdding="2" border="1">
<tr>
<td align="left" valign="top" class="fieldcolumn">Table</td>
<td align="left" valign="top" class="fieldcolumn">Non<br>unique</td>
<td align="left" valign="top" class="fieldcolumn">Key<br>name</td>
<td align="left" valign="top" class="fieldcolumn">Seq<br>in<br>index</td>
<td align="left" valign="top" class="fieldcolumn">Column<br>name</td>
<td align="left" valign="top" class="fieldcolumn">Collation</td>
<td align="left" valign="top" class="fieldcolumn">Cardinality</td>
<td align="left" valign="top" class="fieldcolumn">Sub<br>part</td>
<td align="left" valign="top" class="fieldcolumn">Packed</td>
<td align="left" valign="top" class="fieldcolumn">Null</td>
<td align="left" valign="top" class="fieldcolumn">Index<br>type</td>
<td align="left" valign="top" class="fieldcolumn">Comment</td>
<td align="left" valign="top" class="fieldcolumn">Index<br>comment</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">ucenter_user_id_seq</td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal">PRIMARY</td>
<td align="left" valign="top"><p class="normal">1</td>
<td align="left" valign="top"><p class="normal">id</td>
<td align="left" valign="top"><p class="normal">A</td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">BTREE</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
</table>
<a href="#header"><p class="normal">Back</a><br class=page>
<p><a name='ucenter_user_info'> </a>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="headtext" width="30%" align="left" valign="top">ucenter_user_info</td>
<td> </td>
<tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="fieldheader" width="100%" align="left" valign="top">Fields</td>
</tr>
</table>
<table width="100%" cellspacing="0" cellapdding="2" border="1">
<tr>
<td align="center" valign="top" class="fieldcolumn">Field</td>
<td align="center" valign="top" class="fieldcolumn">Type</td>
<td align="center" valign="top" class="fieldcolumn">Collation</td>
<td align="center" valign="top" class="fieldcolumn">Null</td>
<td align="center" valign="top" class="fieldcolumn">Key</td>
<td align="center" valign="top" class="fieldcolumn">Default</td>
<td align="center" valign="top" class="fieldcolumn">Extra</td>
<td align="center" valign="top" class="fieldcolumn">Privileges</td>
<td align="center" valign="top" class="fieldcolumn">Comment</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_id</td>
<td align="left" valign="top"><p class="normal">int(11) unsigned</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal">PRI</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">auto_increment</td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">用戶ID</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_name</td>
<td align="left" valign="top"><p class="normal">varchar(100)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal">UNI</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">用戶名</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">password</td>
<td align="left" valign="top"><p class="normal">char(32)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">YES</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">密碼</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_state</td>
<td align="left" valign="top"><p class="normal">tinyint(1) unsigned</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">狀態(0:未激活,1:未認證,2:已認證,3:鎖定)</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">action_time</td>
<td align="left" valign="top"><p class="normal">int(11) unsigned</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">活動時間</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">action_ip</td>
<td align="left" valign="top"><p class="normal">varchar(15)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">YES</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">活動IP</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">session_id</td>
<td align="left" valign="top"><p class="normal">varchar(100)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">YES</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">說明：</td>
<td align="left" valign="top" colspan="8"><p class="normal">用戶表的賬戶信息表擁有用戶登錄所需要的賬戶密碼，賬戶是否是正常狀態、登錄時存儲的session_id</td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="fieldheader" width="100%" align="left" valign="top">Indexes</td>
</tr>
</table>
<table width="100%" cellspacing="0" cellapdding="2" border="1">
<tr>
<td align="left" valign="top" class="fieldcolumn">Table</td>
<td align="left" valign="top" class="fieldcolumn">Non<br>unique</td>
<td align="left" valign="top" class="fieldcolumn">Key<br>name</td>
<td align="left" valign="top" class="fieldcolumn">Seq<br>in<br>index</td>
<td align="left" valign="top" class="fieldcolumn">Column<br>name</td>
<td align="left" valign="top" class="fieldcolumn">Collation</td>
<td align="left" valign="top" class="fieldcolumn">Cardinality</td>
<td align="left" valign="top" class="fieldcolumn">Sub<br>part</td>
<td align="left" valign="top" class="fieldcolumn">Packed</td>
<td align="left" valign="top" class="fieldcolumn">Null</td>
<td align="left" valign="top" class="fieldcolumn">Index<br>type</td>
<td align="left" valign="top" class="fieldcolumn">Comment</td>
<td align="left" valign="top" class="fieldcolumn">Index<br>comment</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">ucenter_user_info</td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal">PRIMARY</td>
<td align="left" valign="top"><p class="normal">1</td>
<td align="left" valign="top"><p class="normal">user_id</td>
<td align="left" valign="top"><p class="normal">A</td>
<td align="left" valign="top"><p class="normal">649</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">BTREE</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">ucenter_user_info</td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal">user_name</td>
<td align="left" valign="top"><p class="normal">1</td>
<td align="left" valign="top"><p class="normal">user_name</td>
<td align="left" valign="top"><p class="normal">A</td>
<td align="left" valign="top"><p class="normal">649</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">BTREE</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
</table>
<a href="#header"><p class="normal">Back</a><br class=page>
<p><a name='ucenter_user_info_detail'> </a>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="headtext" width="30%" align="left" valign="top">ucenter_user_info_detail</td>
<td> </td>
<tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="fieldheader" width="100%" align="left" valign="top">Fields</td>
</tr>
</table>
<table width="100%" cellspacing="0" cellapdding="2" border="1">
<tr>
<td align="center" valign="top" class="fieldcolumn">Field</td>
<td align="center" valign="top" class="fieldcolumn">Type</td>
<td align="center" valign="top" class="fieldcolumn">Collation</td>
<td align="center" valign="top" class="fieldcolumn">Null</td>
<td align="center" valign="top" class="fieldcolumn">Key</td>
<td align="center" valign="top" class="fieldcolumn">Default</td>
<td align="center" valign="top" class="fieldcolumn">Extra</td>
<td align="center" valign="top" class="fieldcolumn">Privileges</td>
<td align="center" valign="top" class="fieldcolumn">Comment</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_name</td>
<td align="left" valign="top"><p class="normal">varchar(100)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal">PRI</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">用戶名</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">nickname</td>
<td align="left" valign="top"><p class="normal">varchar(100)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">YES</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">昵稱</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_group</td>
<td align="left" valign="top"><p class="normal">int(11)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">用戶組</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_site_id</td>
<td align="left" valign="top"><p class="normal">int(11) unsigned</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">用戶站點ID</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_site_domain</td>
<td align="left" valign="top"><p class="normal">varchar(50)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">YES</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">用戶站點域名</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_question</td>
<td align="left" valign="top"><p class="normal">varchar(100)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">YES</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">密碼提示問題</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_answer</td>
<td align="left" valign="top"><p class="normal">varchar(100)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">YES</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">密碼提示答案</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_avatar</td>
<td align="left" valign="top"><p class="normal">varchar(255)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">YES</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">頭像</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_avatar_thumb</td>
<td align="left" valign="top"><p class="normal">varchar(255)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">YES</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">頭像縮略圖</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_gender</td>
<td align="left" valign="top"><p class="normal">tinyint(1) unsigned</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">性別</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_truename</td>
<td align="left" valign="top"><p class="normal">varchar(20)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">YES</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">真實姓名</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_tel</td>
<td align="left" valign="top"><p class="normal">varchar(30)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">YES</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">電話</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_birth</td>
<td align="left" valign="top"><p class="normal">varchar(10)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">YES</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">生日(YYYY-MM-DD)</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_qq</td>
<td align="left" valign="top"><p class="normal">varchar(20)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">YES</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">QQ</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_msn</td>
<td align="left" valign="top"><p class="normal">varchar(255)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">YES</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">MSN</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_province</td>
<td align="left" valign="top"><p class="normal">varchar(20)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">YES</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">省份</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_city</td>
<td align="left" valign="top"><p class="normal">varchar(20)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">YES</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">城市</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_intro</td>
<td align="left" valign="top"><p class="normal">text</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">YES</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">個人簡介</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_sign</td>
<td align="left" valign="top"><p class="normal">varchar(500)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">YES</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">用戶簽名</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_reg_time</td>
<td align="left" valign="top"><p class="normal">int(11) unsigned</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">注冊時間</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_count_login</td>
<td align="left" valign="top"><p class="normal">int(11) unsigned</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">登錄次數</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_lastlogin_time</td>
<td align="left" valign="top"><p class="normal">int(11) unsigned</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">上次登錄時間</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_lastlogin_ip</td>
<td align="left" valign="top"><p class="normal">varchar(15)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">YES</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">上次登錄IP</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_like_games</td>
<td align="left" valign="top"><p class="normal">text</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">YES</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">喜愛的游戲</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_reg_ip</td>
<td align="left" valign="top"><p class="normal">varchar(15)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">YES</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">注冊IP</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_money</td>
<td align="left" valign="top"><p class="normal">int(11) unsigned</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">用戶資金</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_credit</td>
<td align="left" valign="top"><p class="normal">int(11)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">用戶積分</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_getpsw_code</td>
<td align="left" valign="top"><p class="normal">varchar(32)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">YES</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">取回密碼認證碼</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_verify_code</td>
<td align="left" valign="top"><p class="normal">varchar(32)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">YES</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">認證賬號認證碼</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_phone_code</td>
<td align="left" valign="top"><p class="normal">varchar(32)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">YES</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">手機驗證碼</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_phone_code_stats</td>
<td align="left" valign="top"><p class="normal">varchar(20)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">YES</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">獲取手機驗證碼記錄(獲取次數,上次獲取時間)</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_idcard</td>
<td align="left" valign="top"><p class="normal">varchar(30)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">YES</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">身份證</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_mobile</td>
<td align="left" valign="top"><p class="normal">varchar(20)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">YES</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">手機號碼</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_email</td>
<td align="left" valign="top"><p class="normal">varchar(255)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_binded</td>
<td align="left" valign="top"><p class="normal">varchar(50)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">YES</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">已綁定項目</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_history_password</td>
<td align="left" valign="top"><p class="normal">text</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">YES</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">歷史密碼</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_history_ip</td>
<td align="left" valign="top"><p class="normal">text</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">YES</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">歷史 IP</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_grade</td>
<td align="left" valign="top"><p class="normal">tinyint(1)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_mobile_verify</td>
<td align="left" valign="top"><p class="normal">tinyint(1)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_email_verify</td>
<td align="left" valign="top"><p class="normal">tinyint(1)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_provinceid</td>
<td align="left" valign="top"><p class="normal">int(11)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_cityid</td>
<td align="left" valign="top"><p class="normal">int(11)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_areaid</td>
<td align="left" valign="top"><p class="normal">int(11)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_area</td>
<td align="left" valign="top"><p class="normal">varchar(255)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">說明：</td>
<td align="left" valign="top" colspan="8"><p class="normal">用戶詳情表與用戶表ucenter_user_info是根據user_name綁定的，對用戶信息做更詳細的記錄如當用戶忘記密碼的時候通過user_question、user_answer找回用戶密碼、
根據登陸次數user_count_login來限制登錄當達到登錄上限時用戶當天將無法登錄、并記錄該用戶的身份user_grade（與ucenter_user_grade綁定）、該用戶的所在省user_provinceid、市user_cityid、區縣user_areaid</td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="fieldheader" width="100%" align="left" valign="top">Indexes</td>
</tr>
</table>
<table width="100%" cellspacing="0" cellapdding="2" border="1">
<tr>
<td align="left" valign="top" class="fieldcolumn">Table</td>
<td align="left" valign="top" class="fieldcolumn">Non<br>unique</td>
<td align="left" valign="top" class="fieldcolumn">Key<br>name</td>
<td align="left" valign="top" class="fieldcolumn">Seq<br>in<br>index</td>
<td align="left" valign="top" class="fieldcolumn">Column<br>name</td>
<td align="left" valign="top" class="fieldcolumn">Collation</td>
<td align="left" valign="top" class="fieldcolumn">Cardinality</td>
<td align="left" valign="top" class="fieldcolumn">Sub<br>part</td>
<td align="left" valign="top" class="fieldcolumn">Packed</td>
<td align="left" valign="top" class="fieldcolumn">Null</td>
<td align="left" valign="top" class="fieldcolumn">Index<br>type</td>
<td align="left" valign="top" class="fieldcolumn">Comment</td>
<td align="left" valign="top" class="fieldcolumn">Index<br>comment</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">ucenter_user_info_detail</td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal">PRIMARY</td>
<td align="left" valign="top"><p class="normal">1</td>
<td align="left" valign="top"><p class="normal">user_name</td>
<td align="left" valign="top"><p class="normal">A</td>
<td align="left" valign="top"><p class="normal">651</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">BTREE</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
</table>
<a href="#header"><p class="normal">Back</a><br class=page>
<p><a name='ucenter_user_option'> </a>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="headtext" width="30%" align="left" valign="top">ucenter_user_option</td>
<td> </td>
<tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="fieldheader" width="100%" align="left" valign="top">Fields</td>
</tr>
</table>
<table width="100%" cellspacing="0" cellapdding="2" border="1">
<tr>
<td align="center" valign="top" class="fieldcolumn">Field</td>
<td align="center" valign="top" class="fieldcolumn">Type</td>
<td align="center" valign="top" class="fieldcolumn">Collation</td>
<td align="center" valign="top" class="fieldcolumn">Null</td>
<td align="center" valign="top" class="fieldcolumn">Key</td>
<td align="center" valign="top" class="fieldcolumn">Default</td>
<td align="center" valign="top" class="fieldcolumn">Extra</td>
<td align="center" valign="top" class="fieldcolumn">Privileges</td>
<td align="center" valign="top" class="fieldcolumn">Comment</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_option_id</td>
<td align="left" valign="top"><p class="normal">int(11)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal">PRI</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">auto_increment</td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">選項值</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">reg_option_id</td>
<td align="left" valign="top"><p class="normal">int(3)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">reg_option_value_id</td>
<td align="left" valign="top"><p class="normal">varchar(20)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_id</td>
<td align="left" valign="top"><p class="normal">int(11)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">選項id</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_option_value</td>
<td align="left" valign="top"><p class="normal">text</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="fieldheader" width="100%" align="left" valign="top">Indexes</td>
</tr>
</table>
<table width="100%" cellspacing="0" cellapdding="2" border="1">
<tr>
<td align="left" valign="top" class="fieldcolumn">Table</td>
<td align="left" valign="top" class="fieldcolumn">Non<br>unique</td>
<td align="left" valign="top" class="fieldcolumn">Key<br>name</td>
<td align="left" valign="top" class="fieldcolumn">Seq<br>in<br>index</td>
<td align="left" valign="top" class="fieldcolumn">Column<br>name</td>
<td align="left" valign="top" class="fieldcolumn">Collation</td>
<td align="left" valign="top" class="fieldcolumn">Cardinality</td>
<td align="left" valign="top" class="fieldcolumn">Sub<br>part</td>
<td align="left" valign="top" class="fieldcolumn">Packed</td>
<td align="left" valign="top" class="fieldcolumn">Null</td>
<td align="left" valign="top" class="fieldcolumn">Index<br>type</td>
<td align="left" valign="top" class="fieldcolumn">Comment</td>
<td align="left" valign="top" class="fieldcolumn">Index<br>comment</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">ucenter_user_option</td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal">PRIMARY</td>
<td align="left" valign="top"><p class="normal">1</td>
<td align="left" valign="top"><p class="normal">user_option_id</td>
<td align="left" valign="top"><p class="normal">A</td>
<td align="left" valign="top"><p class="normal">50</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">BTREE</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
</table>
<a href="#header"><p class="normal">Back</a><br class=page>
<p><a name='ucenter_user_privacy'> </a>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="headtext" width="30%" align="left" valign="top">ucenter_user_privacy</td>
<td> </td>
<tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="fieldheader" width="100%" align="left" valign="top">Fields</td>
</tr>
</table>
<table width="100%" cellspacing="0" cellapdding="2" border="1">
<tr>
<td align="center" valign="top" class="fieldcolumn">Field</td>
<td align="center" valign="top" class="fieldcolumn">Type</td>
<td align="center" valign="top" class="fieldcolumn">Collation</td>
<td align="center" valign="top" class="fieldcolumn">Null</td>
<td align="center" valign="top" class="fieldcolumn">Key</td>
<td align="center" valign="top" class="fieldcolumn">Default</td>
<td align="center" valign="top" class="fieldcolumn">Extra</td>
<td align="center" valign="top" class="fieldcolumn">Privileges</td>
<td align="center" valign="top" class="fieldcolumn">Comment</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_id</td>
<td align="left" valign="top"><p class="normal">int(10) unsigned</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal">PRI</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">用戶id</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_privacy_email</td>
<td align="left" valign="top"><p class="normal">tinyint(1)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">郵箱設置0公開1好友可見2保密</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_privacy_realname</td>
<td align="left" valign="top"><p class="normal">tinyint(1)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">真實姓名設置0公開1好友可見2保密</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_privacy_sex</td>
<td align="left" valign="top"><p class="normal">tinyint(1)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">性別設置0公開1好友可見2保密</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_privacy_birthday</td>
<td align="left" valign="top"><p class="normal">tinyint(1)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">生日設置0公開1好友可見2保密</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_privacy_area</td>
<td align="left" valign="top"><p class="normal">tinyint(1)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">所在地區設置0公開1好友可見2保密</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_privacy_qq</td>
<td align="left" valign="top"><p class="normal">tinyint(1)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">QQ設置0公開1好友可見2保密</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_privacy_ww</td>
<td align="left" valign="top"><p class="normal">tinyint(1)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">阿里旺旺設置0公開1好友可見2保密</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_privacy_mobile</td>
<td align="left" valign="top"><p class="normal">tinyint(1)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">手機設置0公開1好友可見2保密</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">說明：</td>
<td align="left" valign="top" colspan="8"><p class="normal">用戶信息隱私設置表想過聯系軟件是否對用戶可見</td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="fieldheader" width="100%" align="left" valign="top">Indexes</td>
</tr>
</table>
<table width="100%" cellspacing="0" cellapdding="2" border="1">
<tr>
<td align="left" valign="top" class="fieldcolumn">Table</td>
<td align="left" valign="top" class="fieldcolumn">Non<br>unique</td>
<td align="left" valign="top" class="fieldcolumn">Key<br>name</td>
<td align="left" valign="top" class="fieldcolumn">Seq<br>in<br>index</td>
<td align="left" valign="top" class="fieldcolumn">Column<br>name</td>
<td align="left" valign="top" class="fieldcolumn">Collation</td>
<td align="left" valign="top" class="fieldcolumn">Cardinality</td>
<td align="left" valign="top" class="fieldcolumn">Sub<br>part</td>
<td align="left" valign="top" class="fieldcolumn">Packed</td>
<td align="left" valign="top" class="fieldcolumn">Null</td>
<td align="left" valign="top" class="fieldcolumn">Index<br>type</td>
<td align="left" valign="top" class="fieldcolumn">Comment</td>
<td align="left" valign="top" class="fieldcolumn">Index<br>comment</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">ucenter_user_privacy</td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal">PRIMARY</td>
<td align="left" valign="top"><p class="normal">1</td>
<td align="left" valign="top"><p class="normal">user_id</td>
<td align="left" valign="top"><p class="normal">A</td>
<td align="left" valign="top"><p class="normal">38</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">BTREE</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
</table>
<a href="#header"><p class="normal">Back</a><br class=page>
<p><a name='ucenter_web_config'> </a>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="headtext" width="30%" align="left" valign="top">ucenter_web_config</td>
<td> </td>
<tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="fieldheader" width="100%" align="left" valign="top">Fields</td>
</tr>
</table>
<table width="100%" cellspacing="0" cellapdding="2" border="1">
<tr>
<td align="center" valign="top" class="fieldcolumn">Field</td>
<td align="center" valign="top" class="fieldcolumn">Type</td>
<td align="center" valign="top" class="fieldcolumn">Collation</td>
<td align="center" valign="top" class="fieldcolumn">Null</td>
<td align="center" valign="top" class="fieldcolumn">Key</td>
<td align="center" valign="top" class="fieldcolumn">Default</td>
<td align="center" valign="top" class="fieldcolumn">Extra</td>
<td align="center" valign="top" class="fieldcolumn">Privileges</td>
<td align="center" valign="top" class="fieldcolumn">Comment</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">config_key</td>
<td align="left" valign="top"><p class="normal">varchar(50)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal">PRI</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">數組下標</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">config_value</td>
<td align="left" valign="top"><p class="normal">text</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">數組值</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">config_type</td>
<td align="left" valign="top"><p class="normal">varchar(50)</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">config_enable</td>
<td align="left" valign="top"><p class="normal">tinyint(1)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">1</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">狀態值，1可能，0不可用</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">config_comment</td>
<td align="left" valign="top"><p class="normal">text</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">config_datatype</td>
<td align="left" valign="top"><p class="normal">enum('string','json','number')</td>
<td align="left" valign="top"><p class="normal">utf8_general_ci</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">string</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal">數據類型</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">說明：</td>
<td align="left" valign="top" colspan="8"><p class="normal">ucenter網址的公共配置表，對于公共參數都存儲在這個表里，此表此條數據操作的類型config_type、公共內容描述config_comment</td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="fieldheader" width="100%" align="left" valign="top">Indexes</td>
</tr>
</table>
<table width="100%" cellspacing="0" cellapdding="2" border="1">
<tr>
<td align="left" valign="top" class="fieldcolumn">Table</td>
<td align="left" valign="top" class="fieldcolumn">Non<br>unique</td>
<td align="left" valign="top" class="fieldcolumn">Key<br>name</td>
<td align="left" valign="top" class="fieldcolumn">Seq<br>in<br>index</td>
<td align="left" valign="top" class="fieldcolumn">Column<br>name</td>
<td align="left" valign="top" class="fieldcolumn">Collation</td>
<td align="left" valign="top" class="fieldcolumn">Cardinality</td>
<td align="left" valign="top" class="fieldcolumn">Sub<br>part</td>
<td align="left" valign="top" class="fieldcolumn">Packed</td>
<td align="left" valign="top" class="fieldcolumn">Null</td>
<td align="left" valign="top" class="fieldcolumn">Index<br>type</td>
<td align="left" valign="top" class="fieldcolumn">Comment</td>
<td align="left" valign="top" class="fieldcolumn">Index<br>comment</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">ucenter_web_config</td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal">PRIMARY</td>
<td align="left" valign="top"><p class="normal">1</td>
<td align="left" valign="top"><p class="normal">config_key</td>
<td align="left" valign="top"><p class="normal">A</td>
<td align="left" valign="top"><p class="normal">226</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">BTREE</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">ucenter_web_config</td>
<td align="left" valign="top"><p class="normal">1</td>
<td align="left" valign="top"><p class="normal">index</td>
<td align="left" valign="top"><p class="normal">1</td>
<td align="left" valign="top"><p class="normal">config_key</td>
<td align="left" valign="top"><p class="normal">A</td>
<td align="left" valign="top"><p class="normal">226</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">BTREE</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">ucenter_web_config</td>
<td align="left" valign="top"><p class="normal">1</td>
<td align="left" valign="top"><p class="normal">index</td>
<td align="left" valign="top"><p class="normal">2</td>
<td align="left" valign="top"><p class="normal">config_type</td>
<td align="left" valign="top"><p class="normal">A</td>
<td align="left" valign="top"><p class="normal">226</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">BTREE</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
</table>
<a href="#header"><p class="normal">Back</a><br class=page>
<p><a name='user_id_seq'> </a>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="headtext" width="30%" align="left" valign="top">user_id_seq</td>
<td> </td>
<tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="fieldheader" width="100%" align="left" valign="top">Fields</td>
</tr>
</table>
<table width="100%" cellspacing="0" cellapdding="2" border="1">
<tr>
<td align="center" valign="top" class="fieldcolumn">Field</td>
<td align="center" valign="top" class="fieldcolumn">Type</td>
<td align="center" valign="top" class="fieldcolumn">Collation</td>
<td align="center" valign="top" class="fieldcolumn">Null</td>
<td align="center" valign="top" class="fieldcolumn">Key</td>
<td align="center" valign="top" class="fieldcolumn">Default</td>
<td align="center" valign="top" class="fieldcolumn">Extra</td>
<td align="center" valign="top" class="fieldcolumn">Privileges</td>
<td align="center" valign="top" class="fieldcolumn">Comment</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">id</td>
<td align="left" valign="top"><p class="normal">int(10) unsigned</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">NO</td>
<td align="left" valign="top"><p class="normal">PRI</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">auto_increment</td>
<td align="left" valign="top"><p class="normal">select,insert,update,references</td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="fieldheader" width="100%" align="left" valign="top">Indexes</td>
</tr>
</table>
<table width="100%" cellspacing="0" cellapdding="2" border="1">
<tr>
<td align="left" valign="top" class="fieldcolumn">Table</td>
<td align="left" valign="top" class="fieldcolumn">Non<br>unique</td>
<td align="left" valign="top" class="fieldcolumn">Key<br>name</td>
<td align="left" valign="top" class="fieldcolumn">Seq<br>in<br>index</td>
<td align="left" valign="top" class="fieldcolumn">Column<br>name</td>
<td align="left" valign="top" class="fieldcolumn">Collation</td>
<td align="left" valign="top" class="fieldcolumn">Cardinality</td>
<td align="left" valign="top" class="fieldcolumn">Sub<br>part</td>
<td align="left" valign="top" class="fieldcolumn">Packed</td>
<td align="left" valign="top" class="fieldcolumn">Null</td>
<td align="left" valign="top" class="fieldcolumn">Index<br>type</td>
<td align="left" valign="top" class="fieldcolumn">Comment</td>
<td align="left" valign="top" class="fieldcolumn">Index<br>comment</td>
</tr>
<tr>
<td align="left" valign="top"><p class="normal">user_id_seq</td>
<td align="left" valign="top"><p class="normal">0</td>
<td align="left" valign="top"><p class="normal">PRIMARY</td>
<td align="left" valign="top"><p class="normal">1</td>
<td align="left" valign="top"><p class="normal">id</td>
<td align="left" valign="top"><p class="normal">A</td>
<td align="left" valign="top"><p class="normal">1</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal">(NULL)</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal">BTREE</td>
<td align="left" valign="top"><p class="normal"> </td>
<td align="left" valign="top"><p class="normal"> </td>
</tr>
</table>
- 序言
- 系統要求
- 版本更新日志
- 遠豐商城技術對接說明
- 開發指導
- 系統架構
- 負載集群
- 云存儲
- 框架內容
- 基礎
- 開發規范
- 目錄結構
- 架構
- 架構總覽
- 數據庫
- 數據庫連接
- 基本使用
- 緩存
- 配置
- 路由
- 數據字典
- ucenter
- shop
- paycenter
- ucenter_admin
- shop_admin
- paycenter_admin
- shop1
- shop2
- shop3
- 通訊內容
- 商家中心
- 頂部導航欄
- 店鋪信息欄
- 店鋪及商品提示欄
- 交易提示欄
- 銷售情況統計欄
- 集群架構圖
- 單品銷量排行欄
- 店鋪運營推廣欄
- 平臺聯系方式欄
- 訂單物流
- 商品
- 商品列表
- 商品詳情
- 商品發布與編輯
- 分銷商品
- 關聯版式
- 商品規格
- 圖片空間
- 淘寶導入
- 訂單流程
- 交易訂單
- 訂單退款/退貨
- 促銷
- 團購管理
- 加價購
- 限時折扣
- 滿即送
- 代金券管理
- 分銷
- 店鋪
- 店鋪設置
- 自銷產品供應商
- 實體店鋪
- 品牌申請
- 店鋪信息
- 消費者保障服務
- 門店賬號
- 分銷商--產品供應商
- 分銷明細
- 批發市場
- 商家微信公眾號
- 售后服務
- 咨詢管理
- 投訴管理
- 退款管理
- 退貨管理
- 雜項
- 遠程上傳圖片
- 接口（廢棄，參考最外層接口項）
- 接口說明
- 品牌
- 商品規格
- 商品類型
- 商品分類
- 商品
- 訂單
- 商品/店鋪收藏
- 足跡
- 退款及退貨
- 商家店鋪
- 會員
- 入駐協議
- 訂單接口
- 商品接口
- 訂單物流接口
- 商家中心接口
- 促銷接口
- 快遞鳥物流接口
- 代金券接口
- 首頁版塊
- 團購
- 平臺紅包
- 限時折扣接口
- 拼團接口
- wap首頁模板
- JS
- 銀聯支付
- 多語言
- 商品評分
- 圖片加載
- 買家申請退款退貨
- 商家退款退貨
- 平臺退款退貨
- 添加發票
- 提交訂單
- 確認訂單
- 運費銷售區域
- 獲取會員地址
- 充值
- 導出XLS
- 商城系統集成
- 多語言實現
- 三級分銷推廣鏈接發展推廣員
- app.ini.php
- 去分銷
- 版本更新
- 物流支持
- 運營人員建議
- 業務邏輯
- 統計結算
- 客服消息
- 賬號
- 三級分銷
- IM
- 配置
- 平臺帳號
- 活動數據表說明
- 接口
- 數據庫中間鍵
- MyCat的優勢
- 概念說明
- Mycat的下載及安裝
- 參數配置案列
- Mycat讀寫分離
- 基本命令
- 常見錯誤