struct_only_tables.txt
1.37 KB
# 抽样镜像里**只搬结构、不搬数据**的表
# 由 sql/tools/gen_migration_sql.py 生成，**不要手改**
# 判据 = 表里存在列名匹配 secret|passwd|password|_aes|aes_|private_key|pulic_key|pub_key|apikey|api_key|sdk_key|sign_key|access_key|accesskey|id_card|idcard|bank_card|bankcard|credential|^token$|_token$
# 为什么：这些表装的是支付/短信/云账号的密钥与口令，
# 抽样会把生产的真实凭据写进**开发机的 dump 文件**。列一行都不搬。
# 判据从严：多判进来只是少几张表的样例行，漏判是密钥落盘。
# 用途：10_dump_legacy.sh 的 SAMPLE= 模式下，数据那一遍 --ignore-table
# 行数=24
zt_bill.t_parking_card
zt_charge.operator_info
zt_order.td_b_wx_config
zt_order.td_c_app_config
zt_order.td_c_cust_person
zt_order.td_c_recharge_card
zt_order.td_c_recharge_card_1115
zt_order.td_c_third_authorization_push
zt_order.td_c_third_authorization_push_detail
zt_order.td_c_third_part_app_authorization
zt_order.td_c_third_push_config
zt_order.td_cl_customer_management
zt_order_n.td_b_abcpay_config
zt_order_n.td_b_alipay_config
zt_order_n.td_b_etc_config
zt_order_n.td_b_wx_config
zt_order_n.td_c_cust_person
zt_order_n.tp_e_employee_charge
zt_park.td_cl_api_authorization
zt_park.tp_e_employee_charge
zt_park.tp_p_network_card_org_config
zt_park.voice_client_user
zt_sys.aliyun_ecs_config
zt_sys.sys_op