在emmis表里执行，执行之前一定一定要备份


TRUNCATE TABLE branch_fee
UPDATE branch_stat SET ffee=0,ffeer=0,itotal=0

TRUNCATE TABLE  check_detail
TRUNCATE TABLE  check_detail_en
TRUNCATE TABLE  check_info
TRUNCATE TABLE  check_info_en
TRUNCATE TABLE  check_scan_err
TRUNCATE TABLE  check_track

TRUNCATE TABLE chq_main

TRUNCATE TABLE client_bill_item
TRUNCATE TABLE client_bill_main
TRUNCATE TABLE client_deposit
TRUNCATE TABLE client_fee
TRUNCATE TABLE client_fee_c
TRUNCATE TABLE client_fee_ce
TRUNCATE TABLE client_fee_r
TRUNCATE TABLE client_fee_re

TRUNCATE TABLE client_rec
TRUNCATE TABLE client_rec_check_memo
TRUNCATE TABLE client_rec_ctrl
TRUNCATE TABLE client_rec_date
TRUNCATE TABLE client_rec_error
TRUNCATE TABLE client_rec_error_affix

TRUNCATE TABLE client_rec_fee_adj_c
TRUNCATE TABLE client_rec_fee_adj_s

TRUNCATE TABLE client_rec_file
TRUNCATE TABLE client_rec_goods
TRUNCATE TABLE client_rec_memo
TRUNCATE TABLE client_rec_pack
TRUNCATE TABLE client_rec_pack_bag
TRUNCATE TABLE client_rec_pack_file
TRUNCATE TABLE client_rec_pack_pay
TRUNCATE TABLE client_rec_pack_pay_own

TRUNCATE TABLE client_rec_pic
TRUNCATE TABLE client_rec_pic2
TRUNCATE TABLE client_rec_prompt
TRUNCATE TABLE client_rec_prompta
TRUNCATE TABLE client_rec_promptc
TRUNCATE TABLE client_rec_query
TRUNCATE TABLE client_rec_snap
TRUNCATE TABLE client_rec_track
TRUNCATE TABLE client_rec_web

TRUNCATE TABLE client_rec_weight
TRUNCATE TABLE client_rec_weight_detail
TRUNCATE TABLE client_rec_weight_item

TRUNCATE TABLE client_rec_x
TRUNCATE TABLE client_rec_xbag
TRUNCATE TABLE client_rec_xbag_item
TRUNCATE TABLE client_rec_xbag_item_u

TRUNCATE TABLE emmis_take
TRUNCATE TABLE ems_num

TRUNCATE TABLE in_otherfee
TRUNCATE TABLE ivc_main
TRUNCATE TABLE ivc_item
TRUNCATE TABLE ivc_affix

TRUNCATE TABLE materiel_bill
TRUNCATE TABLE materiel_fee
TRUNCATE TABLE materiel_item

TRUNCATE TABLE out_payment

TRUNCATE TABLE  rec_pre_input
TRUNCATE TABLE  rec_pre_input_goods
TRUNCATE TABLE  rec_pre_input_item

DELETE rec_pre_input_goods WHERE iid IN(SELECT iid FROM rec_pre_input WHERE irid>0)

DELETE rec_pre_input_item WHERE iid IN(SELECT iid FROM rec_pre_input WHERE irid>0)

DELETE rec_pre_input WHERE irid>0


TRUNCATE TABLE  rec_trans
TRUNCATE TABLE  rec_trans_bag
TRUNCATE TABLE  rec_trans_goods
TRUNCATE TABLE  rec_trans_noclaim
TRUNCATE TABLE  rec_trans_reply

DELETE rec_trans WHERE biid IN(SELECT biid FROM rec_trans_bag WHERE irid>0)

DELETE rec_trans_bag WHERE irid>0

DELETE rec_trans_goods WHERE iid NOT IN(SELECT iid FROM rec_trans)


TRUNCATE TABLE rec_web
TRUNCATE TABLE rec_web_goods
TRUNCATE TABLE rec_web_item

TRUNCATE TABLE send_fee_p
TRUNCATE TABLE send_fee_r
TRUNCATE TABLE send_fee_s
TRUNCATE TABLE send_main

TRUNCATE TABLE sms_notice
TRUNCATE TABLE sms_receive
TRUNCATE TABLE sms_send

TRUNCATE TABLE sp_pay
TRUNCATE TABLE sp_pay_batch

TRUNCATE TABLE sys_log
TRUNCATE TABLE sys_login
TRUNCATE TABLE sys_login_pc

TRUNCATE TABLE sys_phone_rec

TRUNCATE TABLE vst_bag_dir
TRUNCATE TABLE vst_batch_in
TRUNCATE TABLE vst_goods
TRUNCATE TABLE vst_transit
TRUNCATE TABLE vst_bag_item
UPDATE vst_bag_dir SET irid=irid+2000000000 WHERE irid>0

UPDATE w_order SET irid=irid+2000000000 WHERE irid>0


EXECUTE cp_a_update_client_info_all

EXECUTE cp_a_update_sp_info_all