DELETE FROM t_pbd_esconfigentry WHERE FENTRYID = 1830477939473508352;
INSERT INTO t_pbd_esconfigentry(FID,FISPRIMARYKEY,FENTRYID,FSEQ,FESMAPPINGID) VALUES (1822386481814417408,'0',1830477939473508352,6,1830476954877421568); 
DELETE FROM t_pbd_esconfigentry WHERE FENTRYID = 1825510633190307841;
INSERT INTO t_pbd_esconfigentry(FID,FISPRIMARYKEY,FENTRYID,FSEQ,FESMAPPINGID) VALUES (1822386481814417408,'0',1825510633190307841,2,1825495260336457728); 
DELETE FROM t_pbd_esconfigentry WHERE FENTRYID = 1825510633190307842;
INSERT INTO t_pbd_esconfigentry(FID,FISPRIMARYKEY,FENTRYID,FSEQ,FESMAPPINGID) VALUES (1822386481814417408,'0',1825510633190307842,3,1825495014298585088); 
DELETE FROM t_pbd_esconfigentry WHERE FENTRYID = 1825510633190307843;
INSERT INTO t_pbd_esconfigentry(FID,FISPRIMARYKEY,FENTRYID,FSEQ,FESMAPPINGID) VALUES (1822386481814417408,'0',1825510633190307843,4,1825494528564508672); 
DELETE FROM t_pbd_esconfigentry WHERE FENTRYID = 1825510633190307840;
INSERT INTO t_pbd_esconfigentry(FID,FISPRIMARYKEY,FENTRYID,FSEQ,FESMAPPINGID) VALUES (1822386481814417408,'1',1825510633190307840,1,1825510014555752448); 
DELETE FROM t_pbd_esconfigentry WHERE FENTRYID = 1827654336780503040;
INSERT INTO t_pbd_esconfigentry(FID,FISPRIMARYKEY,FENTRYID,FSEQ,FESMAPPINGID) VALUES (1822386481814417408,'0',1827654336780503040,5,1827654007242426368); 
DELETE FROM t_pbd_esconfig WHERE FID = 1822386481814417408;
INSERT INTO t_pbd_esconfig(FID,FFILTERCONDITION,FINDEXKEY,FINDEXENTITYID,FESOUTPUTID,FPARENTESCONFIGID,FMASTERID,FSTATUS,FNUMBER,FISHANDLEBYPARENT,FCREATETIME,FMODIFIERID,FENABLE,FREGION,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1822386481814417408,'{"filterRow":[],"forList":false}','pmm_prodpool','pmm_inventory',0,1560871593289408512,1822386481814417408,'C','es_goods_inventory','1',{ts'2023-11-20  00:00:00'},1,'1','pur','1',{ts'2023-12-01  00:00:00'},1); 
DELETE FROM t_pbd_esconfig_l WHERE FPKID = '3PUW23Q+SLG3';
INSERT INTO t_pbd_esconfig_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1822386481814417408,'3PUW23Q+SLG3','zh_CN','商品库存全文检索配置'); 
DELETE FROM t_pbd_esconfig_l WHERE FPKID = '3PUW23Q+SLG4';
INSERT INTO t_pbd_esconfig_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1822386481814417408,'3PUW23Q+SLG4','zh_TW','商品庫存全文檢索配置'); 

DELETE FROM t_pbd_esconfigentry WHERE FENTRYID = 1825518396318526464;
INSERT INTO t_pbd_esconfigentry(FID,FISPRIMARYKEY,FENTRYID,FSEQ,FESMAPPINGID) VALUES (1560871593289408512,'0',1825518396318526464,35,1825518351003266048);
DELETE FROM t_pbd_esconfigentry WHERE FENTRYID = 1827648757609597952;
INSERT INTO t_pbd_esconfigentry(FID,FISPRIMARYKEY,FENTRYID,FSEQ,FESMAPPINGID) VALUES (1560871593289408512,'0',1827648757609597952,36,1827648324497377280);
DELETE FROM t_pbd_esconfigentry WHERE FENTRYID = 1827648757609597953;
INSERT INTO t_pbd_esconfigentry(FID,FISPRIMARYKEY,FENTRYID,FSEQ,FESMAPPINGID) VALUES (1560871593289408512,'0',1827648757609597953,37,1827648717520439296);  
DELETE FROM t_pbd_esconfigentry WHERE FENTRYID = 1827654474211067904;
INSERT INTO t_pbd_esconfigentry(FID,FISPRIMARYKEY,FENTRYID,FSEQ,FESMAPPINGID) VALUES (1560871593289408512,'0',1827654474211067904,38,1827654209768589312);
DELETE FROM t_pbd_esconfigentry WHERE FENTRYID = 1830478136312206336;
INSERT INTO t_pbd_esconfigentry(FID,FISPRIMARYKEY,FENTRYID,FSEQ,FESMAPPINGID) VALUES (1560871593289408512,'0',1830478136312206336,39,1830477815573768192); 

