-- 本地化格式预置数据脚本，T_INT_FORMATLOCALE


-- 新增本地化格式 地区编码-格式子目录-格式值-顺序
--delete from T_INT_FORMATLOCALE where FID=952696647173855240;
--insert into T_INT_FORMATLOCALE (FID, FFORMATID, FPLANID, FORDERSEQ, FENABLE, FSTATUS, FCREATORID,FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE)
--values(952696647173855240,952696647173855240,952696647173855240,1,'1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 新增日期，时间格式及顺序
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------

-- 新增本地化格式 zh-CN-DATE-yyyy'年'M'月'd'日'-11
-- delete from T_INT_FORMATLOCALE where FID=960880670068965376;
-- insert into T_INT_FORMATLOCALE (FID, FFORMATID, FPLANID, FORDERSEQ, FENABLE, FSTATUS, FCREATORID,FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE)
-- values(960880670068965376,957941412932904960,494148073165990912,11,'1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 新增本地化格式 zh-CN-DATE-yyyy年MMMd日-12
delete from T_INT_FORMATLOCALE where FID=960880671050451968;
insert into T_INT_FORMATLOCALE (FID, FFORMATID, FPLANID, FORDERSEQ, FENABLE, FSTATUS, FCREATORID,FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE)
values(960880671050451968,957941161207559175,494148073165990912,12,'1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 新增本地化格式 zh-TW-DATE-yyyy'年'M'月'd'日'-4
-- delete from T_INT_FORMATLOCALE where FID=960880694647586816;
-- insert into T_INT_FORMATLOCALE (FID, FFORMATID, FPLANID, FORDERSEQ, FENABLE, FSTATUS, FCREATORID,FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE)
-- values(960880694647586816,957941412932904960,494164077380137984,4,'1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 新增本地化格式 zh-TW-DATE-yyyy'年'MM'月'dd'日'-5
-- delete from T_INT_FORMATLOCALE where FID=960880695629073408;
-- insert into T_INT_FORMATLOCALE (FID, FFORMATID, FPLANID, FORDERSEQ, FENABLE, FSTATUS, FCREATORID,FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE)
-- values(960880695629073408,957941412932908033,494164077380137984,5,'1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 新增本地化格式 zh-TW-DATE-yyyy年MMMd日-6
delete from T_INT_FORMATLOCALE where FID=960880696652464128;
insert into T_INT_FORMATLOCALE (FID, FFORMATID, FPLANID, FORDERSEQ, FENABLE, FSTATUS, FCREATORID,FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE)
values(960880696652464128,957941161207559175,494164077380137984,6,'1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 新增本地化格式 en-US-DATE-dd-MMM-yy-7
delete from T_INT_FORMATLOCALE where FID=960880711131220992;
insert into T_INT_FORMATLOCALE (FID, FFORMATID, FPLANID, FORDERSEQ, FENABLE, FSTATUS, FCREATORID,FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE)
values(960880711131220992,957941161207559168,494169431241421824,7,'1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 新增本地化格式 en-US-DATE-MMMM d, yyyy-8
delete from T_INT_FORMATLOCALE where FID=960880711978450944;
insert into T_INT_FORMATLOCALE (FID, FFORMATID, FPLANID, FORDERSEQ, FENABLE, FSTATUS, FCREATORID,FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE)
values(960880711978450944,957941412932908036,494169431241421824,8,'1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 新增本地化格式 en-US-DATE-d MMMM, yyyy-9
delete from T_INT_FORMATLOCALE where FID=960880712909605888;
insert into T_INT_FORMATLOCALE (FID, FFORMATID, FPLANID, FORDERSEQ, FENABLE, FSTATUS, FCREATORID,FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE)
values(960880712909605888,957941161207556096,494169431241421824,9,'1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 新增本地化格式 en-GB-DATE-dd MMMM yyyy-6
delete from T_INT_FORMATLOCALE where FID=960880727212182528;
insert into T_INT_FORMATLOCALE (FID, FFORMATID, FPLANID, FORDERSEQ, FENABLE, FSTATUS, FCREATORID,FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE)
values(960880727212182528,957941161207559176,494171866294940672,6,'1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 新增本地化格式 en-GB-DATE-d MMMM yyyy-7
delete from T_INT_FORMATLOCALE where FID=960880728160075776;
insert into T_INT_FORMATLOCALE (FID, FFORMATID, FPLANID, FORDERSEQ, FENABLE, FSTATUS, FCREATORID,FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE)
values(960880728160075776,957941161207556101,494171866294940672,7,'1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 新增本地化格式 fr-FR-DATE-d MMMM yyyy-6
delete from T_INT_FORMATLOCALE where FID=960880744568193024;
insert into T_INT_FORMATLOCALE (FID, FFORMATID, FPLANID, FORDERSEQ, FENABLE, FSTATUS, FCREATORID,FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE)
values(960880744568193024,957941161207556101,494173979016197120,6,'1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 新增本地化格式 fr-FR-DATE-d MMM yy-7
delete from T_INT_FORMATLOCALE where FID=960880746069773312;
insert into T_INT_FORMATLOCALE (FID, FFORMATID, FPLANID, FORDERSEQ, FENABLE, FSTATUS, FCREATORID,FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE)
values(960880746069773312,957941412932908035,494173979016197120,7,'1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 新增本地化格式 fr-FR-TIME-HH' h 'mm-4
-- delete from T_INT_FORMATLOCALE where FID=960880751899855872;
-- insert into T_INT_FORMATLOCALE (FID, FFORMATID, FPLANID, FORDERSEQ, FENABLE, FSTATUS, FCREATORID,FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE)
-- values(960880751899855872,957945024706799620,494173979016197120,4,'1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 新增本地化格式 fr-FR-TIME-HH'h'mm-5
-- delete from T_INT_FORMATLOCALE where FID=960880753451728896;
-- insert into T_INT_FORMATLOCALE (FID, FFORMATID, FPLANID, FORDERSEQ, FENABLE, FSTATUS, FCREATORID,FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE)
-- values(960880753451728896,957945024706799618,494173979016197120,5,'1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 新增本地化格式 es-ES-DATE-d' de 'MMMM' de 'yyyy-9
-- delete from T_INT_FORMATLOCALE where FID=960880768215698432;
-- insert into T_INT_FORMATLOCALE (FID, FFORMATID, FPLANID, FORDERSEQ, FENABLE, FSTATUS, FCREATORID,FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE)
-- values(960880768215698432,957941161207559174,686125702319208448,9,'1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 新增本地化格式 es-ES-TIME-HH'H'mm-5
-- delete from T_INT_FORMATLOCALE where FID=960880775136280576;
-- insert into T_INT_FORMATLOCALE (FID, FFORMATID, FPLANID, FORDERSEQ, FENABLE, FSTATUS, FCREATORID,FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE)
-- values(960880775136280576,957945024698414081,686125702319208448,5,'1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 新增本地化格式 es-ES-TIME-HH'H'mm.ss-10
-- delete from T_INT_FORMATLOCALE where FID=960880780303682560;
-- insert into T_INT_FORMATLOCALE (FID, FFORMATID, FPLANID, FORDERSEQ, FENABLE, FSTATUS, FCREATORID,FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE)
-- values(960880780303682560,957945024706802692,686125702319208448,10,'1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 新增本地化格式 ru-RU-DATE-d MMMM yyyy 'г.'-6
-- delete from T_INT_FORMATLOCALE where FID=960880786242817024;
-- insert into T_INT_FORMATLOCALE (FID, FFORMATID, FPLANID, FORDERSEQ, FENABLE, FSTATUS, FCREATORID,FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE)
-- values(960880786242817024,957941161207559170,686114583571625984,6,'1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 新增本地化格式 ru-RU-DATE-dd MMMM yyyy 'г.'-7
-- delete from T_INT_FORMATLOCALE where FID=960880787165544448;
-- insert into T_INT_FORMATLOCALE (FID, FFORMATID, FPLANID, FORDERSEQ, FENABLE, FSTATUS, FCREATORID,FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE)
-- values(960880787165544448,957941412932904965,686114583571625984,7,'1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 新增本地化格式 pt-PT-DATE-d' de 'MMMM' de 'yyyy-13
-- delete from T_INT_FORMATLOCALE where FID=960880807172374528;
-- insert into T_INT_FORMATLOCALE (FID, FFORMATID, FPLANID, FORDERSEQ, FENABLE, FSTATUS, FCREATORID,FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE)
-- values(960880807172374528,957941161207559174,960733959111576576,13,'1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 新增本地化格式 th_TH-DATE-d MMM yyyy-5
delete from T_INT_FORMATLOCALE where FID=960880815711996928;
insert into T_INT_FORMATLOCALE (FID, FFORMATID, FPLANID, FORDERSEQ, FENABLE, FSTATUS, FCREATORID,FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE)
values(960880815711996928,957941161207556102,494160745928356864,5,'1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 新增本地化格式 th_TH-DATE-dd MMM yyyy-6
delete from T_INT_FORMATLOCALE where FID=960880817054154752;
insert into T_INT_FORMATLOCALE (FID, FFORMATID, FPLANID, FORDERSEQ, FENABLE, FSTATUS, FCREATORID,FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE)
values(960880817054154752,957941161207556104,494160745928356864,6,'1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 新增本地化格式 th_TH-DATE-d MMMM yy-8
delete from T_INT_FORMATLOCALE where FID=960880819595902976;
insert into T_INT_FORMATLOCALE (FID, FFORMATID, FPLANID, FORDERSEQ, FENABLE, FSTATUS, FCREATORID,FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE)
values(960880819595902976,957941161207556105,494160745928356864,8,'1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

