/*  creator：IERP
本脚本为预插脚本，可放入安装部署包内部署到正式环境。
********************************************************************* 
 */ 
 DELETE FROM t_bas_resourcecategory WHERE flongnumber = 'images.kdtest';
INSERT INTO t_bas_resourcecategory(FID,FISLEAF,FLEVEL,FPARENTID,FLONGNUMBER,FNUMBER,fcreatetime,fmodifytime,fstatus, fcreatorid) VALUES  (868716911184065536 , 0 , '2' , '397599972071064576' , 'images.kdtest' , 'kdtest' , {ts'2020-04-13 14:25:26'} , {ts'2020-04-13 14:25:26'} , 'C' , '0' );
DELETE FROM t_bas_resourcecategory_l WHERE fid =868716911184065536;
INSERT INTO t_bas_resourcecategory_l (FPKID, FID, FLOCALEID, FNAME, FFULLNAME) VALUES  ('17/KXDIGQWEA',868716911184065536,'zh_CN','kdtest' , 'kdtest' );
DELETE FROM t_bas_resourcecategory WHERE flongnumber = 'icons.kdtest';
INSERT INTO t_bas_resourcecategory(FID,FISLEAF,FLEVEL,FPARENTID,FLONGNUMBER,FNUMBER,fcreatetime,fmodifytime,fstatus, fcreatorid) VALUES  (982485146051545088 , 0 , '2' , '397599676313912320' , 'icons.kdtest' , 'kdtest' , {ts'2020-09-17 13:42:36'} , {ts'2020-09-17 13:42:36'} , 'C' , '0' );
DELETE FROM t_bas_resourcecategory_l WHERE fid =982485146051545088;
INSERT INTO t_bas_resourcecategory_l (FPKID, FID, FLOCALEID, FNAME, FFULLNAME) VALUES  ('17/KXDIGPZQQ',982485146051545088,'zh_CN','kdtest' , 'kdtest' );
DELETE FROM t_bas_pictureresource WHERE FURL0 ='/icons/pc/label/ladder_42x.png';
INSERT INTO t_bas_pictureresource (FID, FNUMBER,FURL0, FTYPE, FFORMAT, FPATH, FCREATEDATE, fcategoryid) VALUES  (1026027639246174208 , 'ladderOperate' , '/icons/pc/label/ladder_42x.png' , 'image' , 'png' , '/icons/pc/label/' , {ts'2020-11-16 15:31:40'} , 397604259354415104 );
DELETE FROM t_bas_pictureresource_l WHERE fid =1026027639246174208;
INSERT INTO t_bas_pictureresource_l (FPKID, FID, FLOCALEID, FDESCRIPTION, FNAME) VALUES  ('17/KXDIGQWEB',1026027639246174208,'zh_CN','天梯运维' , '天梯运维' );
