-- 格式定义预置数据脚本，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);

-- 新加formatplan-葡萄牙
DELETE FROM T_INT_FORMATPLAN WHERE FID = 960733959111576576;
INSERT INTO T_INT_FORMATPLAN(FID,FPMSIGN,FZEROSHOW,FNEGATIVEFORMAT,FCNYSHOWPREFIX,FAMSIGN,FDATEFORMAT,FCURRSIGN,FNUMBER,FCURRPOSFORMAT,FDECIMALPOINT,FNUMGROUPFORMAT,FNUMSEPARATOR,FDEMOCURRENCY,FNEGATIVESIGN,FCURRNEGFORMAT,FISDEFAULT,FTIMEFORMAT) 
VALUES (960733959111576576,'PM','1','-,','1','AM','dd/MM/yyyy','¥','pt-PT',', ¥',',','123,456,789','b',7,null,'-, ¥','0','HH:mm'); 

DELETE FROM T_INT_FORMATPLAN_L WHERE FPKID = '1//CYERYB0TY';
INSERT INTO T_INT_FORMATPLAN_L(FPKID,FID,FLOCALEID,FNAME,FDESCRIPTION) VALUES ('1//CYERYB0TY',960733959111576576,'zh_CN','葡萄牙语(葡萄牙)',' '); 

