-- 资产变更单变更项目数据升级
-- 删除金额
DELETE FROM t_fa_change_item WHERE FID = 1241160500784523264;

--增加租赁的变更项目
DELETE FROM t_fa_change_item WHERE FID = 1271701635864783872;
INSERT INTO t_fa_change_item(FID,FMASTERID,FSTATUS,FNUMBER,FISGENVOUCHER,FNAME,FTOPIC,FCREATETIME,FBACKFIELD,FMODIFIERID,FENABLE,FMODIFYTIME,FPRESET,FISCHANGE,FCREATORID) VALUES (1271701635864783872,1271701635864783872,'C','assetcat','0','资产类别','fa_lease_contract',{ts'2018-08-08  18:08:08'},' ',1188421630645258240,'1',{ts'2018-08-08  18:08:08'},'1','0',1188421630645258240);
DELETE FROM t_fa_change_item WHERE FID = 1271701778110496768;
INSERT INTO t_fa_change_item(FID,FMASTERID,FSTATUS,FNUMBER,FISGENVOUCHER,FNAME,FTOPIC,FCREATETIME,FBACKFIELD,FMODIFIERID,FENABLE,FMODIFYTIME,FPRESET,FISCHANGE,FCREATORID) VALUES (1271701778110496768,1271701778110496768,'C','leaseenddate','0','租赁结束日','fa_lease_contract',{ts'2018-08-08  18:08:08'},' ',1188421630645258240,'1',{ts'2018-08-08  18:08:08'},'1','0',1188421630645258240);
DELETE FROM t_fa_change_item WHERE FID = 1271703849987533824;
INSERT INTO t_fa_change_item(FID,FMASTERID,FSTATUS,FNUMBER,FISGENVOUCHER,FNAME,FTOPIC,FCREATETIME,FBACKFIELD,FMODIFIERID,FENABLE,FMODIFYTIME,FPRESET,FISCHANGE,FCREATORID) VALUES (1271703849987533824,1271703849987533824,'C','assetname','0','资产名称','fa_lease_contract',{ts'2018-08-08  18:08:08'},' ',1188421630645258240,'1',{ts'2018-08-08  18:08:08'},'1','0',1188421630645258240);
DELETE FROM t_fa_change_item WHERE FID = 1272320836501572608;
INSERT INTO t_fa_change_item(FID,FMASTERID,FSTATUS,FNUMBER,FISGENVOUCHER,FNAME,FTOPIC,FCREATETIME,FBACKFIELD,FMODIFIERID,FENABLE,FMODIFYTIME,FPRESET,FISCHANGE,FCREATORID) VALUES (1272320836501572608,1272320836501572608,'C','payruleentryentity','0','付款规则','fa_lease_contract',{ts'2018-08-08  18:08:08'},' ',1188421630645258240,'1',{ts'2018-08-08  18:08:08'},'1','0',1188421630645258240);
DELETE FROM t_fa_change_item WHERE FID = 1272535191096833024;
INSERT INTO t_fa_change_item(FID,FMASTERID,FSTATUS,FNUMBER,FISGENVOUCHER,FNAME,FTOPIC,FCREATETIME,FBACKFIELD,FMODIFIERID,FENABLE,FMODIFYTIME,FPRESET,FISCHANGE,FCREATORID) VALUES (1272535191096833024,1272535191096833024,'C','leaser','0','出租方','fa_lease_contract',{ts'2018-08-08  18:08:08'},' ',1244720647309918208,'1',{ts'2018-08-08  18:08:08'},'1','0',1244720647309918208);
DELETE FROM t_fa_change_item WHERE FID = 1272535343819773952;
INSERT INTO t_fa_change_item(FID,FMASTERID,FSTATUS,FNUMBER,FISGENVOUCHER,FNAME,FTOPIC,FCREATETIME,FBACKFIELD,FMODIFIERID,FENABLE,FMODIFYTIME,FPRESET,FISCHANGE,FCREATORID) VALUES (1272535343819773952,1272535343819773952,'C','storeplace','0','存放地点','fa_lease_contract',{ts'2018-08-08  18:08:08'},' ',1244720647309918208,'1',{ts'2018-08-08  18:08:08'},'1','0',1244720647309918208);
DELETE FROM t_fa_change_item WHERE FID = 1272535515031319552;
INSERT INTO t_fa_change_item(FID,FMASTERID,FSTATUS,FNUMBER,FISGENVOUCHER,FNAME,FTOPIC,FCREATETIME,FBACKFIELD,FMODIFIERID,FENABLE,FMODIFYTIME,FPRESET,FISCHANGE,FCREATORID) VALUES (1272535515031319552,1272535515031319552,'C','assetamount','0','数量','fa_lease_contract',{ts'2018-08-08  18:08:08'},' ',1244720647309918208,'1',{ts'2018-08-08  18:08:08'},'1','0',1244720647309918208);
DELETE FROM t_fa_change_item WHERE FID = 1272535733713885184;
INSERT INTO t_fa_change_item(FID,FMASTERID,FSTATUS,FNUMBER,FISGENVOUCHER,FNAME,FTOPIC,FCREATETIME,FBACKFIELD,FMODIFIERID,FENABLE,FMODIFYTIME,FPRESET,FISCHANGE,FCREATORID) VALUES (1272535733713885184,1272535733713885184,'C','unit','0','计量单位','fa_lease_contract',{ts'2018-08-08  18:08:08'},' ',1244720647309918208,'1',{ts'2018-08-08  18:08:08'},'1','0',1244720647309918208);
DELETE FROM t_fa_change_item WHERE FID = 1272537555685926912;
INSERT INTO t_fa_change_item(FID,FMASTERID,FSTATUS,FNUMBER,FISGENVOUCHER,FNAME,FTOPIC,FCREATETIME,FBACKFIELD,FMODIFIERID,FENABLE,FMODIFYTIME,FPRESET,FISCHANGE,FCREATORID) VALUES (1272537555685926912,1272537555685926912,'C','discountrate','0','年折现率(%)','fa_lease_contract',{ts'2018-08-08  18:08:08'},' ',1244720647309918208,'1',{ts'2018-08-08  18:08:08'},'1','0',1244720647309918208);

