单据摘要升级保存数据丢失问题-修复语句

--删除单据摘要方案表数据

delete from T_WM_BillDigestSchema;

--创建单据摘要配置方案备份表

Create Table T_WM_BillDigestSchema_temp ( FID VARCHAR(44) NULL ,

FShcema_alias VARCHAR(128),

FBillMetadataPk VARCHAR(255),

FIsDefault INT);

--从单据摘要表取数据

insert into T_WM_BillDigestSchema_temp (FBillMetadataPk) select distinct FMetadataPK  from T_WM_BIllDIGEST;

--设置默认方案

update T_WM_BillDigestSchema_temp set fid=newbosid('3CCF0566'),FShcema_alias='默认方案',FIsDefault=1;

--把备份的数据重新插入单据摘要方案表

insert into T_WM_BillDigestSchema select * from T_WM_BillDigestSchema_temp;

--更新单据摘要的方案id

update T_WM_BIllDIGEST a set FSchemaID=(select fid from T_WM_BillDigestSchema b where a.FMetadataPK=b.FBillMetadataPk);