请求地址
/v2/webservice/table/compare-zone-tables-with-other-zone
描述：
选择一个区为基准区，比较此区和其他区多了哪些表，缺少什么表，表结构是相同的表，表结构不同的表。pb和xml类型的同名表标识为表结构不一致的表
请求方法
Post
请求参数说明
| 参数名称 | 类型 | 是否必填 | 说明 |
|---|---|---|---|
| app_id | number | 是 | |
| base_zone_id | number | 是 | 基准游戏区 |
| compared_zone_ids | number[] | 是 | 其他游戏区 |
示例
{
"app_id": 5,
"base_zone_id": 1,
"compared_zone_ids": [
2
]
}
返回参数Data结构说明
| 参数名称 | 类型 | 说明 |
|---|---|---|
| app_id | number | 项目ID |
| base_zone_info | object | 基准表的基本信息 |
| compare_result | objectCompareResult | 比较结果 |
CompareResult
| 参数名称 | 类型 | 说明 |
|---|---|---|
| zone_id | number | 区ID |
| table_total | number | 表总数 |
| lack_tables | 数组 | 缺少的表 |
| extra_tables | 数组 | 多出的表 |
| same_struct_tables | 数组 | 结构相同的表 |
| diff_struct_tables | 数组 | 结构不同的表 |
成功返回
{
"code": 0,
"request_id": "36301aad-c6f6-4a57-80c9-63df1db43774",
"data": {
"app_id": 5,
"base_zone_info": {
"zone_id": 1,
"tables": [
{
"table_name": "GenericTableDemo",
"table_type": 0,
"table_maxnum": 0,
"fmt_type": "tdr",
"attach_ids": [
"945"
]
},
{
"table_name": "ItemAttri",
"table_type": 0,
"table_maxnum": 0,
"fmt_type": "tdr",
"attach_ids": [
"944"
]
},
{
"table_name": "ListTableDemo",
"table_type": 1,
"table_maxnum": 1023,
"fmt_type": "tdr",
"attach_ids": [
"905"
]
},
{
"table_name": "pb2_webclient_generic",
"table_type": 0,
"table_maxnum": 0,
"fmt_type": "proto",
"attach_ids": [
"906",
"907",
"908"
]
},
{
"table_name": "pb2_webclient_list",
"table_type": 1,
"table_maxnum": 1900,
"fmt_type": "proto",
"attach_ids": [
"883",
"884",
"885"
]
},
{
"table_name": "pb2_webclient_sortlist",
"table_type": 1,
"table_maxnum": 1900,
"fmt_type": "proto",
"attach_ids": [
"883",
"884",
"885"
]
},
{
"table_name": "pb_generic_index_noshardkey",
"table_type": 0,
"table_maxnum": 0,
"fmt_type": "proto",
"attach_ids": [
"883",
"884",
"885"
]
},
{
"table_name": "pb_generic_noindex_noshardkey",
"table_type": 0,
"table_maxnum": 0,
"fmt_type": "proto",
"attach_ids": [
"883",
"884",
"885"
]
},
{
"table_name": "pb_generic_table",
"table_type": 0,
"table_maxnum": 0,
"fmt_type": "proto",
"attach_ids": [
"911"
]
},
{
"table_name": "table_list",
"table_type": 0,
"table_maxnum": 0,
"fmt_type": "tdr",
"attach_ids": [
"886"
]
},
{
"table_name": "table_list1",
"table_type": 0,
"table_maxnum": 0,
"fmt_type": "tdr",
"attach_ids": [
"886"
]
},
{
"table_name": "table_list2",
"table_type": 0,
"table_maxnum": 0,
"fmt_type": "tdr",
"attach_ids": [
"886"
]
},
{
"table_name": "tb_camp_info",
"table_type": 0,
"table_maxnum": 0,
"fmt_type": "tdr",
"attach_ids": [
"942"
]
},
{
"table_name": "TestData",
"table_type": 0,
"table_maxnum": 0,
"fmt_type": "tdr",
"attach_ids": [
"904"
]
},
{
"table_name": "T_PEAK_HISTORY_RANK",
"table_type": 0,
"table_maxnum": 0,
"fmt_type": "tdr",
"attach_ids": [
"877"
]
}
],
"table_total": 15
},
"compare_result": [
{
"zone_id": 2,
"table_total": 7,
"lack_tables": [
{
"table_name": "GenericTableDemo",
"table_type": 0,
"table_maxnum": 0,
"fmt_type": "tdr",
"attach_ids": [
"945"
]
},
{
"table_name": "ItemAttri",
"table_type": 0,
"table_maxnum": 0,
"fmt_type": "tdr",
"attach_ids": [
"944"
]
},
{
"table_name": "ListTableDemo",
"table_type": 1,
"table_maxnum": 1023,
"fmt_type": "tdr",
"attach_ids": [
"905"
]
},
{
"table_name": "pb2_webclient_generic",
"table_type": 0,
"table_maxnum": 0,
"fmt_type": "proto",
"attach_ids": [
"906",
"907",
"908"
]
},
{
"table_name": "pb_generic_noindex_noshardkey",
"table_type": 0,
"table_maxnum": 0,
"fmt_type": "proto",
"attach_ids": [
"883",
"884",
"885"
]
},
{
"table_name": "table_list",
"table_type": 0,
"table_maxnum": 0,
"fmt_type": "tdr",
"attach_ids": [
"886"
]
},
{
"table_name": "table_list1",
"table_type": 0,
"table_maxnum": 0,
"fmt_type": "tdr",
"attach_ids": [
"886"
]
},
{
"table_name": "tb_camp_info",
"table_type": 0,
"table_maxnum": 0,
"fmt_type": "tdr",
"attach_ids": [
"942"
]
},
{
"table_name": "TestData",
"table_type": 0,
"table_maxnum": 0,
"fmt_type": "tdr",
"attach_ids": [
"904"
]
},
{
"table_name": "T_PEAK_HISTORY_RANK",
"table_type": 0,
"table_maxnum": 0,
"fmt_type": "tdr",
"attach_ids": [
"877"
]
}
],
"extra_tables": [
{
"table_name": "table_generic_xiahuaxian",
"table_type": 0,
"table_maxnum": 0,
"fmt_type": "tdr",
"attach_ids": [
"840",
"841"
]
},
{
"table_name": "tbMailTest",
"table_type": 1,
"table_maxnum": 500,
"fmt_type": "proto",
"attach_ids": [
"883",
"884",
"885"
]
}
],
"same_struct_tables": [
{
"table_name": "pb2_webclient_list",
"table_type": 1,
"table_maxnum": 1900,
"fmt_type": "proto",
"attach_ids": [
"883",
"884",
"885"
]
},
{
"table_name": "pb2_webclient_sortlist",
"table_type": 1,
"table_maxnum": 1900,
"fmt_type": "proto",
"attach_ids": [
"883",
"884",
"885"
]
},
{
"table_name": "pb_generic_index_noshardkey",
"table_type": 0,
"table_maxnum": 0,
"fmt_type": "proto",
"attach_ids": [
"883",
"884",
"885"
]
},
{
"table_name": "table_list2",
"table_type": 0,
"table_maxnum": 0,
"fmt_type": "tdr",
"attach_ids": [
"886"
]
}
],
"diff_struct_tables": [
{
"table_name": "pb_generic_table",
"table_type": 0,
"table_maxnum": 0,
"fmt_type": "proto",
"attach_ids": [
"910"
]
}
]
}
]
}
}