-- 客户状态预置数据
DELETE FROM T_BD_CUSTOMERSTATUS WHERE FID = 1122389726960044032;
INSERT INTO T_BD_CUSTOMERSTATUS(FID,FCREATETIME,FENABLE,FMODIFIERID,FISPRESET,FMODIFYTIME,FDESCRIPTION,FMASTERID,FSTATUS,FCREATORID,FNUMBER,FNAME) VALUES 
(1122389726960044032,{ts'2021-03-29  14:26:08'},'1',403700558952663057,'1',{ts'2021-03-29  14:28:01'},'表示为潜在客户',1122389726960044032,'C',403700558952663057,'QZKH','潜在'); 
DELETE FROM T_BD_CUSTOMERSTATUS WHERE FID = 1122390034075371520;
INSERT INTO T_BD_CUSTOMERSTATUS(FID,FCREATETIME,FENABLE,FMODIFIERID,FISPRESET,FMODIFYTIME,FDESCRIPTION,FMASTERID,FSTATUS,FCREATORID,FNUMBER,FNAME) VALUES 
(1122390034075371520,{ts'2021-03-29  14:28:09'},'1',403700558952663057,'1',{ts'2021-03-29  14:28:38'},'表示客户为正式客户',1122390034075371520,'C',403700558952663057,'ZSKH','正式'); 

-- 客户状态预置多语言数据
DELETE FROM T_BD_CUSTOMERSTATUS_L WHERE FPKID = '1HV8OQGHJ=Z=';
INSERT INTO T_BD_CUSTOMERSTATUS_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1122389726960044032,'1HV8OQGHJ=Z=','zh_CN','表示为潜在客户','潜在'); 
DELETE FROM T_BD_CUSTOMERSTATUS_L WHERE FPKID = '1HV8OQGHJ=ZA';
INSERT INTO T_BD_CUSTOMERSTATUS_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1122389726960044032,'1HV8OQGHJ=ZA','zh_TW','表示為潛在客戶','潛在'); 
DELETE FROM T_BD_CUSTOMERSTATUS_L WHERE FPKID = '1HV8OQGHJ=ZB';
INSERT INTO T_BD_CUSTOMERSTATUS_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1122389726960044032,'1HV8OQGHJ=ZB','en_US','Indicates that the customer is a potential customer','potentiality'); 
DELETE FROM T_BD_CUSTOMERSTATUS_L WHERE FPKID = '1HV8QZQ/RTOG';
INSERT INTO T_BD_CUSTOMERSTATUS_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1122390034075371520,'1HV8QZQ/RTOG','zh_CN','表示客户为正式客户','正常'); 
DELETE FROM T_BD_CUSTOMERSTATUS_L WHERE FPKID = '1HV8QZQ/RTOH';
INSERT INTO T_BD_CUSTOMERSTATUS_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1122390034075371520,'1HV8QZQ/RTOH','zh_TW','表示客戶為正式客戶','正常'); 
DELETE FROM T_BD_CUSTOMERSTATUS_L WHERE FPKID = '1HV8QZQ/RTOI';
INSERT INTO T_BD_CUSTOMERSTATUS_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1122390034075371520,'1HV8QZQ/RTOI','en_US','Indicates that the customer is an official customer','normal'); 

-- 客户状态排除表预置数据
DELETE FROM T_BD_CUSTOMERSTATUSEXCLUD WHERE FID = 1122443733581711360;
INSERT INTO T_BD_CUSTOMERSTATUSEXCLUD(FID,FCUSTOMERSTATUS) VALUES (1122443733581711360,1122389726960044032); 

-- 升级历史数据
UPDATE T_BD_CUSTOMER SET FCUSTOMERSTATUS ='1122390034075371520' WHERE FCUSTOMERSTATUS=0 OR FCUSTOMERSTATUS IS NULL;