-- 供应商状态预置脚本
DELETE FROM T_BD_SUPPLIERSTATUS WHERE FID = 880834131733251072;
INSERT INTO T_BD_SUPPLIERSTATUS(FID,FCREATORID,FDISABLERID,FMODIFYTIME,FNAME,FCREATETIME,FDISABLEDATE,FNUMBER,FSTATUS,FISPRESET,FMODIFIERID,FENABLE,FDESCRIPTION,FMASTERID) VALUES 
(880834131733251072,403700558952663057,0,{ts'2020-04-30  07:41:42'},'退出',{ts'2020-04-30  07:39:41'},NULL,'TCGYS','A','1',403700558952663057,'1','表示供应商为退出状态',880834131733251072); 
DELETE FROM T_BD_SUPPLIERSTATUS WHERE FID = 880835238786237440;
INSERT INTO T_BD_SUPPLIERSTATUS(FID,FCREATORID,FDISABLERID,FMODIFYTIME,FNAME,FCREATETIME,FDISABLEDATE,FNUMBER,FSTATUS,FISPRESET,FMODIFIERID,FENABLE,FDESCRIPTION,FMASTERID) VALUES 
(880835238786237440,403700558952663057,0,{ts'2020-04-30  07:42:23'},'潜在',{ts'2020-04-30  07:42:00'},NULL,'QZGYS','A','1',403700558952663057,'1','表示供应商为潜在供应商',880835238786237440); 
DELETE FROM T_BD_SUPPLIERSTATUS WHERE FID = 880835462149703680;
INSERT INTO T_BD_SUPPLIERSTATUS(FID,FCREATORID,FDISABLERID,FMODIFYTIME,FNAME,FCREATETIME,FDISABLEDATE,FNUMBER,FSTATUS,FISPRESET,FMODIFIERID,FENABLE,FDESCRIPTION,FMASTERID) VALUES 
(880835462149703680,403700558952663057,0,{ts'2020-04-30  07:42:49'},'正常',{ts'2020-04-30  07:42:27'},NULL,'ZCGYS','A','1',403700558952663057,'1','表示供应商为正常交易状态',880835462149703680); 
DELETE FROM T_BD_SUPPLIERSTATUS WHERE FID = 880835708355347456;
INSERT INTO T_BD_SUPPLIERSTATUS(FID,FCREATORID,FDISABLERID,FMODIFYTIME,FNAME,FCREATETIME,FDISABLEDATE,FNUMBER,FSTATUS,FISPRESET,FMODIFIERID,FENABLE,FDESCRIPTION,FMASTERID) VALUES 
(880835708355347456,403700558952663057,0,{ts'2020-04-30  07:43:19'},'异常',{ts'2020-04-30  07:43:00'},NULL,'YCGYS','A','1',403700558952663057,'1','表示供应商为异常交易状态',880835708355347456); 

-- 供应商状态预置脚本
DELETE FROM T_BD_SUPPLIERSTATUS_L WHERE FID IN(880834131733251072,880835238786237440,880835462149703680,880835708355347456);
INSERT INTO T_BD_SUPPLIERSTATUS_L(FID,FPKID,FLOCALEID,FNAME,FDESCRIPTION) VALUES (880834131733251072,'0R6+186T7FL=','zh_CN','退出','表示供应商为退出状态'); 
INSERT INTO T_BD_SUPPLIERSTATUS_L(FID,FPKID,FLOCALEID,FNAME,FDESCRIPTION) VALUES (880834131733251072,'0R6+186T7FLA','zh_TW','退出','表示供應商為退出狀態'); 
INSERT INTO T_BD_SUPPLIERSTATUS_L(FID,FPKID,FLOCALEID,FNAME,FDESCRIPTION) VALUES (880835238786237440,'0R6+9=TFLL8O','zh_CN','潜在','表示供应商为潜在供应商'); 
INSERT INTO T_BD_SUPPLIERSTATUS_L(FID,FPKID,FLOCALEID,FNAME,FDESCRIPTION) VALUES (880835238786237440,'0R6+9=TFLL8P','zh_TW','潛在','表示供應商為潛在供應商'); 
INSERT INTO T_BD_SUPPLIERSTATUS_L(FID,FPKID,FLOCALEID,FNAME,FDESCRIPTION) VALUES (880835462149703680,'0R6+=Y=6JE2T','zh_CN','正常','表示供应商为正常交易状态'); 
INSERT INTO T_BD_SUPPLIERSTATUS_L(FID,FPKID,FLOCALEID,FNAME,FDESCRIPTION) VALUES (880835462149703680,'0R6+=Y=6JE2U','zh_TW','正常','表示供應商為正常交易狀態'); 
INSERT INTO T_BD_SUPPLIERSTATUS_L(FID,FPKID,FLOCALEID,FNAME,FDESCRIPTION) VALUES (880835708355347456,'0R6+BQ9/JENB','zh_CN','异常','表示供应商为异常交易状态'); 
INSERT INTO T_BD_SUPPLIERSTATUS_L(FID,FPKID,FLOCALEID,FNAME,FDESCRIPTION) VALUES (880835708355347456,'0R6+BQ9/JENC','zh_TW','異常','表示供應商為異常交易狀態'); 

-- 升级历史数据，无供应商状态的供应商修改为供应商状态默认值
UPDATE T_BD_SUPPLIER SET FSUPPLIERSTATUS ='880835462149703680' WHERE FSUPPLIERSTATUS='0';