DELETE FROM t_bas_importtemplate
WHERE fid=1817341281373335552;

INSERT INTO t_bas_importtemplate
(fid, fcreatetime, fmodifytime, fmodifierid, fnumber, fbizobject, fstatus, fcreatorid, fenable, fcomment, fmasterid, ftemplatetype, fenableimport, fname, fapplyscope, fenablesetnull, fhidefieldrow, fexchangenameandmark, fsplitsubentries, foverrideentry, fforupdatemultilangfields, fplugin)
VALUES(1817341281373335552, {ts'2023-11-13 10:43:01'}, {ts'2023-11-30 19:27:00'}, 13466739, 'bas_immapping_IMPT_number', 'bas_immapping', 'C', 13466739, '1', ' ', 1817341281373335552, 'IMPT', '1', '通过用户工号引入模板', '0', '1', '0', '0', '0', '0', '0', ' ');

DELETE FROM t_bas_importtemplate_l
WHERE fpkid='3P7PDZCO2N0L';
DELETE FROM t_bas_importtemplate_l
WHERE fpkid='3P7PDZCO2N0M';

INSERT INTO t_bas_importtemplate_l
(fpkid, fid, flocaleid, fname, fcomment)
VALUES('3P7PDZCO2N0L', 1817341281373335552, 'zh_CN', '通过用户工号引入模板', ' ');
INSERT INTO t_bas_importtemplate_l
(fpkid, fid, flocaleid, fname, fcomment)
VALUES('3P7PDZCO2N0M', 1817341281373335552, 'zh_TW', '通過用戶工號引入模板', ' ');

DELETE FROM t_bas_importtemplateentry
WHERE fentryid=1817337352894511107;
DELETE FROM t_bas_importtemplateentry
WHERE fentryid=1817337352912711690;
DELETE FROM t_bas_importtemplateentry
WHERE fentryid=1817337352921100288;
DELETE FROM t_bas_importtemplateentry
WHERE fentryid=1817337352928065536;
DELETE FROM t_bas_importtemplateentry
WHERE fentryid=1817337352929488899;
DELETE FROM t_bas_importtemplateentry
WHERE fentryid=1817337352961619968;
DELETE FROM t_bas_importtemplateentry
WHERE fentryid=1817337352971431936;
DELETE FROM t_bas_importtemplateentry
WHERE fentryid=1817337352970008579;
DELETE FROM t_bas_importtemplateentry
WHERE fentryid=1817337352936454146;
DELETE FROM t_bas_importtemplateentry
WHERE fentryid=1817337352954654720;
DELETE FROM t_bas_importtemplateentry
WHERE fentryid=1817337352979820546;
DELETE FROM t_bas_importtemplateentry
WHERE fentryid=1817337352844179456;

INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop, fcolwidth, fsourceentity, fsourcename, fexportformat, fexportformatname, fisdate)
VALUES(1817341281373335552, 1817337352894511107, 1817337352844179456, 2, 'billhead', NULL, '0', ' ', '0', '0', ' ', ' ', 0, ' ', ' ', ' ', ' ', '0');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop, fcolwidth, fsourceentity, fsourcename, fexportformat, fexportformatname, fisdate)
VALUES(1817341281373335552, 1817337352912711690, 1817337352894511107, 3, 'id', NULL, '0', ' ', '0', '1', ' ', ' ', 0, ' ', ' ', ' ', ' ', '0');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop, fcolwidth, fsourceentity, fsourcename, fexportformat, fexportformatname, fisdate)
VALUES(1817341281373335552, 1817337352921100288, 1817337352894511107, 4, 'userid', NULL, '0', ' ', '0', '1', ' ', ' ', 0, ' ', ' ', ' ', ' ', '0');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop, fcolwidth, fsourceentity, fsourcename, fexportformat, fexportformatname, fisdate)
VALUES(1817341281373335552, 1817337352928065536, 1817337352894511107, 5, 'thirdappcorpid', NULL, '1', ' ', '1', '1', ' ', ' ', 0, ' ', ' ', ' ', ' ', '0');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop, fcolwidth, fsourceentity, fsourcename, fexportformat, fexportformatname, fisdate)
VALUES(1817341281373335552, 1817337352929488899, 1817337352894511107, 6, 'openid', NULL, '1', ' ', '1', '1', ' ', ' ', 0, ' ', ' ', ' ', ' ', '0');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop, fcolwidth, fsourceentity, fsourcename, fexportformat, fexportformatname, fisdate)
VALUES(1817341281373335552, 1817337352961619968, 1817337352894511107, 9, 'encryopenid', NULL, '0', ' ', '0', '1', ' ', ' ', 0, ' ', ' ', ' ', ' ', '0');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop, fcolwidth, fsourceentity, fsourcename, fexportformat, fexportformatname, fisdate)
VALUES(1817341281373335552, 1817337352971431936, 1817337352894511107, 10, 'thirdappusername', NULL, '0', ' ', '1', '1', ' ', ' ', 0, ' ', ' ', ' ', ' ', '0');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop, fcolwidth, fsourceentity, fsourcename, fexportformat, fexportformatname, fisdate)
VALUES(1817341281373335552, 1817337352970008579, 1817337352894511107, 11, 'third_user_phone_num', NULL, '0', ' ', '1', '1', ' ', ' ', 0, ' ', ' ', ' ', ' ', '0');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop, fcolwidth, fsourceentity, fsourcename, fexportformat, fexportformatname, fisdate)
VALUES(1817341281373335552, 1817337352936454146, 1817337352894511107, 7, 'user', NULL, '1', ' ', '1', '1', 'number', 'number', 0, ' ', ' ', ' ', ' ', '0');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop, fcolwidth, fsourceentity, fsourcename, fexportformat, fexportformatname, fisdate)
VALUES(1817341281373335552, 1817337352954654720, 1817337352894511107, 8, 'imtype', NULL, '1', ' ', '1', '1', 'name', 'name', 0, ' ', ' ', ' ', ' ', '0');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop, fcolwidth, fsourceentity, fsourcename, fexportformat, fexportformatname, fisdate)
VALUES(1817341281373335552, 1817337352979820546, 1817337352894511107, 12, 'createdate', NULL, '0', ' ', '0', '1', ' ', ' ', 0, ' ', ' ', 'dateformat1', 'YYYY-MM-dd', '1');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop, fcolwidth, fsourceentity, fsourcename, fexportformat, fexportformatname, fisdate)
VALUES(1817341281373335552, 1817337352844179456, 0, 1, 'bas_immapping', NULL, '0', ' ', '0', '0', ' ', ' ', 0, ' ', ' ', ' ', ' ', '0');


DELETE FROM t_bas_importtemplate
WHERE fid=1817484616805199872;

INSERT INTO t_bas_importtemplate
(fid, fcreatetime, fmodifytime, fmodifierid, fnumber, fbizobject, fstatus, fcreatorid, fenable, fcomment, fmasterid, ftemplatetype, fenableimport, fname, fapplyscope, fenablesetnull, fhidefieldrow, fexchangenameandmark, fsplitsubentries, foverrideentry, fforupdatemultilangfields, fplugin)
VALUES(1817484616805199872, {ts'2023-11-13 15:34:30'}, {ts'2023-11-30 19:28:19'}, 13466739, 'bas_immapping_IMPT_phone', 'bas_immapping', 'C', 13466739, '1', ' ', 1817484616805199872, 'IMPT', '1', '通过第三方手机号引入模板', '0', '1', '0', '0', '0', '0', '0', ' ');

DELETE FROM t_bas_importtemplate_l
WHERE fpkid='3P8D6A3YQ=Q=';
DELETE FROM t_bas_importtemplate_l
WHERE fpkid='3P8D6A3YQ=QA';

INSERT INTO t_bas_importtemplate_l
(fpkid, fid, flocaleid, fname, fcomment)
VALUES('3P8D6A3YQ=Q=', 1817484616805199872, 'zh_CN', '通过第三方手机号引入模板', ' ');
INSERT INTO t_bas_importtemplate_l
(fpkid, fid, flocaleid, fname, fcomment)
VALUES('3P8D6A3YQ=QA', 1817484616805199872, 'zh_TW', '通過第三方手機號引入模板', ' ');

DELETE FROM t_bas_importtemplateentry
WHERE fentryid=1817483775251656704;
DELETE FROM t_bas_importtemplateentry
WHERE fentryid=1817483775250233347;
DELETE FROM t_bas_importtemplateentry
WHERE fentryid=1817483775260045314;
DELETE FROM t_bas_importtemplateentry
WHERE fentryid=1817483775275399171;
DELETE FROM t_bas_importtemplateentry
WHERE fentryid=1817483775285211138;
DELETE FROM t_bas_importtemplateentry
WHERE fentryid=1817483775292176384;
DELETE FROM t_bas_importtemplateentry
WHERE fentryid=1817483775293599747;
DELETE FROM t_bas_importtemplateentry
WHERE fentryid=1817483775183124480;
DELETE FROM t_bas_importtemplateentry
WHERE fentryid=1817483775233456134;
DELETE FROM t_bas_importtemplateentry
WHERE fentryid=1817483775243268108;
DELETE FROM t_bas_importtemplateentry
WHERE fentryid=1817483775267010560;
DELETE FROM t_bas_importtemplateentry
WHERE fentryid=1817483775276822528;

INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop, fcolwidth, fsourceentity, fsourcename, fexportformat, fexportformatname, fisdate)
VALUES(1817484616805199872, 1817483775251656704, 1817483775233456134, 4, 'userid', NULL, '0', ' ', '0', '1', ' ', ' ', 0, ' ', ' ', ' ', ' ', '0');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop, fcolwidth, fsourceentity, fsourcename, fexportformat, fexportformatname, fisdate)
VALUES(1817484616805199872, 1817483775250233347, 1817483775233456134, 5, 'thirdappcorpid', NULL, '1', ' ', '1', '1', ' ', ' ', 0, ' ', ' ', ' ', ' ', '0');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop, fcolwidth, fsourceentity, fsourcename, fexportformat, fexportformatname, fisdate)
VALUES(1817484616805199872, 1817483775260045314, 1817483775233456134, 6, 'openid', NULL, '1', ' ', '1', '1', ' ', ' ', 0, ' ', ' ', ' ', ' ', '0');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop, fcolwidth, fsourceentity, fsourcename, fexportformat, fexportformatname, fisdate)
VALUES(1817484616805199872, 1817483775275399171, 1817483775233456134, 9, 'encryopenid', NULL, '0', ' ', '0', '1', ' ', ' ', 0, ' ', ' ', ' ', ' ', '0');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop, fcolwidth, fsourceentity, fsourcename, fexportformat, fexportformatname, fisdate)
VALUES(1817484616805199872, 1817483775285211138, 1817483775233456134, 10, 'thirdappusername', NULL, '0', ' ', '1', '1', ' ', ' ', 0, ' ', ' ', ' ', ' ', '0');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop, fcolwidth, fsourceentity, fsourcename, fexportformat, fexportformatname, fisdate)
VALUES(1817484616805199872, 1817483775292176384, 1817483775233456134, 11, 'third_user_phone_num', NULL, '1', ' ', '1', '1', ' ', ' ', 0, ' ', ' ', ' ', ' ', '0');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop, fcolwidth, fsourceentity, fsourcename, fexportformat, fexportformatname, fisdate)
VALUES(1817484616805199872, 1817483775293599747, 1817483775233456134, 12, 'createdate', NULL, '0', ' ', '0', '1', ' ', ' ', 0, ' ', ' ', 'dateformat1', 'YYYY-MM-dd', '1');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop, fcolwidth, fsourceentity, fsourcename, fexportformat, fexportformatname, fisdate)
VALUES(1817484616805199872, 1817483775183124480, 0, 1, 'bas_immapping', NULL, '0', ' ', '0', '0', ' ', ' ', 0, ' ', ' ', ' ', ' ', '0');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop, fcolwidth, fsourceentity, fsourcename, fexportformat, fexportformatname, fisdate)
VALUES(1817484616805199872, 1817483775233456134, 1817483775183124480, 2, 'billhead', NULL, '0', ' ', '0', '0', ' ', ' ', 0, ' ', ' ', ' ', ' ', '0');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop, fcolwidth, fsourceentity, fsourcename, fexportformat, fexportformatname, fisdate)
VALUES(1817484616805199872, 1817483775243268108, 1817483775233456134, 3, 'id', NULL, '0', ' ', '0', '1', ' ', ' ', 0, ' ', ' ', ' ', ' ', '0');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop, fcolwidth, fsourceentity, fsourcename, fexportformat, fexportformatname, fisdate)
VALUES(1817484616805199872, 1817483775267010560, 1817483775233456134, 7, 'user', NULL, '0', ' ', '0', '1', 'number', 'number', 0, ' ', ' ', ' ', ' ', '0');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop, fcolwidth, fsourceentity, fsourcename, fexportformat, fexportformatname, fisdate)
VALUES(1817484616805199872, 1817483775276822528, 1817483775233456134, 8, 'imtype', NULL, '1', ' ', '1', '1', 'name', 'name', 0, ' ', ' ', ' ', ' ', '0');