/* creator:IERP
请手工修改是否原厂字段FISOEM,描 述：0代表非原厂，1表示原厂。
*/
IF EXISTS (SELECT 1 FROM KSQL_USERTABLES WHERE KSQL_TABNAME = 'T_CBS_SHARD_CONFIG_TPL')
DELETE FROM T_CBS_SHARD_CONFIG_TPL WHERE FID=1379001352205679616;
IF EXISTS (SELECT 1 FROM KSQL_USERTABLES WHERE KSQL_TABNAME = 'T_CBS_SHARD_CONFIG_TPL')
INSERT INTO T_CBS_SHARD_CONFIG_TPL (FID, FENTITYNUMBER, FNUMBER, FSHARDINGFIELDS, FSTRATEGYZH_CN, FSTRATEGYPARAMS, FSTRATEGY, FISOEM) VALUES(1379001352205679616, 'bcm_isdatatrace_from', 'bcm_isdatatrace_from', 'periodnumber,yearnumber', '映射策略', 'range=less10
indices=model,searchkey
delim=#', 'MapStrategy', '1');
IF EXISTS (SELECT 1 FROM KSQL_USERTABLES WHERE KSQL_TABNAME = 'T_CBS_SHARD_CONFIG_TPL_L')
DELETE FROM T_CBS_SHARD_CONFIG_TPL_L WHERE FID=1379001352205679616;
IF EXISTS (SELECT 1 FROM KSQL_USERTABLES WHERE KSQL_TABNAME = 'T_CBS_SHARD_CONFIG_TPL_L')
INSERT INTO T_CBS_SHARD_CONFIG_TPL_L (FPKID, FID, FLOCALEID, FNAME) VALUES('2ACNH5VKK/4D', 1379001352205679616, 'zh_CN', '数据追溯来源明细');

