说明
检查是否发生了变化, 有效变更, 无法变更
请求地址
/v2/webservice/table/compare-file-with-all-table
请求参数
| 参数名称 | 类型 | 是否必填 | 说明 |
|---|---|---|---|
| app_id | int | 是 | 业务ID |
| attach_ids | array | 是 | 文件ID |
| zone_id | int | 是 | 游戏区ID |
TABLES对象
| 参数名称 | 类型 | 是否必填 | 说明 |
|---|---|---|---|
| zone_id | 数组, 元素为 int | 是 | |
| table_names | 数组, 元素为 string | 是 |
示例
{ "attach_ids":[619], "app_id":2, "zone_id":3
}
返回
| 参数名称 | 类型 | 说明 |
|---|---|---|
| code | ||
| data | tables数组 | |
| request_id |
tables子元素
| 参数名称 | 类型 | 说明 |
|---|---|---|
| app_id | int | 表名 |
| zones | 数组 元素为 Zones对象 | [ 0 ] 表示generic表[ 1 ]表是list表,[0, 1] 表示这两种表类型都可以加 |
CheckResult对象
| 参数名称 | 类型 | 说明 |
|---|---|---|
| zone_id | int | |
| check_result | 数组 , 元素为CheckResult |
CheckResult对象
| 参数名称 | 类型 | 说明 |
|---|---|---|
| invaild_modify_table | 数组 , 元素为TableInfo | 无效的表变更, 比如新字段的version值错误 |
| same_field_table | 数组 , 元素为TableInfo | 没有发生变更的表 |
| diff_field_table | 数组 , 元素为TableInfo | 发生了变更的表 |
TableInfo对象
| 参数名称 | 类型 | 说明 |
|---|---|---|
| table_name | string |
invaild_modify_table 和 diff_field_table 为空表示,此文件是当前游戏区下的最新表结构
示例
{
"code": 0,
"request_id": "8ae9786a-5992-4164-9bae-8de1a6e5d35e",
"data": {
"app_id": 2,
"zone_id": 3,
"invaild_modify_table": [
{
"status": -1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": true,
"table_field_changed": 0,
"err_msg": "Get meta info failed, please check the table name ! table:'test_table'",
"message": "",
"table_name": "test_table",
"table_type": 0
},
{
"status": -1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": true,
"table_field_changed": 0,
"err_msg": "Get meta info failed, please check the table name ! table:'T_AI_DATA'",
"message": "",
"table_name": "T_AI_DATA",
"table_type": 0
},
{
"status": -1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": true,
"table_field_changed": 0,
"err_msg": "Get meta info failed, please check the table name ! table:'T_CDKEY_LIST'",
"message": "",
"table_name": "T_CDKEY_LIST",
"table_type": 0
},
{
"status": -1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": true,
"table_field_changed": 0,
"err_msg": "Get meta info failed, please check the table name ! table:'T_CHESS_COMMENT'",
"message": "",
"table_name": "T_CHESS_COMMENT",
"table_type": 0
},
{
"status": -1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": true,
"table_field_changed": 0,
"err_msg": "Get meta info failed, please check the table name ! table:'T_CHESS_THUMB'",
"message": "",
"table_name": "T_CHESS_THUMB",
"table_type": 0
},
{
"status": -1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": true,
"table_field_changed": 0,
"err_msg": "Get meta info failed, please check the table name ! table:'T_CLAN_GLOBAL_INFO'",
"message": "",
"table_name": "T_CLAN_GLOBAL_INFO",
"table_type": 0
},
{
"status": -1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": true,
"table_field_changed": 0,
"err_msg": "Get meta info failed, please check the table name ! table:'T_CLAN_ID_INFO'",
"message": "",
"table_name": "T_CLAN_ID_INFO",
"table_type": 0
},
{
"status": -1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": true,
"table_field_changed": 0,
"err_msg": "Get meta info failed, please check the table name ! table:'T_CLAN_MEMBERS'",
"message": "",
"table_name": "T_CLAN_MEMBERS",
"table_type": 0
},
{
"status": -1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": true,
"table_field_changed": 0,
"err_msg": "Get meta info failed, please check the table name ! table:'T_CLAN_NAME_INFO'",
"message": "",
"table_name": "T_CLAN_NAME_INFO",
"table_type": 0
},
{
"status": -1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": true,
"table_field_changed": 0,
"err_msg": "Get meta info failed, please check the table name ! table:'T_CLAN_UIN_CLAN'",
"message": "",
"table_name": "T_CLAN_UIN_CLAN",
"table_type": 0
},
{
"status": -1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": true,
"table_field_changed": 0,
"err_msg": "Get meta info failed, please check the table name ! table:'T_COMMENT_LIST'",
"message": "",
"table_name": "T_COMMENT_LIST",
"table_type": 1
},
{
"status": -1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": true,
"table_field_changed": 0,
"err_msg": "Get meta info failed, please check the table name ! table:'T_COUNT_LIST'",
"message": "",
"table_name": "T_COUNT_LIST",
"table_type": 0
},
{
"status": -1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": true,
"table_field_changed": 0,
"err_msg": "Get meta info failed, please check the table name ! table:'T_CREDIT_FORBID_LIST'",
"message": "",
"table_name": "T_CREDIT_FORBID_LIST",
"table_type": 1
},
{
"status": -1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": true,
"table_field_changed": 0,
"err_msg": "Get meta info failed, please check the table name ! table:'T_CREDIT_RECORD_LIST'",
"message": "",
"table_name": "T_CREDIT_RECORD_LIST",
"table_type": 1
},
{
"status": -1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": true,
"table_field_changed": 0,
"err_msg": "Get meta info failed, please check the table name ! table:'T_CREDIT_REPORT_LIST'",
"message": "",
"table_name": "T_CREDIT_REPORT_LIST",
"table_type": 1
},
{
"status": -1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": true,
"table_field_changed": 0,
"err_msg": "Get meta info failed, please check the table name ! table:'T_CREDIT_SUSPEND_LIST'",
"message": "",
"table_name": "T_CREDIT_SUSPEND_LIST",
"table_type": 1
},
{
"status": -1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": true,
"table_field_changed": 0,
"err_msg": "Get meta info failed, please check the table name ! table:'T_FRIEND_REQ_LIST'",
"message": "",
"table_name": "T_FRIEND_REQ_LIST",
"table_type": 0
},
{
"status": -1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": true,
"table_field_changed": 0,
"err_msg": "Get meta info failed, please check the table name ! table:'T_GAME_RECORD_INFO'",
"message": "",
"table_name": "T_GAME_RECORD_INFO",
"table_type": 0
},
{
"status": -1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": true,
"table_field_changed": 0,
"err_msg": "Get meta info failed, please check the table name ! table:'T_GOD_BATTLE_ARRAY'",
"message": "",
"table_name": "T_GOD_BATTLE_ARRAY",
"table_type": 0
},
{
"status": -1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": true,
"table_field_changed": 0,
"err_msg": "Get meta info failed, please check the table name ! table:'T_ID_INFO'",
"message": "",
"table_name": "T_ID_INFO",
"table_type": 0
},
{
"status": -1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": true,
"table_field_changed": 0,
"err_msg": "Get meta info failed, please check the table name ! table:'T_INNER_FRIEND_LIST'",
"message": "",
"table_name": "T_INNER_FRIEND_LIST",
"table_type": 0
},
{
"status": -1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": true,
"table_field_changed": 0,
"err_msg": "Get meta info failed, please check the table name ! table:'T_KV_INFO'",
"message": "",
"table_name": "T_KV_INFO",
"table_type": 0
},
{
"status": -1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": true,
"table_field_changed": 0,
"err_msg": "Get meta info failed, please check the table name ! table:'T_MAIL_LIST'",
"message": "",
"table_name": "T_MAIL_LIST",
"table_type": 1
},
{
"status": -1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": true,
"table_field_changed": 0,
"err_msg": "Get meta info failed, please check the table name ! table:'T_MENTORSHIP'",
"message": "",
"table_name": "T_MENTORSHIP",
"table_type": 0
},
{
"status": -1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": true,
"table_field_changed": 0,
"err_msg": "Get meta info failed, please check the table name ! table:'T_MENTORSHIP_MSG_LIST'",
"message": "",
"table_name": "T_MENTORSHIP_MSG_LIST",
"table_type": 1
},
{
"status": -1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": true,
"table_field_changed": 0,
"err_msg": "Get meta info failed, please check the table name ! table:'T_NAME_INFO'",
"message": "",
"table_name": "T_NAME_INFO",
"table_type": 0
},
{
"status": -1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": true,
"table_field_changed": 0,
"err_msg": "Get meta info failed, please check the table name ! table:'T_OFFLINE_MSG_LIST'",
"message": "",
"table_name": "T_OFFLINE_MSG_LIST",
"table_type": 1
},
{
"status": -1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": true,
"table_field_changed": 0,
"err_msg": "Get meta info failed, please check the table name ! table:'T_ONLINE_INFO'",
"message": "",
"table_name": "T_ONLINE_INFO",
"table_type": 0
},
{
"status": -1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": true,
"table_field_changed": 0,
"err_msg": "Get meta info failed, please check the table name ! table:'T_PEAK_HISTORY_RANK'",
"message": "",
"table_name": "T_PEAK_HISTORY_RANK",
"table_type": 0
},
{
"status": -1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": true,
"table_field_changed": 0,
"err_msg": "Get meta info failed, please check the table name ! table:'T_PLAT_FRIEND_LIST'",
"message": "",
"table_name": "T_PLAT_FRIEND_LIST",
"table_type": 1
},
{
"status": -1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": true,
"table_field_changed": 0,
"err_msg": "Get meta info failed, please check the table name ! table:'T_PLAYER_INFO'",
"message": "",
"table_name": "T_PLAYER_INFO",
"table_type": 0
},
{
"status": -1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": true,
"table_field_changed": 0,
"err_msg": "Get meta info failed, please check the table name ! table:'T_PLAYER_STATISTICS'",
"message": "",
"table_name": "T_PLAYER_STATISTICS",
"table_type": 0
},
{
"status": -1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": true,
"table_field_changed": 0,
"err_msg": "Get meta info failed, please check the table name ! table:'T_RANK_REWARD'",
"message": "",
"table_name": "T_RANK_REWARD",
"table_type": 0
},
{
"status": -1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": true,
"table_field_changed": 0,
"err_msg": "Get meta info failed, please check the table name ! table:'T_RANK_REWARD_PLAYER'",
"message": "",
"table_name": "T_RANK_REWARD_PLAYER",
"table_type": 0
},
{
"status": -1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": true,
"table_field_changed": 0,
"err_msg": "Get meta info failed, please check the table name ! table:'T_RECENT'",
"message": "",
"table_name": "T_RECENT",
"table_type": 0
},
{
"status": -1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": true,
"table_field_changed": 0,
"err_msg": "Get meta info failed, please check the table name ! table:'T_REGIST_LIMIT_INFO'",
"message": "",
"table_name": "T_REGIST_LIMIT_INFO",
"table_type": 0
},
{
"status": -1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": true,
"table_field_changed": 0,
"err_msg": "Get meta info failed, please check the table name ! table:'T_ROLE_INFO'",
"message": "",
"table_name": "T_ROLE_INFO",
"table_type": 0
},
{
"status": -1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": true,
"table_field_changed": 0,
"err_msg": "Get meta info failed, please check the table name ! table:'T_UIN_2_OPENID'",
"message": "",
"table_name": "T_UIN_2_OPENID",
"table_type": 0
},
{
"status": -1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": true,
"table_field_changed": 0,
"err_msg": "Get meta info failed, please check the table name ! table:'T_UIN_MASK_INFO'",
"message": "",
"table_name": "T_UIN_MASK_INFO",
"table_type": 0
}
],
"same_field_table": [
{
"status": 1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": false,
"table_field_changed": 0,
"err_msg": "",
"message": "",
"table_name": "tbAuctionData",
"table_type": 0
},
{
"status": 1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": false,
"table_field_changed": 0,
"err_msg": "",
"message": "",
"table_name": "tbBattle3v3Team",
"table_type": 0
},
{
"status": 1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": false,
"table_field_changed": 0,
"err_msg": "",
"message": "",
"table_name": "tbBonusData",
"table_type": 0
},
{
"status": 1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": false,
"table_field_changed": 0,
"err_msg": "",
"message": "",
"table_name": "tbCityWarData",
"table_type": 0
},
{
"status": 1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": false,
"table_field_changed": 0,
"err_msg": "",
"message": "",
"table_name": "tbConquestWorldRoleData",
"table_type": 0
},
{
"status": 1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": false,
"table_field_changed": 0,
"err_msg": "",
"message": "",
"table_name": "tbConsignmentData",
"table_type": 0
},
{
"status": 1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": false,
"table_field_changed": 0,
"err_msg": "",
"message": "",
"table_name": "tbCountryData",
"table_type": 0
},
{
"status": 1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": false,
"table_field_changed": 0,
"err_msg": "",
"message": "",
"table_name": "tbFamilyData",
"table_type": 0
},
{
"status": 1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": false,
"table_field_changed": 0,
"err_msg": "",
"message": "",
"table_name": "tbFusangUnionData",
"table_type": 0
},
{
"status": 1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": false,
"table_field_changed": 0,
"err_msg": "",
"message": "",
"table_name": "tbGroupAttrData",
"table_type": 0
},
{
"status": 1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": false,
"table_field_changed": 0,
"err_msg": "",
"message": "",
"table_name": "tbJieYiData",
"table_type": 0
},
{
"status": 1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": false,
"table_field_changed": 0,
"err_msg": "",
"message": "",
"table_name": "tbMailData",
"table_type": 0
},
{
"status": 1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": false,
"table_field_changed": 0,
"err_msg": "",
"message": "",
"table_name": "tbMirroRoleData",
"table_type": 0
},
{
"status": 1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": false,
"table_field_changed": 0,
"err_msg": "",
"message": "",
"table_name": "tbMoneyConsignmentData",
"table_type": 0
},
{
"status": 1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": false,
"table_field_changed": 0,
"err_msg": "",
"message": "",
"table_name": "tbOfflineMsg",
"table_type": 0
},
{
"status": 1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": false,
"table_field_changed": 0,
"err_msg": "",
"message": "",
"table_name": "tbPreServerApplyData",
"table_type": 0
},
{
"status": 1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": false,
"table_field_changed": 0,
"err_msg": "",
"message": "",
"table_name": "tbRankData",
"table_type": 0
},
{
"status": 1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": false,
"table_field_changed": 0,
"err_msg": "",
"message": "",
"table_name": "tbRoleData",
"table_type": 0
},
{
"status": 1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": false,
"table_field_changed": 0,
"err_msg": "",
"message": "",
"table_name": "tbSgzCityData",
"table_type": 0
},
{
"status": 1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": false,
"table_field_changed": 0,
"err_msg": "",
"message": "",
"table_name": "tbSgzLegionData",
"table_type": 0
},
{
"status": 1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": false,
"table_field_changed": 0,
"err_msg": "",
"message": "",
"table_name": "tbVoiceRoom",
"table_type": 0
},
{
"status": 1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": false,
"table_field_changed": 0,
"err_msg": "",
"message": "",
"table_name": "tbWarData",
"table_type": 0
},
{
"status": 1,
"new_entry_length_exceeded_count": 0,
"new_entry_length_exceeded": [],
"has_new_entry_count_without_refer": false,
"table_field_changed": 0,
"err_msg": "",
"message": "",
"table_name": "tbWorldAttr",
"table_type": 0
}
],
"diff_field_table": []
}
}