--升级电子回单号为空的数据,便于后续创建唯一索引
UPDATE t_bei_elecreceipt set freceiptno = fid where freceiptno = ' ';
UPDATE t_bei_elecreceipt set freceiptno = fid where freceiptno = '';
--升级交易明细银行主键为空的数据,便于后续创建唯一索引
UPDATE t_bei_transdetail set funiqueseq = fdetailid where funiqueseq = ' ' and fdetailid != ' ';
UPDATE t_bei_transdetail set funiqueseq = fid where funiqueseq = ' ' and fdetailid = ' ';
UPDATE t_bei_transdetail set funiqueseq = fid where funiqueseq = '';