-- 日期格式开始
-----------------------------------------------------------------------------------------------------------------
-- 新增格式 DATE-DATE-D0001-yyyy-MM-dd
delete from `T_INT_FORMATBASE` where FID=952696647173851136;
insert into `T_INT_FORMATBASE` (`FID`, `FCATEGORY`, `FSUBCATEGORY`, `FFORMATCODE`, `FFORMAT`, `FCOMMENT`, `FENABLE`, `FSTATUS`, `FCREATORID`,`FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`)
values(952696647173851136,'DATE','DATE','D0001','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-D0002-dd-MM-yyyy
delete from `T_INT_FORMATBASE` where FID=952696647173855233;
insert into `T_INT_FORMATBASE` (`FID`, `FCATEGORY`, `FSUBCATEGORY`, `FFORMATCODE`, `FFORMAT`, `FCOMMENT`, `FENABLE`, `FSTATUS`, `FCREATORID`,`FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`)
values(952696647173855233,'DATE','DATE','D0002','dd-MM-yyyy',' ','1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

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

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

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

-- 新增格式 DATE-DATE-D0006-yyyy/MM/dd
delete from `T_INT_FORMATBASE` where FID=952696647173855235;
insert into `T_INT_FORMATBASE` (`FID`, `FCATEGORY`, `FSUBCATEGORY`, `FFORMATCODE`, `FFORMAT`, `FCOMMENT`, `FENABLE`, `FSTATUS`, `FCREATORID`,`FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`)
values(952696647173855235,'DATE','DATE','D0006','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-D0007-d/MM/yyyy
delete from `T_INT_FORMATBASE` where FID=952696647173851139;
insert into `T_INT_FORMATBASE` (`FID`, `FCATEGORY`, `FSUBCATEGORY`, `FFORMATCODE`, `FFORMAT`, `FCOMMENT`, `FENABLE`, `FSTATUS`, `FCREATORID`,`FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`)
values(952696647173851139,'DATE','DATE','D0007','d/MM/yyyy',' ','1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 新增格式 DATE-DATE-D0008-yyyy/M/d
delete from `T_INT_FORMATBASE` where FID=952696647173855236;
insert into `T_INT_FORMATBASE` (`FID`, `FCATEGORY`, `FSUBCATEGORY`, `FFORMATCODE`, `FFORMAT`, `FCOMMENT`, `FENABLE`, `FSTATUS`, `FCREATORID`,`FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`)
values(952696647173855236,'DATE','DATE','D0008','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-D0009-M/d/yyyy
delete from `T_INT_FORMATBASE` where FID=952696647173851140;
insert into `T_INT_FORMATBASE` (`FID`, `FCATEGORY`, `FSUBCATEGORY`, `FFORMATCODE`, `FFORMAT`, `FCOMMENT`, `FENABLE`, `FSTATUS`, `FCREATORID`,`FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`)
values(952696647173851140,'DATE','DATE','D0009','M/d/yyyy',' ','1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 新增格式 DATE-DATE-D0010-dd.MM.yyyy
delete from `T_INT_FORMATBASE` where FID=952696647173855237;
insert into `T_INT_FORMATBASE` (`FID`, `FCATEGORY`, `FSUBCATEGORY`, `FFORMATCODE`, `FFORMAT`, `FCOMMENT`, `FENABLE`, `FSTATUS`, `FCREATORID`,`FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`)
values(952696647173855237,'DATE','DATE','D0010','dd.MM.yyyy',' ','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-D0013-M/d/yy
delete from `T_INT_FORMATBASE` where FID=957941161207559169;
insert into `T_INT_FORMATBASE` (`FID`, `FCATEGORY`, `FSUBCATEGORY`, `FFORMATCODE`, `FFORMAT`, `FCOMMENT`, `FENABLE`, `FSTATUS`, `FCREATORID`,`FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`)
values(957941161207559169,'DATE','DATE','D0013','M/d/yy',' ','1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 新增格式 DATE-DATE-D0014-dd.MM.yy
delete from `T_INT_FORMATBASE` where FID=957941161207556097;
insert into `T_INT_FORMATBASE` (`FID`, `FCATEGORY`, `FSUBCATEGORY`, `FFORMATCODE`, `FFORMAT`, `FCOMMENT`, `FENABLE`, `FSTATUS`, `FCREATORID`,`FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`)
values(957941161207556097,'DATE','DATE','D0014','dd.MM.yy',' ','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-D0016-d/MM/yy
delete from `T_INT_FORMATBASE` where FID=957941161207556098;
insert into `T_INT_FORMATBASE` (`FID`, `FCATEGORY`, `FSUBCATEGORY`, `FFORMATCODE`, `FFORMAT`, `FCOMMENT`, `FENABLE`, `FSTATUS`, `FCREATORID`,`FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`)
values(957941161207556098,'DATE','DATE','D0016','d/MM/yy',' ','1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

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

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

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

-- 新增格式 DATE-DATE-D0020-yyyy.MM.dd
delete from `T_INT_FORMATBASE` where FID=957941161207556100;
insert into `T_INT_FORMATBASE` (`FID`, `FCATEGORY`, `FSUBCATEGORY`, `FFORMATCODE`, `FFORMAT`, `FCOMMENT`, `FENABLE`, `FSTATUS`, `FCREATORID`,`FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`)
values(957941161207556100,'DATE','DATE','D0020','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-D0021-yy-M-d
delete from `T_INT_FORMATBASE` where FID=957941161207559173;
insert into `T_INT_FORMATBASE` (`FID`, `FCATEGORY`, `FSUBCATEGORY`, `FFORMATCODE`, `FFORMAT`, `FCOMMENT`, `FENABLE`, `FSTATUS`, `FCREATORID`,`FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`)
values(957941161207559173,'DATE','DATE','D0021','yy-M-d',' ','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-D0026-dd/MM/yy
delete from `T_INT_FORMATBASE` where FID=957941161207556103;
insert into `T_INT_FORMATBASE` (`FID`, `FCATEGORY`, `FSUBCATEGORY`, `FFORMATCODE`, `FFORMAT`, `FCOMMENT`, `FENABLE`, `FSTATUS`, `FCREATORID`,`FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`)
values(957941161207556103,'DATE','DATE','D0026','dd/MM/yy',' ','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-D0029-yy.MM.dd
delete from `T_INT_FORMATBASE` where FID=957941161207559177;
insert into `T_INT_FORMATBASE` (`FID`, `FCATEGORY`, `FSUBCATEGORY`, `FFORMATCODE`, `FFORMAT`, `FCOMMENT`, `FENABLE`, `FSTATUS`, `FCREATORID`,`FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`)
values(957941161207559177,'DATE','DATE','D0029','yy.MM.dd',' ','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-D0031-MM/dd/yyyy
delete from `T_INT_FORMATBASE` where FID=957941412932908032;
insert into `T_INT_FORMATBASE` (`FID`, `FCATEGORY`, `FSUBCATEGORY`, `FFORMATCODE`, `FFORMAT`, `FCOMMENT`, `FENABLE`, `FSTATUS`, `FCREATORID`,`FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`)
values(957941412932908032,'DATE','DATE','D0031','MM/dd/yyyy',' ','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-D0034-d-M-yy
delete from `T_INT_FORMATBASE` where FID=957941412932904961;
insert into `T_INT_FORMATBASE` (`FID`, `FCATEGORY`, `FSUBCATEGORY`, `FFORMATCODE`, `FFORMAT`, `FCOMMENT`, `FENABLE`, `FSTATUS`, `FCREATORID`,`FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`)
values(957941412932904961,'DATE','DATE','D0034','d-M-yy',' ','1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 新增格式 DATE-DATE-D0035-yyyy.M.d
delete from `T_INT_FORMATBASE` where FID=957941412932908034;
insert into `T_INT_FORMATBASE` (`FID`, `FCATEGORY`, `FSUBCATEGORY`, `FFORMATCODE`, `FFORMAT`, `FCOMMENT`, `FENABLE`, `FSTATUS`, `FCREATORID`,`FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`)
values(957941412932908034,'DATE','DATE','D0035','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-D0036-yyyy年M月d日
delete from `T_INT_FORMATBASE` where FID=957941412932904962;
insert into `T_INT_FORMATBASE` (`FID`, `FCATEGORY`, `FSUBCATEGORY`, `FFORMATCODE`, `FFORMAT`, `FCOMMENT`, `FENABLE`, `FSTATUS`, `FCREATORID`,`FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`)
values(957941412932904962,'DATE','DATE','D0036','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-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-D0038-yyyy-M-d
delete from `T_INT_FORMATBASE` where FID=957941412932904963;
insert into `T_INT_FORMATBASE` (`FID`, `FCATEGORY`, `FSUBCATEGORY`, `FFORMATCODE`, `FFORMAT`, `FCOMMENT`, `FENABLE`, `FSTATUS`, `FCREATORID`,`FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`)
values(957941412932904963,'DATE','DATE','D0038','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-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-D0040-d/M/yy
delete from `T_INT_FORMATBASE` where FID=957941412932904964;
insert into `T_INT_FORMATBASE` (`FID`, `FCATEGORY`, `FSUBCATEGORY`, `FFORMATCODE`, `FFORMAT`, `FCOMMENT`, `FENABLE`, `FSTATUS`, `FCREATORID`,`FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`)
values(957941412932904964,'DATE','DATE','D0040','d/M/yy',' ','1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 新增格式 DATE-DATE-D0041-yy/MM/dd
delete from `T_INT_FORMATBASE` where FID=957941412932908037;
insert into `T_INT_FORMATBASE` (`FID`, `FCATEGORY`, `FSUBCATEGORY`, `FFORMATCODE`, `FFORMAT`, `FCOMMENT`, `FENABLE`, `FSTATUS`, `FCREATORID`,`FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`)
values(957941412932908037,'DATE','DATE','D0041','yy/MM/dd',' ','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);

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

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

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


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

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

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

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

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

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

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

-- 新增格式 TIME-TIME-T0008-ah:mm:ss
delete from `T_INT_FORMATBASE` where FID=957945024698411008;
insert into `T_INT_FORMATBASE` (`FID`, `FCATEGORY`, `FSUBCATEGORY`, `FFORMATCODE`, `FFORMAT`, `FCOMMENT`, `FENABLE`, `FSTATUS`, `FCREATORID`,`FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`)
values(957945024698411008,'TIME','TIME','T0008','ah:mm:ss',' ','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-T0010-H.mm
delete from `T_INT_FORMATBASE` where FID=957945024698411009;
insert into `T_INT_FORMATBASE` (`FID`, `FCATEGORY`, `FSUBCATEGORY`, `FFORMATCODE`, `FFORMAT`, `FCOMMENT`, `FENABLE`, `FSTATUS`, `FCREATORID`,`FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`)
values(957945024698411009,'TIME','TIME','T0010','H.mm',' ','1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

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

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

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

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

-- 新增格式 TIME-TIME-T0015-ah:mm
delete from `T_INT_FORMATBASE` where FID=957945024706802689;
insert into `T_INT_FORMATBASE` (`FID`, `FCATEGORY`, `FSUBCATEGORY`, `FFORMATCODE`, `FFORMAT`, `FCOMMENT`, `FENABLE`, `FSTATUS`, `FCREATORID`,`FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`)
values(957945024706802689,'TIME','TIME','T0015','ah: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-T0017-HH.mm
delete from `T_INT_FORMATBASE` where FID=957945024706802690;
insert into `T_INT_FORMATBASE` (`FID`, `FCATEGORY`, `FSUBCATEGORY`, `FFORMATCODE`, `FFORMAT`, `FCOMMENT`, `FENABLE`, `FSTATUS`, `FCREATORID`,`FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`)
values(957945024706802690,'TIME','TIME','T0017','HH.mm',' ','1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

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

-- 新增格式 TIME-TIME-T0019-a hh:mm
delete from `T_INT_FORMATBASE` where FID=957945024706802691;
insert into `T_INT_FORMATBASE` (`FID`, `FCATEGORY`, `FSUBCATEGORY`, `FFORMATCODE`, `FFORMAT`, `FCOMMENT`, `FENABLE`, `FSTATUS`, `FCREATORID`,`FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`)
values(957945024706802691,'TIME','TIME','T0019','a hh: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);

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

-- 时间AMPM格式开始
-----------------------------------------------------------------------------------------------------------------
-- 新增格式 TIME-AM_PM-AP0001-上午/下午
delete from `T_INT_FORMATBASE` where FID=952766220669605892;
insert into `T_INT_FORMATBASE` (`FID`, `FCATEGORY`, `FSUBCATEGORY`, `FFORMATCODE`, `FFORMAT`, `FCOMMENT`, `FENABLE`, `FSTATUS`, `FCREATORID`,`FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`)
values(952766220669605892,'TIME','AM_PM','AP0001','上午/下午',' ','1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 新增格式 TIME-AM_PM-AP0002-AM/PM
delete from `T_INT_FORMATBASE` where FID=952766220669601796;
insert into `T_INT_FORMATBASE` (`FID`, `FCATEGORY`, `FSUBCATEGORY`, `FFORMATCODE`, `FFORMAT`, `FCOMMENT`, `FENABLE`, `FSTATUS`, `FCREATORID`,`FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`)
values(952766220669601796,'TIME','AM_PM','AP0002','AM/PM',' ','1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 新增格式 TIME-AM_PM-AP0003-SA/CH
delete from `T_INT_FORMATBASE` where FID=952766220669605893;
insert into `T_INT_FORMATBASE` (`FID`, `FCATEGORY`, `FSUBCATEGORY`, `FFORMATCODE`, `FFORMAT`, `FCOMMENT`, `FENABLE`, `FSTATUS`, `FCREATORID`,`FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`)
values(952766220669605893,'TIME','AM_PM','AP0003','SA/CH',' ','1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 新增格式 TIME-AM_PM-AP0004-午前/午後
delete from `T_INT_FORMATBASE` where FID=952766220669601797;
insert into `T_INT_FORMATBASE` (`FID`, `FCATEGORY`, `FSUBCATEGORY`, `FFORMATCODE`, `FFORMAT`, `FCOMMENT`, `FENABLE`, `FSTATUS`, `FCREATORID`,`FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`)
values(952766220669601797,'TIME','AM_PM','AP0004','午前/午後',' ','1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 新增格式 TIME-AM_PM-AP0005-오전/오후
delete from `T_INT_FORMATBASE` where FID=952910349688944640;
insert into `T_INT_FORMATBASE` (`FID`, `FCATEGORY`, `FSUBCATEGORY`, `FFORMATCODE`, `FFORMAT`, `FCOMMENT`, `FENABLE`, `FSTATUS`, `FCREATORID`,`FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`)
values(952910349688944640,'TIME','AM_PM','AP0005','오전/오후',' ','1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 新增格式 TIME-AM_PM-AP0006-a.m./p.m.
delete from `T_INT_FORMATBASE` where FID=952910349697335296;
insert into `T_INT_FORMATBASE` (`FID`, `FCATEGORY`, `FSUBCATEGORY`, `FFORMATCODE`, `FFORMAT`, `FCOMMENT`, `FENABLE`, `FSTATUS`, `FCREATORID`,`FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`)
values(952910349697335296,'TIME','AM_PM','AP0006','a.m./p.m.',' ','1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 新增格式 TIME-AM_PM-AP0007-ເຊົ້າ/ແລງ
delete from `T_INT_FORMATBASE` where FID=952910349697333248;
insert into `T_INT_FORMATBASE` (`FID`, `FCATEGORY`, `FSUBCATEGORY`, `FFORMATCODE`, `FFORMAT`, `FCOMMENT`, `FENABLE`, `FSTATUS`, `FCREATORID`,`FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`)
values(952910349697333248,'TIME','AM_PM','AP0007','ເຊົ້າ/ແລງ',' ','1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 新增格式 TIME-AM_PM-AP0008-Owuro/Ale
delete from `T_INT_FORMATBASE` where FID=952910349697335297;
insert into `T_INT_FORMATBASE` (`FID`, `FCATEGORY`, `FSUBCATEGORY`, `FFORMATCODE`, `FFORMAT`, `FCOMMENT`, `FENABLE`, `FSTATUS`, `FCREATORID`,`FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`)
values(952910349697335297,'TIME','AM_PM','AP0008','Owuro/Ale',' ','1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 新增格式 TIME-AM_PM-AP0009-পুর্বাহ্ন/অপরাহ্ন
delete from `T_INT_FORMATBASE` where FID=952910349697333249;
insert into `T_INT_FORMATBASE` (`FID`, `FCATEGORY`, `FSUBCATEGORY`, `FFORMATCODE`, `FFORMAT`, `FCOMMENT`, `FENABLE`, `FSTATUS`, `FCREATORID`,`FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`)
values(952910349697333249,'TIME','AM_PM','AP0009','পুর্বাহ্ন/অপরাহ্ন',' ','1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

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

-- 数字分组，小数点与分组符格式开始
-----------------------------------------------------------------------------------------------------------------
-- 新增格式 NUMBER-FORMAT-NFF0001-123,456,789.00
delete from `T_INT_FORMATBASE` where FID=952766220669605894;
insert into `T_INT_FORMATBASE` (`FID`, `FCATEGORY`, `FSUBCATEGORY`, `FFORMATCODE`, `FFORMAT`, `FCOMMENT`, `FENABLE`, `FSTATUS`, `FCREATORID`,`FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`)
values(952766220669605894,'NUMBER','FORMAT','NFF0001','123,456,789.00',' ','1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

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

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

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

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

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

-- 新增格式 NUMBER-FORMAT-NFF0007-123 456 789,00
delete from `T_INT_FORMATBASE` where FID=960850597538430976;
insert into `T_INT_FORMATBASE` (`FID`, `FCATEGORY`, `FSUBCATEGORY`, `FFORMATCODE`, `FFORMAT`, `FCOMMENT`, `FENABLE`, `FSTATUS`, `FCREATORID`,`FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`)
values(960850597538430976,'NUMBER','FORMAT','NFF0007','123 456 789,00',' ','1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

-- 数字前导零格式开始
-----------------------------------------------------------------------------------------------------------------
-- 新增格式 NUMBER-LEADING_ZERO-LZ0001-0
delete from `T_INT_FORMATBASE` where FID=952754781720463360;
insert into `T_INT_FORMATBASE` (`FID`, `FCATEGORY`, `FSUBCATEGORY`, `FFORMATCODE`, `FFORMAT`, `FCOMMENT`, `FENABLE`, `FSTATUS`, `FCREATORID`,`FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`)
values(952754781720463360,'NUMBER','LEADING_ZERO','LZ0001','0',' ','1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

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

-- 数字负数格式开始
-----------------------------------------------------------------------------------------------------------------
-- 新增格式 NUMBER-NEGATIVE_FORMAT-NF0001-(,)
delete from `T_INT_FORMATBASE` where FID=952754781720463361;
insert into `T_INT_FORMATBASE` (`FID`, `FCATEGORY`, `FSUBCATEGORY`, `FFORMATCODE`, `FFORMAT`, `FCOMMENT`, `FENABLE`, `FSTATUS`, `FCREATORID`,`FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`)
values(952754781720463361,'NUMBER','NEGATIVE_FORMAT','NF0001','(,)',' ','1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

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

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

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

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


-- 货币正数格式开始
-----------------------------------------------------------------------------------------------------------------
-- 新增格式 CURRENCY-POS_FORMAT-PF0001-¥,
delete from `T_INT_FORMATBASE` where FID=952754781728856065;
insert into `T_INT_FORMATBASE` (`FID`, `FCATEGORY`, `FSUBCATEGORY`, `FFORMATCODE`, `FFORMAT`, `FCOMMENT`, `FENABLE`, `FSTATUS`, `FCREATORID`,`FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`)
values(952754781728856065,'CURRENCY','POS_FORMAT','PF0001','¥,',' ','1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

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

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

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

-- 货币负数格式开始
-----------------------------------------------------------------------------------------------------------------
-- 新增格式 CURRENCY-NEG_FORMAT-CNF0001-(¥,)
delete from `T_INT_FORMATBASE` where FID=952754781728856067;
insert into `T_INT_FORMATBASE` (`FID`, `FCATEGORY`, `FSUBCATEGORY`, `FFORMATCODE`, `FFORMAT`, `FCOMMENT`, `FENABLE`, `FSTATUS`, `FCREATORID`,`FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`)
values(952754781728856067,'CURRENCY','NEG_FORMAT','CNF0001','(¥,)',' ','1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

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

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

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

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

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

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

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

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

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

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

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

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

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


-- 货币前缀显示格式开始
-----------------------------------------------------------------------------------------------------------------
-- 新增格式 CURRENCY-SHOW_PREFIX-SP0001-1
delete from `T_INT_FORMATBASE` where FID=952766220669601794;
insert into `T_INT_FORMATBASE` (`FID`, `FCATEGORY`, `FSUBCATEGORY`, `FFORMATCODE`, `FFORMAT`, `FCOMMENT`, `FENABLE`, `FSTATUS`, `FCREATORID`,`FCREATETIME`, `FMODIFIERID`, `FMODIFYTIME`, `FDISABLERID`, `FDISABLEDATE`)
values(952766220669601794,'CURRENCY','SHOW_PREFIX','SP0001','1',' ','1','C','0',{ts'2020-08-06 18:00:00'},'0',{ts'2020-08-06 18:00:00'},'0',NULL);

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

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

--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);





