paycenter_admin · 商城二開文檔

<table width="100%" border="0" cellspacing="0" cellpadding="5"> <tr> <td class="toptext">paycenter_admin</td> </tr> </table> <a name="header">&nbsp</a><ul> <li><a href="#pay_admin_base_protocol">pay_admin_base_protocol</a></li> <li><a href="#pay_admin_log_action">pay_admin_log_action</a></li> <li><a href="#pay_admin_rights_group">pay_admin_rights_group</a></li> <li><a href="#pay_admin_user_base">pay_admin_user_base</a></li> <li><a href="#pay_admin_web_config">pay_admin_web_config</a></li> </ul> <a name='pay_admin_base_protocol'>&nbsp</a> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="headtext" width="30%" align="left" valign="top">pay_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">此表paycenter的代碼構造數據表用于記載該網站所包含的控制器方法名下對應的日志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">pay_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">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> <tr> <td align="left" valign="top">pay_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">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='pay_admin_log_action'>&nbsp</a> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="headtext" width="30%" align="left" valign="top">pay_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">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_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">日志表所有payceneter的日志在這邊表里，里面有每個用戶user_id對應某個操作action_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">pay_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">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> <tr> <td align="left" valign="top">pay_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">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='pay_admin_rights_group'>&nbsp</a> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="headtext" width="30%" align="left" valign="top">pay_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">Payceneter后臺權限組列表，后臺的權限分組設置的名稱rights_group_name，描述rights_group_rights_ids以及創作的時間rights_group_add_time</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">pay_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">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='pay_admin_user_base'>&nbsp</a> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="headtext" width="30%" align="left" valign="top">pay_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)</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"> </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_realname</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">用戶真實姓名</td> </tr> <tr> <td align="left" valign="top">user_nickname</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">(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_mobile</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">user_email</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">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">user_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">user_delete</td> <td align="left" valign="top">tinyint(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">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">user_admin</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">是否管理員 0:不是</td> </tr> <tr> <td align="left" valign="top">server_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">(NULL)</td> <td align="left" valign="top"> </td> <td align="left" valign="top">select,insert,update,references</td> <td align="left" valign="top">服務id-公司關聯-關聯數據庫-key中</td> </tr> <tr> <td align="left" valign="top">說明：</td> <td align="left" valign="top" colspan="8">Payceneter的用戶信息表rights_group_id是該用戶所在的權限分組的id即pay_admin_rights_group 表對應的信息 user_delete是平臺對于該用戶的禁止和解禁的操作禁止該用戶不能登錄買單</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">pay_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">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='pay_admin_web_config'>&nbsp</a> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="headtext" width="30%" align="left" valign="top">pay_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">Paycenter 公共參數表如狀態的開啟，參數key對應的value的存儲config_key公共參數key的值公共參數config_key對應的config_value值改鍵值對key =》 value 對應的狀態 config_enable</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">pay_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">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> <tr> <td align="left" valign="top">pay_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">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">(null)</td> </tr> <tr> <td align="left" valign="top">pay_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">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">(null)</td> </tr> </table>