🔥码云GVP开源项目 12k star Uniapp+ElementUI 功能强大 支持多语言、二开方便! 广告
# ucenter\_admin ucenter\_admin - [ucenter\_admin\_base\_protocol](#ucenter_admin_base_protocol) - [ucenter\_admin\_log\_action](#ucenter_admin_log_action) - [ucenter\_admin\_rights\_group](#ucenter_admin_rights_group) - [ucenter\_admin\_user\_base](#ucenter_admin_user_base) - [ucenter\_admin\_web\_config](#ucenter_admin_web_config) ucenter\_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 commentucenter\_admin\_base\_protocol 0 PRIMARY 1 protocol\_id A 0 (NULL) (NULL) BTREE ucenter\_admin\_base\_protocol 0 cmd\_id\_key 1 cmd\_id A 0 (NULL) (NULL) BTREE [Back](#header) ucenter\_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 commentucenter\_admin\_log\_action 0 PRIMARY 1 log\_id A 6310 (NULL) (NULL) BTREE ucenter\_admin\_log\_action 1 player\_id 1 user\_id A 6 (NULL) (NULL) BTREE [Back](#header) ucenter\_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 commentucenter\_admin\_rights\_group 0 PRIMARY 1 rights\_group\_id A 0 (NULL) (NULL) BTREE [Back](#header) ucenter\_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 commentucenter\_admin\_user\_base 0 PRIMARY 1 user\_id A 2 (NULL) (NULL) BTREE [Back](#header) ucenter\_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 commentucenter\_admin\_web\_config 0 PRIMARY 1 config\_key A 4 (NULL) (NULL) BTREE ucenter\_admin\_web\_config 1 index 1 config\_key A 4 (NULL) (NULL) BTREE (null) ucenter\_admin\_web\_config 1 index 2 config\_type A 4 (NULL) (NULL) BTREE (null)