shop_admin · 英文版開發文檔

# shop\_admin shop\_admin - [yf\_admin\_base\_protocol](#yf_admin_base_protocol) - [yf\_admin\_log\_action](#yf_admin_log_action) - [yf\_admin\_menu](#yf_admin_menu) - [yf\_admin\_rights\_base](#yf_admin_rights_base) - [yf\_admin\_rights\_data\_type](#yf_admin_rights_data_type) - [yf\_admin\_rights\_group](#yf_admin_rights_group) - [yf\_admin\_user\_base](#yf_admin_user_base) - [yf\_admin\_user\_info](#yf_admin_user_info) - [yf\_admin\_user\_rights\_data](#yf_admin_user_rights_data) - [yf\_admin\_web\_config](#yf_admin_web_config) yf\_admin\_base\_protocol FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentprotocol\_id mediumint(8) (NULL) NO PRI (NULL) auto\_increment select,insert,update,references 協議索引Id cmd\_id smallint(4) (NULL) NO UNI 0 select,insert,update,references 協議Id ctl varchar(50) utf8\_general\_ci NO select,insert,update,references 控制器類名稱 met varchar(50) utf8\_general\_ci NO select,insert,update,references 控制器方法 db enum('master','slave') utf8\_general\_ci NO master select,insert,update,references 連接數據庫類型 typ enum('e','json','msgpcak','amf') utf8\_general\_ci NO json select,insert,update,references 輸出數據默認類型 rights\_id mediumint(20) (NULL) NO (NULL) select,insert,update,references 權限Id log tinyint(1) (NULL) NO 0 select,insert,update,references 是否記錄日志 struct varchar(100) utf8\_general\_ci NO select,insert,update,references 生成結構體，獨立使用 comment varchar(255) utf8\_general\_ci NO select,insert,update,references 注釋 0 varchar(255) utf8\_general\_ci NO int16\_t:cmd\_id select,insert,update,references 第一個字段 1 varchar(255) utf8\_general\_ci NO select,insert,update,references 2 varchar(255) utf8\_general\_ci NO select,insert,update,references 3 varchar(255) utf8\_general\_ci NO select,insert,update,references 4 varchar(255) utf8\_general\_ci NO select,insert,update,references 5 varchar(255) utf8\_general\_ci NO select,insert,update,references 6 varchar(255) utf8\_general\_ci NO select,insert,update,references 7 varchar(255) utf8\_general\_ci NO select,insert,update,references 8 varchar(255) utf8\_general\_ci NO select,insert,update,references 9 varchar(255) utf8\_general\_ci NO select,insert,update,references 10 varchar(255) utf8\_general\_ci NO select,insert,update,references 11 varchar(255) utf8\_general\_ci NO select,insert,update,references 12 varchar(255) utf8\_general\_ci NO select,insert,update,references 13 varchar(255) utf8\_general\_ci NO select,insert,update,references 14 varchar(255) utf8\_general\_ci NO select,insert,update,references 15 varchar(255) utf8\_general\_ci NO select,insert,update,references 16 varchar(255) utf8\_general\_ci NO select,insert,update,references 17 varchar(255) utf8\_general\_ci NO select,insert,update,references 18 varchar(255) utf8\_general\_ci NO select,insert,update,references 19 varchar(255) utf8\_general\_ci NO select,insert,update,references 20 varchar(255) utf8\_general\_ci NO select,insert,update,references 21 varchar(255) utf8\_general\_ci NO select,insert,update,references 22 varchar(255) utf8\_general\_ci NO select,insert,update,references 23 varchar(255) utf8\_general\_ci NO select,insert,update,references 24 varchar(255) utf8\_general\_ci NO select,insert,update,references 25 varchar(255) utf8\_general\_ci NO select,insert,update,references 26 varchar(255) utf8\_general\_ci NO select,insert,update,references 27 varchar(255) utf8\_general\_ci NO select,insert,update,references 28 varchar(255) utf8\_general\_ci NO select,insert,update,references 29 varchar(255) utf8\_general\_ci NO select,insert,update,references 30 varchar(255) utf8\_general\_ci NO select,insert,update,references 31 varchar(255) utf8\_general\_ci NO select,insert,update,references 32 varchar(255) utf8\_general\_ci NO select,insert,update,references 33 varchar(255) utf8\_general\_ci NO select,insert,update,references 34 varchar(255) utf8\_general\_ci NO select,insert,update,references IndexesTableNon uniqueKey nameSeq in indexColumn nameCollationCardinalitySub partPackedNullIndex typeCommentIndex commentyf\_admin\_base\_protocol 0 PRIMARY 1 protocol\_id A 326 (NULL) (NULL) BTREE yf\_admin\_base\_protocol 0 cmd\_id\_key 1 cmd\_id A 326 (NULL) (NULL) BTREE [Back](#header) yf\_admin\_log\_action FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentlog\_id int(11) (NULL) NO PRI (NULL) auto\_increment select,insert,update,references 日志id user\_id mediumint(8) (NULL) NO MUL 0 select,insert,update,references 玩家Id user\_account varchar(100) utf8\_general\_ci NO select,insert,update,references 角色賬戶 user\_name varchar(20) utf8\_general\_ci NO select,insert,update,references 角色名稱 action\_id mediumint(8) (NULL) NO 0 select,insert,update,references 行為id == protocal\_id -> rights\_id action\_type\_id mediumint(9) (NULL) NO (NULL) select,insert,update,references 操作類型id，right\_parent\_id log\_param text utf8\_general\_ci NO (NULL) select,insert,update,references 請求的參數 log\_ip varchar(20) utf8\_general\_ci NO select,insert,update,references log\_date date (NULL) NO MUL (NULL) select,insert,update,references 日志日期 log\_time timestamp (NULL) NO CURRENT\_TIMESTAMP select,insert,update,references 記錄時間 IndexesTableNon uniqueKey nameSeq in indexColumn nameCollationCardinalitySub partPackedNullIndex typeCommentIndex commentyf\_admin\_log\_action 0 PRIMARY 1 log\_id A 71776 (NULL) (NULL) BTREE yf\_admin\_log\_action 1 player\_id 1 user\_id A 12 (NULL) (NULL) BTREE yf\_admin\_log\_action 1 log\_date 1 log\_date A 290 (NULL) (NULL) BTREE [Back](#header) yf\_admin\_menu FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentmenu\_id int(10) (NULL) NO PRI (NULL) auto\_increment select,insert,update,references 菜單id menu\_parent\_id int(10) (NULL) NO 0 select,insert,update,references 菜單id menu\_name varchar(20) utf8\_general\_ci NO (NULL) select,insert,update,references 菜單名稱 menu\_icon varchar(255) utf8\_general\_ci NO select,insert,update,references 圖標class rights\_id int(10) unsigned (NULL) NO 0 select,insert,update,references 權限id menu\_url\_ctl varchar(30) utf8\_general\_ci NO select,insert,update,references 控制器名稱 menu\_url\_met varchar(20) utf8\_general\_ci NO select,insert,update,references 控制器方法 menu\_url\_parem varchar(50) utf8\_general\_ci NO select,insert,update,references url參數 menu\_url\_note varchar(255) utf8\_general\_ci NO select,insert,update,references 頁面幫助內容 menu\_order tinyint(4) unsigned (NULL) NO 50 select,insert,update,references 排序 menu\_time datetime (NULL) NO 0000-00-00 00:00:00 select,insert,update,references 最后更新時間 IndexesTableNon uniqueKey nameSeq in indexColumn nameCollationCardinalitySub partPackedNullIndex typeCommentIndex commentyf\_admin\_menu 0 PRIMARY 1 menu\_id A 228 (NULL) (NULL) BTREE [Back](#header) yf\_admin\_rights\_base FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentrights\_id smallint(4) unsigned (NULL) NO PRI (NULL) auto\_increment select,insert,update,references 權限Id rights\_name varchar(20) utf8\_general\_ci NO select,insert,update,references 權限名稱 rights\_parent\_id smallint(4) unsigned (NULL) NO (NULL) select,insert,update,references 權限父Id rights\_remark varchar(255) utf8\_general\_ci NO (NULL) select,insert,update,references 備注 rights\_order smallint(4) (NULL) NO 50 select,insert,update,references 排序 IndexesTableNon uniqueKey nameSeq in indexColumn nameCollationCardinalitySub partPackedNullIndex typeCommentIndex commentyf\_admin\_rights\_base 0 PRIMARY 1 rights\_id A 385 (NULL) (NULL) BTREE [Back](#header) yf\_admin\_rights\_data\_type FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentrights\_data\_type\_id mediumint(6) unsigned (NULL) NO PRI (NULL) auto\_increment select,insert,update,references 權限數據類型id rights\_data\_type\_name varchar(50) utf8\_general\_ci NO (NULL) select,insert,update,references 權限數據類型名稱 rights\_data\_type\_primary\_key text utf8\_general\_ci NO (NULL) select,insert,update,references 數據主鍵 IndexesTableNon uniqueKey nameSeq in indexColumn nameCollationCardinalitySub partPackedNullIndex typeCommentIndex commentyf\_admin\_rights\_data\_type 0 PRIMARY 1 rights\_data\_type\_id A 0 (NULL) (NULL) BTREE [Back](#header) yf\_admin\_rights\_group FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentrights\_group\_id smallint(4) unsigned (NULL) NO PRI (NULL) auto\_increment select,insert,update,references 權限組id rights\_group\_name varchar(50) utf8\_general\_ci NO (NULL) select,insert,update,references 權限組名稱 rights\_group\_rights\_ids text utf8\_general\_ci NO (NULL) select,insert,update,references 權限列表 rights\_group\_add\_time int(10) (NULL) NO (NULL) select,insert,update,references 創建時間 IndexesTableNon uniqueKey nameSeq in indexColumn nameCollationCardinalitySub partPackedNullIndex typeCommentIndex commentyf\_admin\_rights\_group 0 PRIMARY 1 rights\_group\_id A 4 (NULL) (NULL) BTREE [Back](#header) yf\_admin\_user\_base FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentuser\_id mediumint(8) unsigned (NULL) NO PRI (NULL) auto\_increment select,insert,update,references 用戶id user\_account varchar(50) utf8\_general\_ci NO UNI (NULL) select,insert,update,references 用戶帳號 user\_password char(32) utf8\_general\_ci NO (NULL) select,insert,update,references 密碼：使用用戶中心-此處廢棄 user\_key varchar(32) utf8\_general\_ci NO (NULL) select,insert,update,references 用戶Key user\_delete tinyint(4) unsigned (NULL) NO 0 select,insert,update,references 是否被封禁，0：未封禁，1：封禁 rights\_group\_id smallint(4) (NULL) NO (NULL) select,insert,update,references 用戶權限組id sub\_site\_id int(11) (NULL) NO 0 select,insert,update,references 所屬子站， 0總站 IndexesTableNon uniqueKey nameSeq in indexColumn nameCollationCardinalitySub partPackedNullIndex typeCommentIndex commentyf\_admin\_user\_base 0 PRIMARY 1 user\_id A 9 (NULL) (NULL) BTREE yf\_admin\_user\_base 0 user\_account 1 user\_account A 9 (NULL) (NULL) BTREE [Back](#header) yf\_admin\_user\_info FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentuser\_id mediumint(8) (NULL) NO PRI (NULL) select,insert,update,references 用戶id user\_nickname varchar(100) utf8\_general\_ci NO (NULL) select,insert,update,references 昵稱 IndexesTableNon uniqueKey nameSeq in indexColumn nameCollationCardinalitySub partPackedNullIndex typeCommentIndex commentyf\_admin\_user\_info 0 PRIMARY 1 user\_id A 0 (NULL) (NULL) BTREE [Back](#header) yf\_admin\_user\_rights\_data FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentuser\_rights\_data\_id mediumint(8) unsigned (NULL) NO PRI 0 select,insert,update,references user\_id mediumint(8) unsigned (NULL) NO (NULL) select,insert,update,references 用戶id user\_rights\_data\_value mediumint(8) (NULL) NO (NULL) select,insert,update,references 主鍵值 rights\_data\_type\_id mediumint(8) unsigned (NULL) NO 0 select,insert,update,references 權限類型Id IndexesTableNon uniqueKey nameSeq in indexColumn nameCollationCardinalitySub partPackedNullIndex typeCommentIndex commentyf\_admin\_user\_rights\_data 0 PRIMARY 1 user\_rights\_data\_id A 0 (NULL) (NULL) BTREE [Back](#header) yf\_admin\_web\_config FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentconfig\_key varchar(50) utf8\_general\_ci NO PRI (NULL) select,insert,update,references 數組下標 config\_value text utf8\_general\_ci NO (NULL) select,insert,update,references 數組值 config\_type varchar(50) utf8\_general\_ci NO (NULL) select,insert,update,references config\_enable tinyint(1) (NULL) NO 1 select,insert,update,references 狀態值，1可能，0不可用 config\_comment text utf8\_general\_ci NO (NULL) select,insert,update,references config\_datatype enum('string','json','number') utf8\_general\_ci NO string select,insert,update,references 數據類型 IndexesTableNon uniqueKey nameSeq in indexColumn nameCollationCardinalitySub partPackedNullIndex typeCommentIndex commentyf\_admin\_web\_config 0 PRIMARY 1 config\_key A 5 (NULL) (NULL) BTREE yf\_admin\_web\_config 1 index 1 config\_key A 5 (NULL) (NULL) BTREE yf\_admin\_web\_config 1 index 2 config\_type A 5 (NULL) (NULL) BTREE