--影像系统配置预置数据
--author:xiang_song
IF NOT EXISTS (SELECT 1 FROM t_bas_imageconfig WHERE fid = '1')
INSERT INTO t_bas_imageconfig (FID, FDISABLEDATE, FIMAGESYSTERMIP, FMASTERID, FSTATUS, FCLIENTID, FCLIENTSECRET, FNUMBER, FEXTERNALERPID, 
FCREATETIME, FIMAGEPORT, FMODIFIERID, FENABLE, FMODIFYTIME, FCREATORID, FDISABLERID) 
VALUES (1,null,'172.18.1.169',1,'A',' ',' ','GXHC',427215148743160832,{ts'2019-12-02  09:55:25'},'8080',13466739,'B',{ts'2019-12-02  09:59:13'},13466739,0); 

IF NOT EXISTS (SELECT 2 FROM t_bas_imageconfig WHERE fid = '2')
INSERT INTO t_bas_imageconfig (FID, FDISABLEDATE, FIMAGESYSTERMIP, FMASTERID, FSTATUS, FCLIENTID, FCLIENTSECRET, FNUMBER, FEXTERNALERPID, 
FCREATETIME, FIMAGEPORT, FMODIFIERID, FENABLE, FMODIFYTIME, FCREATORID, FDISABLERID) 
VALUES (2,null,'172.18.1.169',2,'A',' ',' ','DKWS',427215148743160832,{ts'2019-12-02  09:58:37'},'8080',13466739,'A',{ts'2019-12-02  09:59:20'},13466739,0); 

UPDATE t_bas_imageconfig SET FNUMBER = 'GXHC' WHERE fid = '1' and EXISTS(SELECT 1 FROM (SELECT 1 FROM t_bas_imageconfig WHERE fid='1')a );

UPDATE t_bas_imageconfig SET FNUMBER = 'DKWS' WHERE fid = '2' and EXISTS(SELECT 1 FROM (SELECT 1 FROM t_bas_imageconfig WHERE fid='2')a );

DELETE FROM t_bas_imageconfig_l WHERE FPKID = '0DUFW62BLHZ=';
INSERT INTO t_bas_imageconfig_l(FID,FPKID,FLOCALEID,FSIMPLENAME,FNAME) VALUES (1,'0DUFW62BLHZ=','zh_CN','国信合成','KD'); 
DELETE FROM t_bas_imageconfig_l WHERE FPKID = '0DUFW62BLHZA';
INSERT INTO t_bas_imageconfig_l(FID,FPKID,FLOCALEID,FSIMPLENAME,FNAME) VALUES (1,'0DUFW62BLHZA','zh_TW','國信合成','KD'); 
DELETE FROM t_bas_imageconfig_l WHERE FPKID = '0DUFYDGOAUY5';
INSERT INTO t_bas_imageconfig_l(FID,FPKID,FLOCALEID,FSIMPLENAME,FNAME) VALUES (2,'0DUFYDGOAUY5','zh_CN','道可维斯','KD'); 
DELETE FROM t_bas_imageconfig_l WHERE FPKID = '0DUFYDGOAUY6';
INSERT INTO t_bas_imageconfig_l(FID,FPKID,FLOCALEID,FSIMPLENAME,FNAME) VALUES (2,'0DUFYDGOAUY6','zh_TW','道可維斯','KD'); 