shop_admin · 商城二開文檔

<table width="100%" border="0" cellspacing="0" cellpadding="5"> <tr> <td class="toptext">shop_admin</td> </tr> </table> <a name="header">&nbsp</a><ul> <li><a href="#yf_admin_base_protocol">yf_admin_base_protocol</a></li> <li><a href="#yf_admin_log_action">yf_admin_log_action</a></li> <li><a href="#yf_admin_menu">yf_admin_menu</a></li> <li><a href="#yf_admin_rights_base">yf_admin_rights_base</a></li> <li><a href="#yf_admin_rights_data_type">yf_admin_rights_data_type</a></li> <li><a href="#yf_admin_rights_group">yf_admin_rights_group</a></li> <li><a href="#yf_admin_user_base">yf_admin_user_base</a></li> <li><a href="#yf_admin_user_info">yf_admin_user_info</a></li> <li><a href="#yf_admin_user_rights_data">yf_admin_user_rights_data</a></li> <li><a href="#yf_admin_web_config">yf_admin_web_config</a></li> </ul> <a name='yf_admin_base_protocol'>&nbsp</a> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="headtext" width="30%" align="left" valign="top">yf_admin_base_protocol</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">protocol_id</td> <td align="left" valign="top">mediumint(8)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top">PRI</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">auto_increment</td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">協議索引Id</td> </tr> <tr> <td align="left" valign="top">cmd_id</td> <td align="left" valign="top">smallint(4)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top">UNI</td> <td align="left" valign="top">0</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">協議Id</td> </tr> <tr> <td align="left" valign="top">ctl</td> <td align="left" valign="top">varchar(50)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">控制器類名稱</td> </tr> <tr> <td align="left" valign="top">met</td> <td align="left" valign="top">varchar(50)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">控制器方法</td> </tr> <tr> <td align="left" valign="top">db</td> <td align="left" valign="top">enum('master','slave')</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">master</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">連接數據庫類型</td> </tr> <tr> <td align="left" valign="top">typ</td> <td align="left" valign="top">enum('e','json','msgpcak','amf')</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">json</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">輸出數據默認類型</td> </tr> <tr> <td align="left" valign="top">rights_id</td> <td align="left" valign="top">mediumint(20)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">權限Id</td> </tr> <tr> <td align="left" valign="top">log</td> <td align="left" valign="top">tinyint(1)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">是否記錄日志</td> </tr> <tr> <td align="left" valign="top">struct</td> <td align="left" valign="top">varchar(100)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">生成結構體，獨立使用</td> </tr> <tr> <td align="left" valign="top">comment</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">注釋</td> </tr> <tr> <td align="left" valign="top">0</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">int16_t:cmd_id</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">第一個字段</td> </tr> <tr> <td align="left" valign="top">1</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">2</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">3</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">4</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">5</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">6</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">7</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">8</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">9</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">10</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">11</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">12</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">13</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">14</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">15</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">16</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">17</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">18</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">19</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">20</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">21</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">22</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">23</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">24</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">25</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">26</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">27</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">28</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">29</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">30</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">31</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">32</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">33</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">34</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">說明：</td> <td align="left" valign="top" colspan="8">Shop平臺的代碼構造數據表用于記載該網站所包含的控制器方法名下對應的日志id就是log日志表信息，以及權限表rights_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 unique</td> <td align="left" valign="top" class="fieldcolumn">Key name</td> <td align="left" valign="top" class="fieldcolumn">Seq in index</td> <td align="left" valign="top" class="fieldcolumn">Column 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 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 type</td> <td align="left" valign="top" class="fieldcolumn">Comment</td> <td align="left" valign="top" class="fieldcolumn">Index comment</td> </tr> <tr> <td align="left" valign="top">yf_admin_base_protocol</td> <td align="left" valign="top">0</td> <td align="left" valign="top">PRIMARY</td> <td align="left" valign="top">1</td> <td align="left" valign="top">protocol_id</td> <td align="left" valign="top">A</td> <td align="left" valign="top">326</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">BTREE</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">yf_admin_base_protocol</td> <td align="left" valign="top">0</td> <td align="left" valign="top">cmd_id_key</td> <td align="left" valign="top">1</td> <td align="left" valign="top">cmd_id</td> <td align="left" valign="top">A</td> <td align="left" valign="top">326</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">BTREE</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> </tr> </table> <a href="#header">Back</a> <a name='yf_admin_log_action'>&nbsp</a> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="headtext" width="30%" align="left" valign="top">yf_admin_log_action</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">log_id</td> <td align="left" valign="top">int(11)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top">PRI</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">auto_increment</td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">日志id</td> </tr> <tr> <td align="left" valign="top">user_id</td> <td align="left" valign="top">mediumint(8)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top">MUL</td> <td align="left" valign="top">0</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">玩家Id</td> </tr> <tr> <td align="left" valign="top">user_account</td> <td align="left" valign="top">varchar(100)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">角色賬戶</td> </tr> <tr> <td align="left" valign="top">user_name</td> <td align="left" valign="top">varchar(20)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">角色名稱</td> </tr> <tr> <td align="left" valign="top">action_id</td> <td align="left" valign="top">mediumint(8)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">行為id == protocal_id -> rights_id</td> </tr> <tr> <td align="left" valign="top">action_type_id</td> <td align="left" valign="top">mediumint(9)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">操作類型id，right_parent_id</td> </tr> <tr> <td align="left" valign="top">log_param</td> <td align="left" valign="top">text</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">請求的參數</td> </tr> <tr> <td align="left" valign="top">log_ip</td> <td align="left" valign="top">varchar(20)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">log_date</td> <td align="left" valign="top">date</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top">MUL</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">日志日期</td> </tr> <tr> <td align="left" valign="top">log_time</td> <td align="left" valign="top">timestamp</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">CURRENT_TIMESTAMP</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">記錄時間</td> </tr> <tr> <td align="left" valign="top">說明：</td> <td align="left" valign="top" colspan="8">shop_admin后臺的用戶操作日志記錄表，對于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 unique</td> <td align="left" valign="top" class="fieldcolumn">Key name</td> <td align="left" valign="top" class="fieldcolumn">Seq in index</td> <td align="left" valign="top" class="fieldcolumn">Column 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 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 type</td> <td align="left" valign="top" class="fieldcolumn">Comment</td> <td align="left" valign="top" class="fieldcolumn">Index comment</td> </tr> <tr> <td align="left" valign="top">yf_admin_log_action</td> <td align="left" valign="top">0</td> <td align="left" valign="top">PRIMARY</td> <td align="left" valign="top">1</td> <td align="left" valign="top">log_id</td> <td align="left" valign="top">A</td> <td align="left" valign="top">71776</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">BTREE</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">yf_admin_log_action</td> <td align="left" valign="top">1</td> <td align="left" valign="top">player_id</td> <td align="left" valign="top">1</td> <td align="left" valign="top">user_id</td> <td align="left" valign="top">A</td> <td align="left" valign="top">12</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">BTREE</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">yf_admin_log_action</td> <td align="left" valign="top">1</td> <td align="left" valign="top">log_date</td> <td align="left" valign="top">1</td> <td align="left" valign="top">log_date</td> <td align="left" valign="top">A</td> <td align="left" valign="top">290</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">BTREE</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> </tr> </table> <a href="#header">Back</a> <a name='yf_admin_menu'>&nbsp</a> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="headtext" width="30%" align="left" valign="top">yf_admin_menu</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">menu_id</td> <td align="left" valign="top">int(10)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top">PRI</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">auto_increment</td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">菜單id</td> </tr> <tr> <td align="left" valign="top">menu_parent_id</td> <td align="left" valign="top">int(10)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">菜單id</td> </tr> <tr> <td align="left" valign="top">menu_name</td> <td align="left" valign="top">varchar(20)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">菜單名稱</td> </tr> <tr> <td align="left" valign="top">menu_icon</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">圖標class</td> </tr> <tr> <td align="left" valign="top">rights_id</td> <td align="left" valign="top">int(10) unsigned</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">權限id</td> </tr> <tr> <td align="left" valign="top">menu_url_ctl</td> <td align="left" valign="top">varchar(30)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">控制器名稱</td> </tr> <tr> <td align="left" valign="top">menu_url_met</td> <td align="left" valign="top">varchar(20)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">控制器方法</td> </tr> <tr> <td align="left" valign="top">menu_url_parem</td> <td align="left" valign="top">varchar(50)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">url參數</td> </tr> <tr> <td align="left" valign="top">menu_url_note</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">頁面幫助內容</td> </tr> <tr> <td align="left" valign="top">menu_order</td> <td align="left" valign="top">tinyint(4) unsigned</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">50</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">排序</td> </tr> <tr> <td align="left" valign="top">menu_time</td> <td align="left" valign="top">datetime</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0000-00-00 00:00:00</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">最后更新時間</td> </tr> <tr> <td align="left" valign="top">說明：</td> <td align="left" valign="top" colspan="8">Shop平臺的菜單表，記錄該菜單id （menu_id），上級菜單id（menu_parent_id），如有該父級菜單則該菜單在父級菜單列表下，該菜單的權限rights_id受控于權限表yf_admin_rights_base</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 unique</td> <td align="left" valign="top" class="fieldcolumn">Key name</td> <td align="left" valign="top" class="fieldcolumn">Seq in index</td> <td align="left" valign="top" class="fieldcolumn">Column 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 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 type</td> <td align="left" valign="top" class="fieldcolumn">Comment</td> <td align="left" valign="top" class="fieldcolumn">Index comment</td> </tr> <tr> <td align="left" valign="top">yf_admin_menu</td> <td align="left" valign="top">0</td> <td align="left" valign="top">PRIMARY</td> <td align="left" valign="top">1</td> <td align="left" valign="top">menu_id</td> <td align="left" valign="top">A</td> <td align="left" valign="top">228</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">BTREE</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> </tr> </table> <a href="#header">Back</a> <a name='yf_admin_rights_base'>&nbsp</a> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="headtext" width="30%" align="left" valign="top">yf_admin_rights_base</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">rights_id</td> <td align="left" valign="top">smallint(4) unsigned</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top">PRI</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">auto_increment</td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">權限Id</td> </tr> <tr> <td align="left" valign="top">rights_name</td> <td align="left" valign="top">varchar(20)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">權限名稱</td> </tr> <tr> <td align="left" valign="top">rights_parent_id</td> <td align="left" valign="top">smallint(4) unsigned</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">權限父Id</td> </tr> <tr> <td align="left" valign="top">rights_remark</td> <td align="left" valign="top">varchar(255)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">備注</td> </tr> <tr> <td align="left" valign="top">rights_order</td> <td align="left" valign="top">smallint(4)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">50</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">排序</td> </tr> <tr> <td align="left" valign="top">說明：</td> <td align="left" valign="top" colspan="8">權限表管理后臺菜單列表的權限</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 unique</td> <td align="left" valign="top" class="fieldcolumn">Key name</td> <td align="left" valign="top" class="fieldcolumn">Seq in index</td> <td align="left" valign="top" class="fieldcolumn">Column 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 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 type</td> <td align="left" valign="top" class="fieldcolumn">Comment</td> <td align="left" valign="top" class="fieldcolumn">Index comment</td> </tr> <tr> <td align="left" valign="top">yf_admin_rights_base</td> <td align="left" valign="top">0</td> <td align="left" valign="top">PRIMARY</td> <td align="left" valign="top">1</td> <td align="left" valign="top">rights_id</td> <td align="left" valign="top">A</td> <td align="left" valign="top">385</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">BTREE</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> </tr> </table> <a href="#header">Back</a> <a name='yf_admin_rights_data_type'>&nbsp</a> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="headtext" width="30%" align="left" valign="top">yf_admin_rights_data_type</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">rights_data_type_id</td> <td align="left" valign="top">mediumint(6) unsigned</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top">PRI</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">auto_increment</td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">權限數據類型id</td> </tr> <tr> <td align="left" valign="top">rights_data_type_name</td> <td align="left" valign="top">varchar(50)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">權限數據類型名稱</td> </tr> <tr> <td align="left" valign="top">rights_data_type_primary_key</td> <td align="left" valign="top">text</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">數據主鍵</td> </tr> <tr> <td align="left" valign="top">說明：</td> <td align="left" valign="top" colspan="8">數據權限類型表</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 unique</td> <td align="left" valign="top" class="fieldcolumn">Key name</td> <td align="left" valign="top" class="fieldcolumn">Seq in index</td> <td align="left" valign="top" class="fieldcolumn">Column 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 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 type</td> <td align="left" valign="top" class="fieldcolumn">Comment</td> <td align="left" valign="top" class="fieldcolumn">Index comment</td> </tr> <tr> <td align="left" valign="top">yf_admin_rights_data_type</td> <td align="left" valign="top">0</td> <td align="left" valign="top">PRIMARY</td> <td align="left" valign="top">1</td> <td align="left" valign="top">rights_data_type_id</td> <td align="left" valign="top">A</td> <td align="left" valign="top">0</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">BTREE</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> </tr> </table> <a href="#header">Back</a> <a name='yf_admin_rights_group'>&nbsp</a> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="headtext" width="30%" align="left" valign="top">yf_admin_rights_group</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">rights_group_id</td> <td align="left" valign="top">smallint(4) unsigned</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top">PRI</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">auto_increment</td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">權限組id</td> </tr> <tr> <td align="left" valign="top">rights_group_name</td> <td align="left" valign="top">varchar(50)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">權限組名稱</td> </tr> <tr> <td align="left" valign="top">rights_group_rights_ids</td> <td align="left" valign="top">text</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">權限列表</td> </tr> <tr> <td align="left" valign="top">rights_group_add_time</td> <td align="left" valign="top">int(10)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">創建時間</td> </tr><tr> <td align="left" valign="top">說明：</td> <td align="left" valign="top" colspan="8">權限分組表將權限集合成一個權限組，整合供用戶設置權限來分別顯示</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 unique</td> <td align="left" valign="top" class="fieldcolumn">Key name</td> <td align="left" valign="top" class="fieldcolumn">Seq in index</td> <td align="left" valign="top" class="fieldcolumn">Column 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 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 type</td> <td align="left" valign="top" class="fieldcolumn">Comment</td> <td align="left" valign="top" class="fieldcolumn">Index comment</td> </tr> <tr> <td align="left" valign="top">yf_admin_rights_group</td> <td align="left" valign="top">0</td> <td align="left" valign="top">PRIMARY</td> <td align="left" valign="top">1</td> <td align="left" valign="top">rights_group_id</td> <td align="left" valign="top">A</td> <td align="left" valign="top">4</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">BTREE</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> </tr> </table> <a href="#header">Back</a> <a name='yf_admin_user_base'>&nbsp</a> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="headtext" width="30%" align="left" valign="top">yf_admin_user_base</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">user_id</td> <td align="left" valign="top">mediumint(8) unsigned</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top">PRI</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">auto_increment</td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">用戶id</td> </tr> <tr> <td align="left" valign="top">user_account</td> <td align="left" valign="top">varchar(50)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top">UNI</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">用戶帳號</td> </tr> <tr> <td align="left" valign="top">user_password</td> <td align="left" valign="top">char(32)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">密碼：使用用戶中心-此處廢棄</td> </tr> <tr> <td align="left" valign="top">user_key</td> <td align="left" valign="top">varchar(32)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">用戶Key</td> </tr> <tr> <td align="left" valign="top">user_delete</td> <td align="left" valign="top">tinyint(4) unsigned</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">是否被封禁，0：未封禁，1：封禁</td> </tr> <tr> <td align="left" valign="top">rights_group_id</td> <td align="left" valign="top">smallint(4)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">用戶權限組id</td> </tr> <tr> <td align="left" valign="top">sub_site_id</td> <td align="left" valign="top">int(11)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">所屬子站， 0總站</td> </tr> <tr> <td align="left" valign="top">說明：</td> <td align="left" valign="top" colspan="8">用戶基礎信息表shop后臺用戶可通過賬戶登錄，然后總賬戶可以可分配權限表</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 unique</td> <td align="left" valign="top" class="fieldcolumn">Key name</td> <td align="left" valign="top" class="fieldcolumn">Seq in index</td> <td align="left" valign="top" class="fieldcolumn">Column 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 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 type</td> <td align="left" valign="top" class="fieldcolumn">Comment</td> <td align="left" valign="top" class="fieldcolumn">Index comment</td> </tr> <tr> <td align="left" valign="top">yf_admin_user_base</td> <td align="left" valign="top">0</td> <td align="left" valign="top">PRIMARY</td> <td align="left" valign="top">1</td> <td align="left" valign="top">user_id</td> <td align="left" valign="top">A</td> <td align="left" valign="top">9</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">BTREE</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">yf_admin_user_base</td> <td align="left" valign="top">0</td> <td align="left" valign="top">user_account</td> <td align="left" valign="top">1</td> <td align="left" valign="top">user_account</td> <td align="left" valign="top">A</td> <td align="left" valign="top">9</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">BTREE</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> </tr> </table> <a href="#header">Back</a> <a name='yf_admin_user_info'>&nbsp</a> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="headtext" width="30%" align="left" valign="top">yf_admin_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">user_id</td> <td align="left" valign="top">mediumint(8)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top">PRI</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">用戶id</td> </tr> <tr> <td align="left" valign="top">user_nickname</td> <td align="left" valign="top">varchar(100)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">昵稱</td> </tr> <tr> <td align="left" valign="top">說明：</td> <td align="left" valign="top" colspan="8">用戶數據庫主機表</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 unique</td> <td align="left" valign="top" class="fieldcolumn">Key name</td> <td align="left" valign="top" class="fieldcolumn">Seq in index</td> <td align="left" valign="top" class="fieldcolumn">Column 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 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 type</td> <td align="left" valign="top" class="fieldcolumn">Comment</td> <td align="left" valign="top" class="fieldcolumn">Index comment</td> </tr> <tr> <td align="left" valign="top">yf_admin_user_info</td> <td align="left" valign="top">0</td> <td align="left" valign="top">PRIMARY</td> <td align="left" valign="top">1</td> <td align="left" valign="top">user_id</td> <td align="left" valign="top">A</td> <td align="left" valign="top">0</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">BTREE</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> </tr> </table> <a href="#header">Back</a> <a name='yf_admin_user_rights_data'>&nbsp</a> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="headtext" width="30%" align="left" valign="top">yf_admin_user_rights_data</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">user_rights_data_id</td> <td align="left" valign="top">mediumint(8) unsigned</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top">PRI</td> <td align="left" valign="top">0</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">user_id</td> <td align="left" valign="top">mediumint(8) unsigned</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">用戶id</td> </tr> <tr> <td align="left" valign="top">user_rights_data_value</td> <td align="left" valign="top">mediumint(8)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">主鍵值</td> </tr> <tr> <td align="left" valign="top">rights_data_type_id</td> <td align="left" valign="top">mediumint(8) unsigned</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">0</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">權限類型Id</td> </tr> <tr> <td align="left" valign="top">說明：</td> <td align="left" valign="top" colspan="8">用戶數據權限表</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 unique</td> <td align="left" valign="top" class="fieldcolumn">Key name</td> <td align="left" valign="top" class="fieldcolumn">Seq in index</td> <td align="left" valign="top" class="fieldcolumn">Column 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 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 type</td> <td align="left" valign="top" class="fieldcolumn">Comment</td> <td align="left" valign="top" class="fieldcolumn">Index comment</td> </tr> <tr> <td align="left" valign="top">yf_admin_user_rights_data</td> <td align="left" valign="top">0</td> <td align="left" valign="top">PRIMARY</td> <td align="left" valign="top">1</td> <td align="left" valign="top">user_rights_data_id</td> <td align="left" valign="top">A</td> <td align="left" valign="top">0</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">BTREE</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> </tr> </table> <a href="#header">Back</a> <a name='yf_admin_web_config'>&nbsp</a> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="headtext" width="30%" align="left" valign="top">yf_admin_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">config_key</td> <td align="left" valign="top">varchar(50)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top">PRI</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">數組下標</td> </tr> <tr> <td align="left" valign="top">config_value</td> <td align="left" valign="top">text</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">數組值</td> </tr> <tr> <td align="left" valign="top">config_type</td> <td align="left" valign="top">varchar(50)</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">config_enable</td> <td align="left" valign="top">tinyint(1)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">1</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">狀態值，1可能，0不可用</td> </tr> <tr> <td align="left" valign="top">config_comment</td> <td align="left" valign="top">text</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">config_datatype</td> <td align="left" valign="top">enum('string','json','number')</td> <td align="left" valign="top">utf8_general_ci</td> <td align="left" valign="top">NO</td> <td align="left" valign="top"> </td> <td align="left" valign="top">string</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">數據類型</td> </tr> <tr> <td align="left" valign="top">說明：</td> <td align="left" valign="top" colspan="8">Shop_admin網址的公共配置表，對于公共參數都存儲在這個表里，此表此條數據操作的類型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 unique</td> <td align="left" valign="top" class="fieldcolumn">Key name</td> <td align="left" valign="top" class="fieldcolumn">Seq in index</td> <td align="left" valign="top" class="fieldcolumn">Column 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 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 type</td> <td align="left" valign="top" class="fieldcolumn">Comment</td> <td align="left" valign="top" class="fieldcolumn">Index comment</td> </tr> <tr> <td align="left" valign="top">yf_admin_web_config</td> <td align="left" valign="top">0</td> <td align="left" valign="top">PRIMARY</td> <td align="left" valign="top">1</td> <td align="left" valign="top">config_key</td> <td align="left" valign="top">A</td> <td align="left" valign="top">5</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">BTREE</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">yf_admin_web_config</td> <td align="left" valign="top">1</td> <td align="left" valign="top">index</td> <td align="left" valign="top">1</td> <td align="left" valign="top">config_key</td> <td align="left" valign="top">A</td> <td align="left" valign="top">5</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">BTREE</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top">yf_admin_web_config</td> <td align="left" valign="top">1</td> <td align="left" valign="top">index</td> <td align="left" valign="top">2</td> <td align="left" valign="top">config_type</td> <td align="left" valign="top">A</td> <td align="left" valign="top">5</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">BTREE</td> <td align="left" valign="top"> </td> <td align="left" valign="top"> </td> </tr> </table>