DELETE FROM t_pbd_esmappingprop WHERE FID = 1827648717520439296;
INSERT INTO t_pbd_esmappingprop(FID,FDATATYPE,FINDEXENTITYID,FWITHPINYIN,FBOOST,FESTOKENIZERTYPE,FMASTERID,FSTATUS,FNUMBER,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FMAPPINGFIELD,FDEFAULTVALUE,FCREATORID) VALUES (1827648717520439296,'double','pmm_prodpool','0',1.0000000000,'standard',1827648717520439296,'C','lockedqty',{ts'2023-11-27  00:00:00'},1,'1','1',{ts'2023-11-27  00:00:00'},' ',' ',1); 
DELETE FROM t_pbd_esmappingprop WHERE FID = 1825494528564508672;
INSERT INTO t_pbd_esmappingprop(FID,FDATATYPE,FINDEXENTITYID,FWITHPINYIN,FBOOST,FESTOKENIZERTYPE,FMASTERID,FSTATUS,FNUMBER,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FMAPPINGFIELD,FDEFAULTVALUE,FCREATORID) VALUES (1825494528564508672,'double','pmm_inventory','0',1.0000000000,'standard',1825494528564508672,'C','currentqty',{ts'2023-11-24  00:00:00'},1,'1','1',{ts'2023-11-24  00:00:00'},'qty','0',1); 
DELETE FROM t_pbd_esmappingprop WHERE FID = 1825495014298585088;
INSERT INTO t_pbd_esmappingprop(FID,FDATATYPE,FINDEXENTITYID,FWITHPINYIN,FBOOST,FESTOKENIZERTYPE,FMASTERID,FSTATUS,FNUMBER,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FMAPPINGFIELD,FDEFAULTVALUE,FCREATORID) VALUES (1825495014298585088,'double','pmm_inventory','0',1.0000000000,'standard',1825495014298585088,'C','lockedqty',{ts'2023-11-24  00:00:00'},1,'1','1',{ts'2023-11-24  00:00:00'},'lockedqty','0',1); 
DELETE FROM t_pbd_esmappingprop WHERE FID = 1825495260336457728;
INSERT INTO t_pbd_esmappingprop(FID,FDATATYPE,FINDEXENTITYID,FWITHPINYIN,FBOOST,FESTOKENIZERTYPE,FMASTERID,FSTATUS,FNUMBER,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FMAPPINGFIELD,FDEFAULTVALUE,FCREATORID) VALUES (1825495260336457728,'double','pmm_inventory','0',1.0000000000,'standard',1825495260336457728,'C','availableqty',{ts'2023-11-24  00:00:00'},1,'1','1',{ts'2023-11-24  00:00:00'},'availableqty','0',1); 
DELETE FROM t_pbd_esmappingprop WHERE FID = 1827654007242426368;
INSERT INTO t_pbd_esmappingprop(FID,FDATATYPE,FINDEXENTITYID,FWITHPINYIN,FBOOST,FESTOKENIZERTYPE,FMASTERID,FSTATUS,FNUMBER,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FMAPPINGFIELD,FDEFAULTVALUE,FCREATORID) VALUES (1827654007242426368,'keyword','pmm_inventory','0',1.0000000000,'standard',1827654007242426368,'C','isinventorylimited',{ts'2023-11-27  00:00:00'},1,'1','1',{ts'2023-11-27  00:00:00'},' ','1',1); 
DELETE FROM t_pbd_esmappingprop WHERE FID = 1827648324497377280;
INSERT INTO t_pbd_esmappingprop(FID,FDATATYPE,FINDEXENTITYID,FWITHPINYIN,FBOOST,FESTOKENIZERTYPE,FMASTERID,FSTATUS,FNUMBER,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FMAPPINGFIELD,FDEFAULTVALUE,FCREATORID) VALUES (1827648324497377280,'double','pmm_prodpool','0',1.0000000000,'standard',1827648324497377280,'C','currentqty',{ts'2023-11-27  00:00:00'},1,'1','1',{ts'2023-11-27  00:00:00'},' ',' ',1); 
DELETE FROM t_pbd_esmappingprop WHERE FID = 1827654209768589312;
INSERT INTO t_pbd_esmappingprop(FID,FDATATYPE,FINDEXENTITYID,FWITHPINYIN,FBOOST,FESTOKENIZERTYPE,FMASTERID,FSTATUS,FNUMBER,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FMAPPINGFIELD,FDEFAULTVALUE,FCREATORID) VALUES (1827654209768589312,'keyword','pmm_prodpool','0',1.0000000000,'standard',1827654209768589312,'C','isinventorylimited',{ts'2023-11-27  00:00:00'},1,'1','1',{ts'2023-11-27  00:00:00'},' ','0',1); 
DELETE FROM t_pbd_esmappingprop WHERE FID = 1825510014555752448;
INSERT INTO t_pbd_esmappingprop(FID,FDATATYPE,FINDEXENTITYID,FWITHPINYIN,FBOOST,FESTOKENIZERTYPE,FMASTERID,FSTATUS,FNUMBER,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FMAPPINGFIELD,FDEFAULTVALUE,FCREATORID) VALUES (1825510014555752448,'keyword','pmm_inventory','0',1.0000000000,'standard',1825510014555752448,'A','goodsid',{ts'2023-11-24  00:00:00'},1,'1','1',{ts'2023-11-27  00:00:00'},'goods.id',' ',1); 
DELETE FROM t_pbd_esmappingprop WHERE FID = 1830476954877421568;
INSERT INTO t_pbd_esmappingprop(FID,FDATATYPE,FINDEXENTITYID,FWITHPINYIN,FBOOST,FESTOKENIZERTYPE,FMASTERID,FSTATUS,FNUMBER,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FMAPPINGFIELD,FDEFAULTVALUE,FCREATORID) VALUES (1830476954877421568,'long','pmm_inventory','0',1.0000000000,'standard',1830476954877421568,'C','inventory_unit_id',{ts'2023-12-01  00:00:00'},1,'1','1',{ts'2023-12-01  00:00:00'},'unit.id',' ',1); 
DELETE FROM t_pbd_esmappingprop WHERE FID = 1830477815573768192;
INSERT INTO t_pbd_esmappingprop(FID,FDATATYPE,FINDEXENTITYID,FWITHPINYIN,FBOOST,FESTOKENIZERTYPE,FMASTERID,FSTATUS,FNUMBER,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FMAPPINGFIELD,FDEFAULTVALUE,FCREATORID) VALUES (1830477815573768192,'long','pmm_prodpool','0',1.0000000000,'standard',1830477815573768192,'C','inventory_unit_id',{ts'2023-12-01  00:00:00'},1,'1','1',{ts'2023-12-01  00:00:00'},' ',' ',1); 
DELETE FROM t_pbd_esmappingprop WHERE FID = 1825518351003266048;
INSERT INTO t_pbd_esmappingprop(FID,FDATATYPE,FINDEXENTITYID,FWITHPINYIN,FBOOST,FESTOKENIZERTYPE,FMASTERID,FSTATUS,FNUMBER,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FMAPPINGFIELD,FDEFAULTVALUE,FCREATORID) VALUES (1825518351003266048,'double','pmm_prodpool','0',1.0000000000,'standard',1825518351003266048,'C','availableqty',{ts'2023-11-24  00:00:00'},1,'1','1',{ts'2023-11-27  00:00:00'},' ',' ',1); 
DELETE FROM t_pbd_esmappingprop_l WHERE FPKID = '3Q7RTDPV3W32';
INSERT INTO t_pbd_esmappingprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1825494528564508672,'3Q7RTDPV3W32','zh_CN','现有库存量'); 
DELETE FROM t_pbd_esmappingprop_l WHERE FPKID = '3Q7RWYO47EH8';
INSERT INTO t_pbd_esmappingprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1825495014298585088,'3Q7RWYO47EH8','zh_CN','锁定库存量'); 
DELETE FROM t_pbd_esmappingprop_l WHERE FPKID = '3Q7RYQKXF=48';
INSERT INTO t_pbd_esmappingprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1825495260336457728,'3Q7RYQKXF=48','zh_CN','可用库存量'); 
DELETE FROM t_pbd_esmappingprop_l WHERE FPKID = '3Q7UP8MDUP++';
INSERT INTO t_pbd_esmappingprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1825510014555752448,'3Q7UP8MDUP++','zh_CN','商品.内码(goods.id)'); 
DELETE FROM t_pbd_esmappingprop_l WHERE FPKID = '3Q7UP8MDUP+/';
INSERT INTO t_pbd_esmappingprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1825510014555752448,'3Q7UP8MDUP+/','zh_TW','商品.內碼(goods.id)'); 
DELETE FROM t_pbd_esmappingprop_l WHERE FPKID = '3QH282/P/90W';
INSERT INTO t_pbd_esmappingprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1827648324497377280,'3QH282/P/90W','zh_CN','现有库存量'); 
DELETE FROM t_pbd_esmappingprop_l WHERE FPKID = '3QH282/P/90X';
INSERT INTO t_pbd_esmappingprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1827648324497377280,'3QH282/P/90X','zh_TW','現有庫存量'); 
DELETE FROM t_pbd_esmappingprop_l WHERE FPKID = '3QH2=YLRW55H';
INSERT INTO t_pbd_esmappingprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1827648717520439296,'3QH2=YLRW55H','zh_CN','锁定库存量'); 
DELETE FROM t_pbd_esmappingprop_l WHERE FPKID = '3QH2=YLRW55I';
INSERT INTO t_pbd_esmappingprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1827648717520439296,'3QH2=YLRW55I','zh_TW','鎖定庫存量'); 
DELETE FROM t_pbd_esmappingprop_l WHERE FPKID = '3QH3=GXDT+LX';
INSERT INTO t_pbd_esmappingprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1827654007242426368,'3QH3=GXDT+LX','zh_CN','有库存限制'); 
DELETE FROM t_pbd_esmappingprop_l WHERE FPKID = '3QH3=GXDT+LY';
INSERT INTO t_pbd_esmappingprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1827654007242426368,'3QH3=GXDT+LY','zh_TW','有庫存限製'); 
DELETE FROM t_pbd_esmappingprop_l WHERE FPKID = '3QH3AZG311EY';
INSERT INTO t_pbd_esmappingprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1827654209768589312,'3QH3AZG311EY','zh_CN','有库存限制'); 
DELETE FROM t_pbd_esmappingprop_l WHERE FPKID = '3QH3AZG311EZ';
INSERT INTO t_pbd_esmappingprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1827654209768589312,'3QH3AZG311EZ','zh_TW','有庫存限製'); 
DELETE FROM t_pbd_esmappingprop_l WHERE FPKID = '3QUMR9+IQBD3';
INSERT INTO t_pbd_esmappingprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1830476954877421568,'3QUMR9+IQBD3','zh_CN','库存计量单位'); 
DELETE FROM t_pbd_esmappingprop_l WHERE FPKID = '3QUMR9+IQBD4';
INSERT INTO t_pbd_esmappingprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1830476954877421568,'3QUMR9+IQBD4','zh_TW','庫存計量單位'); 
DELETE FROM t_pbd_esmappingprop_l WHERE FPKID = '3QUMXIL1BOG0';
INSERT INTO t_pbd_esmappingprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1830477815573768192,'3QUMXIL1BOG0','zh_CN','库存计量单位'); 
DELETE FROM t_pbd_esmappingprop_l WHERE FPKID = '3QUMXIL1BOG1';
INSERT INTO t_pbd_esmappingprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1830477815573768192,'3QUMXIL1BOG1','zh_TW','庫存計量單位'); 
DELETE FROM t_pbd_esmappingprop_l WHERE FPKID = '3Q7W9+SM6RW2';
INSERT INTO t_pbd_esmappingprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1825518351003266048,'3Q7W9+SM6RW2','zh_CN','可用库存量'); 
DELETE FROM t_pbd_esmappingprop_l WHERE FPKID = '3Q7W9+SM6RW3';
INSERT INTO t_pbd_esmappingprop_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1825518351003266048,'3Q7W9+SM6RW3','zh_TW','可用庫存量'); 

