DELETE FROM t_pbd_data_sync_trigger WHERE FID = 1666793604129200128;
INSERT INTO t_pbd_data_sync_trigger(FID,FESCONFIGID,FMASTERID,FSTATUS,FHANDLER,FEXPIRED_TIME,FNUMBER,FEVENTS,FTRIGGED_TIME,FJOB_DEFINEID,FJOB_SCHEDULEID,FCREATETIME,FVALIDATED_TIME,FMODIFIERID,FENABLE,FISPRESET,FINTERVAL,FMODIFYTIME,FTRIGGER_TYPE,FCREATORID,FTOTAL_COUNT,FEXE_JOB_USERID,FSCHEDULE) VALUES (1666793604129200128,1605155928276365312,1666793604129200128,'C','kd.scm.pbd.domain.model.esconfig.event.PbdEsDataSyncEventServicePlugin',NULL,'es_goods_ec_price_event_sync',',save,delete,',NULL,' ',' ',{ts'2023-04-19  00:00:00'},NULL,1,'0','1','d1',{ts'2023-04-19  00:00:00'},'event',1,0,0,' '); 
DELETE FROM t_pbd_data_sync_trigger WHERE FID = 1666792696079035392;
INSERT INTO t_pbd_data_sync_trigger(FID,FESCONFIGID,FMASTERID,FSTATUS,FHANDLER,FEXPIRED_TIME,FNUMBER,FEVENTS,FTRIGGED_TIME,FJOB_DEFINEID,FJOB_SCHEDULEID,FCREATETIME,FVALIDATED_TIME,FMODIFIERID,FENABLE,FISPRESET,FINTERVAL,FMODIFYTIME,FTRIGGER_TYPE,FCREATORID,FTOTAL_COUNT,FEXE_JOB_USERID,FSCHEDULE) VALUES (1666792696079035392,1605155928276365312,1666792696079035392,'C','kd.scm.pbd.domain.model.esconfig.schedule.PbdEsDataSyncTask',NULL,'es_goods_ec_price_auto_sync',' ',NULL,' ',' ',{ts'2023-04-19  00:00:00'},NULL,1,'0','1','d1',{ts'2023-04-19  00:00:00'},'auto',1,0,0,' '); 

DELETE FROM t_pbd_data_sync_trigger_l WHERE FID = 1666792696079035392 AND FLOCALEID = 'zh_CN';
INSERT INTO t_pbd_data_sync_trigger_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1666792696079035392,'37QF0VJ9595I','zh_CN','电商商品价格全文检索配置'); 
DELETE FROM t_pbd_data_sync_trigger_l WHERE FID = 1666793604129200128 AND FLOCALEID = 'zh_CN';
INSERT INTO t_pbd_data_sync_trigger_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1666793604129200128,'37QF7GL5J5X7','zh_CN','电商商品价格全文检索配置'); 



-- 全文检索映射属性
DELETE FROM t_pbd_esmappingprop WHERE FID = 1666815340027655168;
INSERT INTO t_pbd_esmappingprop(FID,FDATATYPE,FINDEXENTITYID,FWITHPINYIN,FBOOST,FESTOKENIZERTYPE,FMASTERID,FSTATUS,FNUMBER,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FMAPPINGFIELD,FDEFAULTVALUE,FCREATORID) VALUES (1666815340027655168,'keyword','pmm_prodpool','0',1.0000000000,'standard',1666815340027655168,'C','materielid',{ts'2023-04-19  00:00:00'},1,'1','1',{ts'2023-04-19  00:00:00'},'goods.materiel.id',' ',1); 
DELETE FROM t_pbd_esmappingprop WHERE FID = 1666816468169602048;
INSERT INTO t_pbd_esmappingprop(FID,FDATATYPE,FINDEXENTITYID,FWITHPINYIN,FBOOST,FESTOKENIZERTYPE,FMASTERID,FSTATUS,FNUMBER,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FMAPPINGFIELD,FDEFAULTVALUE,FCREATORID) VALUES (1666816468169602048,'keyword','pmm_prodpool','0',1.0000000000,'standard',1666816468169602048,'C','materielnumber',{ts'2023-04-19  00:00:00'},1,'1','1',{ts'2023-04-19  00:00:00'},'goods.materiel.number',' ',1); 
DELETE FROM t_pbd_esmappingprop WHERE FID = 1666816820575024128;
INSERT INTO t_pbd_esmappingprop(FID,FDATATYPE,FINDEXENTITYID,FWITHPINYIN,FBOOST,FESTOKENIZERTYPE,FMASTERID,FSTATUS,FNUMBER,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FMAPPINGFIELD,FDEFAULTVALUE,FCREATORID) VALUES (1666816820575024128,'keyword','pmm_prodpool','0',1.0000000000,'standard',1666816820575024128,'C','materielname',{ts'2023-04-19  00:00:00'},1,'1','1',{ts'2023-04-19  00:00:00'},'goods.materiel.name',' ',1); 

DELETE FROM t_pbd_esmappingprop_l WHERE FID = 1666815340027655168 AND FLOCALEID = 'zh_CN';
INSERT INTO t_pbd_esmappingprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1666815340027655168,'37QJ9VSD=9NZ','zh_CN','商品编码.对应ERP物料.内码(goods.materiel.id)'); 
DELETE FROM t_pbd_esmappingprop_l WHERE FID = 1666816468169602048 AND FLOCALEID = 'zh_CN';
INSERT INTO t_pbd_esmappingprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1666816468169602048,'37QJH2CSI7LK','zh_CN','商品编码.对应ERP物料.编码'); 
DELETE FROM t_pbd_esmappingprop_l WHERE FID = 1666816820575024128 AND FLOCALEID = 'zh_CN';
INSERT INTO t_pbd_esmappingprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1666816820575024128,'37QJJNIO1L95','zh_CN','商品编码.对应ERP物料.名称'); 


-- 全文检索配置分录
DELETE FROM t_pbd_esconfigentry WHERE FENTRYID = 1666815735852512256;
INSERT INTO t_pbd_esconfigentry(FID,FISPRIMARYKEY,FENTRYID,FSEQ,FESMAPPINGID) VALUES (1560871593289408512,'0',1666815735852512256,29,1666815340027655168); 
DELETE FROM t_pbd_esconfigentry WHERE FENTRYID = 1666816884043232256;
INSERT INTO t_pbd_esconfigentry(FID,FISPRIMARYKEY,FENTRYID,FSEQ,FESMAPPINGID) VALUES (1560871593289408512,'0',1666816884043232256,30,1666816468169602048); 
DELETE FROM t_pbd_esconfigentry WHERE FENTRYID = 1666816884043232257;
INSERT INTO t_pbd_esconfigentry(FID,FISPRIMARYKEY,FENTRYID,FSEQ,FESMAPPINGID) VALUES (1560871593289408512,'0',1666816884043232257,31,1666816820575024128); 

