30数据迁移方案(会理县).docx

初始化数据库清空无用数据，保留系统运行所需的基础数据，其中基础数据表包括：da_jxjy_categoryda_jxjy_commodity_categoryda_jxjy_partner_membermenuda_jxjy_base_stepda_jxjy_areada_jxjy_zoneda_jxjy_times_monthda_jxjy_pay_bankda_jxjy_pay_bank_templateda_jxjy_pay_bank_template_attrda_jxjy_dict迁移地区配置增加迁移配置地区合作机构配置（需与V1.0线上配置相同）数据迁移将V1.0系统数据迁移到V3.0，其中需要迁移的数据包括：数据表V1.0V3.0备注1用户表app_userda_jxjy_user_register2学员信息表da_retrain_external_datada_jxjy_user_base_info各地区扩展表不同，使用字段也不相同3订单表da_ocs_orderda_jxjy_order4订单详情表da_ocs_order_itemda_jxjy_orderdetail5发票表da_ocs_invoiceda_ocs_delivery_addressda_jxjy_invoice6开课记录表da_retrain_accountda_jxjy_account7选课记录表da_retrain_student_electiveda_jxjy_student_elective8听课记录表da_retrainware_listen_log9考试记录表da_user_retraining_logda_examinationHistoryda_jxjy_exam_log会理县用户表（app_user → da_jxjy_user_register）学员信息表（da_retrain_external_data → da_jxjy_user_base_info）统计导出数据总数：（1和2条数相等，3和4条数相等即为正常）select a,sum(c) from (-- 用户表有数据，扩展表没数据 --select count(1) c, 1 as afrom app_user u left join da_retrain_external_data d on u.username=d.bind_username where u.group_id = 947 and d.id is nullUNION -- 用户表没数据，扩展表有数据 --select count(1) c, 3 as afrom da_retrain_external_data d where d.area_id = 1701 and d.bind_username is nullUNION-- 用户表有数据，扩展表有数据 --select count(1) c, 1 as afrom app_user u, da_retrain_external_data d where u.username=d.bind_username and u.group_id = 947 and area_id = 1701UNION-- 用户表有数据，扩展表有数据 --select count(1) c, 3 as a from app_user u, da_retrain_external_data d where u.username=d.bind_username and u.group_id = 947 and area_id = 1701UNION-- 用户表所有数据 --select count(1) c, 2 as a from app_user where group_id = 947UNION-- 扩展表所有数据 --select count(1) c, 4 as afrom da_retrain_external_data d where d.area_id = 1701 ) as aagroup by a用户表（有数据），学员信息表（有数据）查询身份证号重复且没有开过课的用户IDselect 1, GROUP_CONCAT(a1.id) from (select GROUP_CONCAT(u.id) id from app_user u, da_retrain_external_data d where u.username=d.bind_username and u.group_id = 947 and area_id = 1701 group by d.id_card having count(d.id) 1) a1 group by 1查询身