-- 格式定义预置数据脚本，T_INT_FORMATBASE

-- 新增格式 格式-子格式-编码-格式值
--delete from T_INT_FORMATBASE where FID='FID';
--insert into T_INT_FORMATBASE (FID, FCATEGORY, FSUBCATEGORY, FFORMATCODE, FFORMAT, FCOMMENT, FENABLE, FSTATUS, FCREATORID,FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE)
--values('FID','FCATEGORY','FSUBCATEGORY','FFORMATCODE','FFORMAT','FCOMMENT','1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);


-- 日期格式开始
-----------------------------------------------------------------------------------------------------------------

-- 新增格式 DATE-DATE-D0011-dd-MMM-yy
delete from T_INT_FORMATBASE where FID=957941161207559168;
insert into T_INT_FORMATBASE (FID, FCATEGORY, FSUBCATEGORY, FFORMATCODE, FFORMAT, FCOMMENT, FENABLE, FSTATUS, FCREATORID,FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE)
values(957941161207559168,'DATE','DATE','D0011','dd-MMM-yy',' ','1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 新增格式 DATE-DATE-D0012-d MMMM, yyyy
delete from T_INT_FORMATBASE where FID=957941161207556096;
insert into T_INT_FORMATBASE (FID, FCATEGORY, FSUBCATEGORY, FFORMATCODE, FFORMAT, FCOMMENT, FENABLE, FSTATUS, FCREATORID,FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE)
values(957941161207556096,'DATE','DATE','D0012','d MMMM, yyyy',' ','1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 新增格式 DATE-DATE-D0015-d MMMM yyyy 'г.'
-- delete from T_INT_FORMATBASE where FID=957941161207559170;
-- insert into T_INT_FORMATBASE (FID, FCATEGORY, FSUBCATEGORY, FFORMATCODE, FFORMAT, FCOMMENT, FENABLE, FSTATUS, FCREATORID,FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE)
-- values(957941161207559170,'DATE','DATE','D0015','d MMMM yyyy ''г.''',' ','1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 新增格式 DATE-DATE-D0022-d MMMM yyyy
delete from T_INT_FORMATBASE where FID=957941161207556101;
insert into T_INT_FORMATBASE (FID, FCATEGORY, FSUBCATEGORY, FFORMATCODE, FFORMAT, FCOMMENT, FENABLE, FSTATUS, FCREATORID,FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE)
values(957941161207556101,'DATE','DATE','D0022','d MMMM yyyy',' ','1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 新增格式 DATE-DATE-D0023-d' de 'MMMM' de 'yyyy
-- delete from T_INT_FORMATBASE where FID=957941161207559174;
-- insert into T_INT_FORMATBASE (FID, FCATEGORY, FSUBCATEGORY, FFORMATCODE, FFORMAT, FCOMMENT, FENABLE, FSTATUS, FCREATORID,FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE)
-- values(957941161207559174,'DATE','DATE','D0023','d'' de ''MMMM'' de ''yyyy',' ','1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 新增格式 DATE-DATE-D0024-d MMM yyyy
delete from T_INT_FORMATBASE where FID=957941161207556102;
insert into T_INT_FORMATBASE (FID, FCATEGORY, FSUBCATEGORY, FFORMATCODE, FFORMAT, FCOMMENT, FENABLE, FSTATUS, FCREATORID,FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE)
values(957941161207556102,'DATE','DATE','D0024','d MMM yyyy',' ','1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 新增格式 DATE-DATE-D0025-yyyy年MMMd日
delete from T_INT_FORMATBASE where FID=957941161207559175;
insert into T_INT_FORMATBASE (FID, FCATEGORY, FSUBCATEGORY, FFORMATCODE, FFORMAT, FCOMMENT, FENABLE, FSTATUS, FCREATORID,FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE)
values(957941161207559175,'DATE','DATE','D0025','yyyy年MMMd日',' ','1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 新增格式 DATE-DATE-D0027-dd MMMM yyyy
delete from T_INT_FORMATBASE where FID=957941161207559176;
insert into T_INT_FORMATBASE (FID, FCATEGORY, FSUBCATEGORY, FFORMATCODE, FFORMAT, FCOMMENT, FENABLE, FSTATUS, FCREATORID,FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE)
values(957941161207559176,'DATE','DATE','D0027','dd MMMM yyyy',' ','1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 新增格式 DATE-DATE-D0028-dd MMM yyyy
delete from T_INT_FORMATBASE where FID=957941161207556104;
insert into T_INT_FORMATBASE (FID, FCATEGORY, FSUBCATEGORY, FFORMATCODE, FFORMAT, FCOMMENT, FENABLE, FSTATUS, FCREATORID,FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE)
values(957941161207556104,'DATE','DATE','D0028','dd MMM yyyy',' ','1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 新增格式 DATE-DATE-D0030-d MMMM yy
delete from T_INT_FORMATBASE where FID=957941161207556105;
insert into T_INT_FORMATBASE (FID, FCATEGORY, FSUBCATEGORY, FFORMATCODE, FFORMAT, FCOMMENT, FENABLE, FSTATUS, FCREATORID,FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE)
values(957941161207556105,'DATE','DATE','D0030','d MMMM yy',' ','1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 新增格式 DATE-DATE-D0032-yyyy'年'M'月'd'日'
-- delete from T_INT_FORMATBASE where FID=957941412932904960;
-- insert into T_INT_FORMATBASE (FID, FCATEGORY, FSUBCATEGORY, FFORMATCODE, FFORMAT, FCOMMENT, FENABLE, FSTATUS, FCREATORID,FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE)
-- values(957941412932904960,'DATE','DATE','D0032','yyyy''年''M''月''d''日''',' ','1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 新增格式 DATE-DATE-D0033-yyyy'年'MM'月'dd'日'
-- delete from T_INT_FORMATBASE where FID=957941412932908033;
-- insert into T_INT_FORMATBASE (FID, FCATEGORY, FSUBCATEGORY, FFORMATCODE, FFORMAT, FCOMMENT, FENABLE, FSTATUS, FCREATORID,FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE)
-- values(957941412932908033,'DATE','DATE','D0033','yyyy''年''MM''月''dd''日''',' ','1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 新增格式 DATE-DATE-D0037-d MMM yy
delete from T_INT_FORMATBASE where FID=957941412932908035;
insert into T_INT_FORMATBASE (FID, FCATEGORY, FSUBCATEGORY, FFORMATCODE, FFORMAT, FCOMMENT, FENABLE, FSTATUS, FCREATORID,FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE)
values(957941412932908035,'DATE','DATE','D0037','d MMM yy',' ','1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 新增格式 DATE-DATE-D0039-MMMM d, yyyy
delete from T_INT_FORMATBASE where FID=957941412932908036;
insert into T_INT_FORMATBASE (FID, FCATEGORY, FSUBCATEGORY, FFORMATCODE, FFORMAT, FCOMMENT, FENABLE, FSTATUS, FCREATORID,FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE)
values(957941412932908036,'DATE','DATE','D0039','MMMM d, yyyy',' ','1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 新增格式 DATE-DATE-D0042-dd MMMM yyyy 'г.'
-- delete from T_INT_FORMATBASE where FID=957941412932904965;
-- insert into T_INT_FORMATBASE (FID, FCATEGORY, FSUBCATEGORY, FFORMATCODE, FFORMAT, FCOMMENT, FENABLE, FSTATUS, FCREATORID,FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE)
-- values(957941412932904965,'DATE','DATE','D0042','dd MMMM yyyy ''г.''',' ','1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 时间格式开始
-----------------------------------------------------------------------------------------------------------------

-- 新增格式 TIME-TIME-T0009-HH'H'mm
-- delete from T_INT_FORMATBASE where FID=957945024698414081;
-- insert into T_INT_FORMATBASE (FID, FCATEGORY, FSUBCATEGORY, FFORMATCODE, FFORMAT, FCOMMENT, FENABLE, FSTATUS, FCREATORID,FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE)
-- values(957945024698414081,'TIME','TIME','T0009','HH''H''mm',' ','1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 新增格式 TIME-TIME-T0016-HH'h'mm
-- delete from T_INT_FORMATBASE where FID=957945024706799618;
-- insert into T_INT_FORMATBASE (FID, FCATEGORY, FSUBCATEGORY, FFORMATCODE, FFORMAT, FCOMMENT, FENABLE, FSTATUS, FCREATORID,FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE)
-- values(957945024706799618,'TIME','TIME','T0016','HH''h''mm',' ','1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 新增格式 TIME-TIME-T0020-HH' h 'mm
-- delete from T_INT_FORMATBASE where FID=957945024706799620;
-- insert into T_INT_FORMATBASE (FID, FCATEGORY, FSUBCATEGORY, FFORMATCODE, FFORMAT, FCOMMENT, FENABLE, FSTATUS, FCREATORID,FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE)
-- values(957945024706799620,'TIME','TIME','T0020','HH'' h ''mm',' ','1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 新增格式 TIME-TIME-T0021-HH'H'mm.ss
-- delete from T_INT_FORMATBASE where FID=957945024706802692;
-- insert into T_INT_FORMATBASE (FID, FCATEGORY, FSUBCATEGORY, FFORMATCODE, FFORMAT, FCOMMENT, FENABLE, FSTATUS, FCREATORID,FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE)
-- values(957945024706802692,'TIME','TIME','T0021','HH''H''mm.ss',' ','1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);





