# 抽样镜像里**只搬结构、不搬数据**的表 # 由 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