/* 部分基础资料发现存在垃圾数据，需要删掉 12是台币， 11是马来西亚林吉特 */
delete from t_bd_currency_l where fid = 12 and fpkid = 'J837E6FN/JF';
delete from t_bd_currency_l where fid = 12 and fpkid = 'J837E6FN/JG';
delete from t_bd_currency_l where fid = 11 and fpkid = 'J83643UPE=A';
delete from t_bd_currency_l where fid = 11 and fpkid = 'J83643UPE=B';


/* 某些中国的行政级次的历史数据有问题，所以 重新预置一下*/
DELETE FROM t_bd_admindivisionlevel WHERE fid in (1,2,3);
INSERT INTO t_bd_admindivisionlevel(FID, FCOUNTRYID, FNUMBER, FLONGNUMBER, FPARENTID, FLEVEL, FISLEAF, FISSYSTEM, FENABLE, FSTATUS, FCREATORID, FCREATETIME, FMODIFIERID, FMODIFYTIME, FISCITY, FDISABLERID, FDISABLEDATE, FMASTERID) VALUES (1, 1000001, '001', '1', 0, 1, '0', '1', '1', 'C', 1, {ts'2018-03-05 00:00:00'}, 1, {ts'2018-03-05 00:00:00'}, '0', 0, NULL, 1);
INSERT INTO t_bd_admindivisionlevel(FID, FCOUNTRYID, FNUMBER, FLONGNUMBER, FPARENTID, FLEVEL, FISLEAF, FISSYSTEM, FENABLE, FSTATUS, FCREATORID, FCREATETIME, FMODIFIERID, FMODIFYTIME, FISCITY, FDISABLERID, FDISABLEDATE, FMASTERID) VALUES (2, 1000001, '002', '1!2', 1, 2, '0', '1', '1', 'C', 1, {ts'2018-03-05 00:00:00'}, 1, {ts'2018-03-05 00:00:00'}, '1', 0, NULL, 2);
INSERT INTO t_bd_admindivisionlevel(FID, FCOUNTRYID, FNUMBER, FLONGNUMBER, FPARENTID, FLEVEL, FISLEAF, FISSYSTEM, FENABLE, FSTATUS, FCREATORID, FCREATETIME, FMODIFIERID, FMODIFYTIME, FISCITY, FDISABLERID, FDISABLEDATE, FMASTERID) VALUES (3, 1000001, '003', '1!2!3', 2, 3, '1', '1', '1', 'C', 1, {ts'2018-03-05 00:00:00'}, 1, {ts'2018-03-05 00:00:00'}, '0', 0, NULL, 3);