/* 管理员组fnumber的编码规则 预置数据 */
DELETE from t_cr_coderule where fid = '1NQN=/7LAKWM';
INSERT INTO t_cr_coderule(FID, FNUMBER, FRULETYPE, FBIZOBJECTID, FSPLITSIGN, FCTRLMODE, FAPPMODE, FEXAMPLE, FEXAMPLELENGTH, FENABLE, FSTATUS, FCREATORID, FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE, FMASTERID, FISUPDATERECOVER, FISNONBREAK, FISCHECKCODE, FISAPPCONDITION, FISAPPORG, FISLOG, FISSERIALNUMBER, FISUNIQUE, FISMODIFIABLE, FISADDVIEW, FISFAST) VALUES ('1NQN=/7LAKWM', '1NQN/F9DKZA2', NULL, 'perm_admingroup', '-', '1', '2', ' ', ' ', '1', 'C', 0, {ts'2021-06-03 16:01:33'}, 13466739, {ts'2021-06-03 16:52:14'}, NULL, NULL, '1NQN=/7LAKWM', '0', '0', '0', '0', '0', '0', '1', '0', '0', '1', '0');

DELETE from t_cr_coderule_l where fid = '1NQN=/7LAKWM';
INSERT INTO t_cr_coderule_l(FPKID, FID, FLOCALEID, FNAME) VALUES ('1NQN=/7LA72/', '1NQN=/7LAKWM', 'zh_CN', '管理员组fnumber的编码规则');

DELETE from t_cr_coderuleentry where fid = '1NQN=/7LAKWM';
INSERT INTO t_cr_coderuleentry(FENTRYID, FID, FSEQ, FATTRIBUTETYPE, FATTUSINGMODE, FVALUEATRIBUTE, FFORMAT, FSETTINGVALUE, FLENGTH, FINITIAL, FSTEP, FADDCHAR, FISSPLITSIGN, FADDSTYLE, FCUTSTYLE, FISSORTITEM, FSPLITSIGN, FISVISABLE)
VALUES('1NQS0X6+F0+A', '1NQN=/7LAKWM', 0, '1', '1', ' ', 'Admin', ' ', 8, 1, 1, ' ', '0', '1', '1', '0', ' ', '1');
INSERT INTO t_cr_coderuleentry
(FENTRYID, FID, FSEQ, FATTRIBUTETYPE, FATTUSINGMODE, FVALUEATRIBUTE, FFORMAT, FSETTINGVALUE, FLENGTH, FINITIAL, FSTEP, FADDCHAR, FISSPLITSIGN, FADDSTYLE, FCUTSTYLE, FISSORTITEM, FSPLITSIGN, FISVISABLE)
VALUES('1NQS0X6+F0+B', '1NQN=/7LAKWM', 1, '16', ' ', ' ', ' ', ' ', 6, 1, 1, ' ', '1', '1', '1', '0', '-', '1');


/* 旧版管理员功能启用开关 预置数据 */
DELETE from t_perm_oldadminenable where fid = 1;
INSERT INTO t_perm_oldadminenable(fid, fenable, fmodifytime, fmodifierid) VALUES (1, '1', NULL, 0);

/* 管理员组类型 预置数据 */
DELETE FROM t_sec_usergrouptype WHERE FID = 1153540312472243200;
INSERT INTO t_sec_usergrouptype(FID, FNUMBER, FSTATUS, FCREATORID, FMODIFIERID, FENABLE, FCREATETIME, FMODIFYTIME, FMASTERID, FISPRESET) VALUES (1153540312472243200, '001', 'C', 13466739, 13466739, '1', {ts'2021-05-11 13:58:12'}, {ts'2021-05-11 13:58:41'}, 1153540312472243200, '1');
DELETE FROM t_sec_usergrouptype WHERE FID = 1153540503615065088;
INSERT INTO t_sec_usergrouptype(FID, FNUMBER, FSTATUS, FCREATORID, FMODIFIERID, FENABLE, FCREATETIME, FMODIFYTIME, FMASTERID, FISPRESET) VALUES (1153540503615065088, '002', 'C', 13466739, 13466739, '1', {ts'2021-05-11 13:58:49'}, {ts'2021-05-11 13:59:03'}, 1153540503615065088, '1');

/* 管理员组类型(多语言) 预置数据 */
DELETE FROM t_sec_usergrouptype_l WHERE FID = 1153540312472243200;
INSERT INTO t_sec_usergrouptype_l(FPKID, FID, FLOCALEID, FNAME) VALUES ('1LOH0I14DKQV', 1153540312472243200, 'zh_CN', '管理员组');
INSERT INTO t_sec_usergrouptype_l(FPKID, FID, FLOCALEID, FNAME) VALUES ('1LOH0I14DKQW', 1153540312472243200, 'zh_TW', '管理員組');
DELETE FROM t_sec_usergrouptype_l WHERE FID = 1153540503615065088;
INSERT INTO t_sec_usergrouptype_l(FPKID, FID, FLOCALEID, FNAME) VALUES ('1LOH1XBCCEFT', 1153540503615065088, 'zh_CN', '普通用户组');
INSERT INTO t_sec_usergrouptype_l(FPKID, FID, FLOCALEID, FNAME) VALUES ('1LOH1XBCCEFU', 1153540503615065088, 'zh_TW', '普通用戶組');


/* 将用户组类型id 绑定到对应的 用户组记录 ， 增量、全量升级都要做 */
update t_sec_usergroup set fusergrouptypeid=1153540503615065088 where fusergrouptypeid <> 1153540312472243200;