--全文检索输出--
DELETE FROM t_pbd_esoutputentry WHERE FENTRYID = 1829680699054022656;
INSERT INTO t_pbd_esoutputentry(FID,FPARENTENTRYID,FFIXEVALUE,FENTRYID,FFIELDKEY,FSEQ,FCANDIDATEKEY,FEVALPATH,FFIELDTYPE,FISARRAY,FESMAPPINGID) VALUES (1600786341342568448,1600785165419112448,' ',1829680699054022656,'availableqty',42,'0',' ','decimal','0',1825518351003266048); 
DELETE FROM t_pbd_esoutputentry WHERE FENTRYID = 1829680699062412288;
INSERT INTO t_pbd_esoutputentry(FID,FPARENTENTRYID,FFIXEVALUE,FENTRYID,FFIELDKEY,FSEQ,FCANDIDATEKEY,FEVALPATH,FFIELDTYPE,FISARRAY,FESMAPPINGID) VALUES (1600786341342568448,1600785165419112448,' ',1829680699062412288,'isinventorylimited',43,'0',' ','string','0',1827654209768589312); 
DELETE FROM t_pbd_esoutputentry WHERE FENTRYID = 1830511096688142336;
INSERT INTO t_pbd_esoutputentry(FID,FPARENTENTRYID,FFIXEVALUE,FENTRYID,FFIELDKEY,FSEQ,FCANDIDATEKEY,FEVALPATH,FFIELDTYPE,FISARRAY,FESMAPPINGID) VALUES (1600786341342568448,1600785165419112448,' ',1830511096688142336,'inventoryunit',45,'0',' ','long','0',1830477815573768192); 