<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">&nbsp</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'>&nbsp</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>&nbsp</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">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">BTREE</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> </tr> </table> <a href="#header"><p class="normal">Back</a><br class=page> <p><a name='ucenter_base_app'>&nbsp</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>&nbsp</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">0</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">select,insert,update,references</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">1</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">BTREE</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> </tr> </table> <a href="#header"><p class="normal">Back</a><br class=page> <p><a name='ucenter_base_app_server'>&nbsp</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>&nbsp</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">0</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</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">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">1</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">0</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">0</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">select,insert,update,references</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">select,insert,update,references</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">select,insert,update,references</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">select,insert,update,references</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">BTREE</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">BTREE</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">BTREE</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">BTREE</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> </tr> </table> <a href="#header"><p class="normal">Back</a><br class=page> <p><a name='ucenter_base_district'>&nbsp</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>&nbsp</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">0</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">1</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">1</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">BTREE</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">BTREE</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">BTREE</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> </tr> </table> <a href="#header"><p class="normal">Back</a><br class=page> <p><a name='ucenter_message_template'>&nbsp</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>&nbsp</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">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">select,insert,update,references</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">select,insert,update,references</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">0</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">0</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">0</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">0</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">0</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">0</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">0</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">BTREE</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> </tr> </table> <a href="#header"><p class="normal">Back</a><br class=page> <p><a name='ucenter_reg_option'>&nbsp</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>&nbsp</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">select,insert,update,references</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">select,insert,update,references</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">0</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">0</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">BTREE</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> </tr> </table> <a href="#header"><p class="normal">Back</a><br class=page> <p><a name='ucenter_reg_option_value'>&nbsp</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>&nbsp</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">50</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">select,insert,update,references</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">BTREE</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> </tr> </table> <a href="#header"><p class="normal">Back</a><br class=page> <p><a name='ucenter_server_id_seq'>&nbsp</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>&nbsp</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">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">BTREE</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> </tr> </table> <a href="#header"><p class="normal">Back</a><br class=page> <p><a name='ucenter_user_app'>&nbsp</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>&nbsp</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">&nbsp;</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">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">0</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">0</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">0</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">1</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">BTREE</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">BTREE</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> </tr> </table> <a href="#header"><p class="normal">Back</a><br class=page> <p><a name='ucenter_user_app_server'>&nbsp</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>&nbsp</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">&nbsp;</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">&nbsp;</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">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">BTREE</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">BTREE</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">BTREE</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> </tr> </table> <a href="#header"><p class="normal">Back</a><br class=page> <p><a name='ucenter_user_bind_connect'>&nbsp</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>&nbsp</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">&nbsp;</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">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">0</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">CURRENT_TIMESTAMP</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">1</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">select,insert,update,references</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">BTREE</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">BTREE</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> </tr> </table> <a href="#header"><p class="normal">Back</a><br class=page> <p><a name='ucenter_user_grade'>&nbsp</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>&nbsp</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">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">select,insert,update,references</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">0</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">0</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">0</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">0.0</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">BTREE</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> </tr> </table> <a href="#header"><p class="normal">Back</a><br class=page> <p><a name='ucenter_user_id_seq'>&nbsp</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>&nbsp</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">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">BTREE</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> </tr> </table> <a href="#header"><p class="normal">Back</a><br class=page> <p><a name='ucenter_user_info'>&nbsp</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>&nbsp</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">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">0</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">0</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">select,insert,update,references</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">BTREE</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">BTREE</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> </tr> </table> <a href="#header"><p class="normal">Back</a><br class=page> <p><a name='ucenter_user_info_detail'>&nbsp</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>&nbsp</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">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">0</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">0</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">0</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">0</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">0</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">0</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">0</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">0</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">select,insert,update,references</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">0</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">select,insert,update,references</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">0</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">select,insert,update,references</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">0</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">select,insert,update,references</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">0</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">select,insert,update,references</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">0</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">select,insert,update,references</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">0</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">select,insert,update,references</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">select,insert,update,references</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">BTREE</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> </tr> </table> <a href="#header"><p class="normal">Back</a><br class=page> <p><a name='ucenter_user_option'>&nbsp</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>&nbsp</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">select,insert,update,references</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">select,insert,update,references</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">select,insert,update,references</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">BTREE</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> </tr> </table> <a href="#header"><p class="normal">Back</a><br class=page> <p><a name='ucenter_user_privacy'>&nbsp</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>&nbsp</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">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">0</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">0</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">0</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">0</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">0</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">0</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">0</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">0</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">BTREE</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> </tr> </table> <a href="#header"><p class="normal">Back</a><br class=page> <p><a name='ucenter_web_config'>&nbsp</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>&nbsp</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">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">select,insert,update,references</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">1</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">(NULL)</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">select,insert,update,references</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">string</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">BTREE</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">BTREE</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">BTREE</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> </tr> </table> <a href="#header"><p class="normal">Back</a><br class=page> <p><a name='user_id_seq'>&nbsp</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>&nbsp</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">&nbsp;</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">&nbsp;</td> <td align="left" valign="top"><p class="normal">BTREE</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> <td align="left" valign="top"><p class="normal">&nbsp;</td> </tr> </table>