paycenter_admin · 英文版開發文檔

# paycenter\_admin paycenter\_admin - [pay\_admin\_base\_protocol](#pay_admin_base_protocol) - [pay\_admin\_log\_action](#pay_admin_log_action) - [pay\_admin\_rights\_group](#pay_admin_rights_group) - [pay\_admin\_user\_base](#pay_admin_user_base) - [pay\_admin\_web\_config](#pay_admin_web_config) pay\_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 commentpay\_admin\_base\_protocol 0 PRIMARY 1 protocol\_id A 0 (NULL) (NULL) BTREE pay\_admin\_base\_protocol 0 cmd\_id\_key 1 cmd\_id A 0 (NULL) (NULL) BTREE [Back](#header) pay\_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 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\_time timestamp (NULL) NO CURRENT\_TIMESTAMP select,insert,update,references 記錄時間 IndexesTableNon uniqueKey nameSeq in indexColumn nameCollationCardinalitySub partPackedNullIndex typeCommentIndex commentpay\_admin\_log\_action 0 PRIMARY 1 log\_id A 0 (NULL) (NULL) BTREE pay\_admin\_log\_action 1 player\_id 1 user\_id A 0 (NULL) (NULL) BTREE [Back](#header) pay\_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 commentpay\_admin\_rights\_group 0 PRIMARY 1 rights\_group\_id A 0 (NULL) (NULL) BTREE [Back](#header) pay\_admin\_user\_base FieldsFieldTypeCollationNullKeyDefaultExtraPrivilegesCommentuser\_id mediumint(8) (NULL) NO PRI (NULL) auto\_increment select,insert,update,references 用戶id user\_account varchar(50) utf8\_general\_ci NO (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\_realname varchar(32) utf8\_general\_ci NO (NULL) select,insert,update,references 用戶真實姓名 user\_nickname varchar(30) utf8\_general\_ci NO (NULL) select,insert,update,references 用戶昵稱 user\_mobile varchar(20) utf8\_general\_ci NO (NULL) select,insert,update,references 用戶手機號 user\_email varchar(100) utf8\_general\_ci NO (NULL) select,insert,update,references 用戶密碼 rights\_group\_id smallint(4) (NULL) NO (NULL) select,insert,update,references 用戶權限組id user\_rights\_ids text utf8\_general\_ci NO (NULL) select,insert,update,references 用戶權限 user\_delete tinyint(4) (NULL) NO 0 select,insert,update,references 是否被封禁 0:未被封禁 1:被封禁 user\_admin tinyint(1) (NULL) NO 0 select,insert,update,references 是否管理員 0:不是 server\_id mediumint(8) (NULL) NO (NULL) select,insert,update,references 服務id-公司關聯-關聯數據庫-key中 IndexesTableNon uniqueKey nameSeq in indexColumn nameCollationCardinalitySub partPackedNullIndex typeCommentIndex commentpay\_admin\_user\_base 0 PRIMARY 1 user\_id A 0 (NULL) (NULL) BTREE [Back](#header) pay\_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 commentpay\_admin\_web\_config 0 PRIMARY 1 config\_key A 4 (NULL) (NULL) BTREE pay\_admin\_web\_config 1 index 1 config\_key A 4 (NULL) (NULL) BTREE (null) pay\_admin\_web\_config 1 index 2 config\_type A 4 (NULL) (NULL) BTREE (null)