--租赁变更项目多语言
DELETE FROM t_fa_change_item_L WHERE FPKID = '2+6L+18DMP00';
INSERT INTO t_fa_change_item_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1271701635864783872,'2+6L+18DMP00','zh_CN','资产类别');
DELETE FROM t_fa_change_item_L WHERE FPKID = '2+6L/2NLP0K2';
INSERT INTO t_fa_change_item_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1271701778110496768,'2+6L/2NLP0K2','zh_CN','租赁结束日');
DELETE FROM t_fa_change_item_L WHERE FPKID = '2+6LD6G95GGW';
INSERT INTO t_fa_change_item_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1271703849987533824,'2+6LD6G95GGW','zh_CN','资产名称');
DELETE FROM t_fa_change_item_L WHERE FPKID = '2+9JO5AJQ36X';
INSERT INTO t_fa_change_item_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1272320836501572608,'2+9JO5AJQ36X','zh_CN','付款规则');
DELETE FROM t_fa_change_item_L WHERE FPKID = '2+=KQ58N=OII';
INSERT INTO t_fa_change_item_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1272535191096833024,'2+=KQ58N=OII','zh_CN','出租方');
DELETE FROM t_fa_change_item_L WHERE FPKID = '2+=KR9N+B/Y+';
INSERT INTO t_fa_change_item_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1272535343819773952,'2+=KR9N+B/Y+','zh_CN','存放地点');
DELETE FROM t_fa_change_item_L WHERE FPKID = '2+=KSI=LL7LJ';
INSERT INTO t_fa_change_item_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1272535515031319552,'2+=KSI=LL7LJ','zh_CN','数量');
DELETE FROM t_fa_change_item_L WHERE FPKID = '2+=KU3FCLXGC';
INSERT INTO t_fa_change_item_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1272535733713885184,'2+=KU3FCLXGC','zh_CN','计量单位');
DELETE FROM t_fa_change_item_L WHERE FPKID = '2+=L5DB6VOKW';
INSERT INTO t_fa_change_item_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1272537555685926912,'2+=L5DB6VOKW','zh_CN','年折现率(%)');

-- 变更映射关系预置 脚本
DELETE FROM t_fa_change_mapping WHERE FID = 1282562000320271360;
INSERT INTO t_fa_change_mapping(FID,FCREATETIME,FMODIFIERID,FENABLE,FLEASEITEMID,FMODIFYTIME,FPRESET,FMASTERID,FSTATUS,FCREATORID,FCARDITEMID) VALUES (1282562000320271360,{ts'2018-08-08  18:08:08'},1,'1',1271701778110496768,{ts'2018-08-08  18:08:08'},'1',1282562000320271360,'C',1,732502927482216448);
DELETE FROM t_fa_change_mapping WHERE FID = 1274566969550623744;
INSERT INTO t_fa_change_mapping(FID,FCREATETIME,FMODIFIERID,FENABLE,FLEASEITEMID,FMODIFYTIME,FPRESET,FMASTERID,FSTATUS,FCREATORID,FCARDITEMID) VALUES (1274566969550623744,{ts'2018-08-08  18:08:08'},1,'1',1271701635864783872,{ts'2018-08-08  18:08:08'},'1',1274566969550623744,'C',1,732503385869312000);
DELETE FROM t_fa_change_mapping WHERE FID = 1274610364415288320;
INSERT INTO t_fa_change_mapping(FID,FCREATETIME,FMODIFIERID,FENABLE,FLEASEITEMID,FMODIFYTIME,FPRESET,FMASTERID,FSTATUS,FCREATORID,FCARDITEMID) VALUES (1274610364415288320,{ts'2018-08-08  18:08:08'},1,'1',1272535343819773952,{ts'2018-08-08  18:08:08'},'1',1274610364415288320,'C',1,732504478468726784);
DELETE FROM t_fa_change_mapping WHERE FID = 1275909135933702144;
INSERT INTO t_fa_change_mapping(FID,FCREATETIME,FMODIFIERID,FENABLE,FLEASEITEMID,FMODIFYTIME,FPRESET,FMASTERID,FSTATUS,FCREATORID,FCARDITEMID) VALUES (1275909135933702144,{ts'2018-08-08  18:08:08'},1,'1',1272320836501572608,{ts'2018-08-08  18:08:08'},'1',1275909135933702144,'C',1,732500065087740928);
DELETE FROM t_fa_change_mapping WHERE FID = 1282561031947859968;
INSERT INTO t_fa_change_mapping(FID,FCREATETIME,FMODIFIERID,FENABLE,FLEASEITEMID,FMODIFYTIME,FPRESET,FMASTERID,FSTATUS,FCREATORID,FCARDITEMID) VALUES (1282561031947859968,{ts'2018-08-08  18:08:08'},1,'1',1272537555685926912,{ts'2018-08-08  18:08:08'},'1',1282561031947859968,'C',1,732500065087740928);

--变更类型新增字段默认数据
update t_fa_changetype set FEFTSCOPE = 'A';