-- 组织团队分类->任职资格专委会
DELETE FROM t_haos_otclassify WHERE FID = 1040;
INSERT INTO t_haos_otclassify(fid, fnumber, fname, fstatus, fcreatorid, fmodifierid, fenable, fcreatetime, fmodifytime, fmasterid, fsimplename, fdescription, findex, fissyspreset, fdisablerid, fdisabledate, fteamtypeid, forgtypeid) VALUES (1040, '1040_S', '任职资格专委会', 'C', 1, 1, '1', {ts'2022-03-08 11:05:06'}, {ts'2022-03-08 11:05:06'}, 1040, ' ', '预置数据', 0, '1', 0, NULL, 1040, 1010);
DELETE FROM t_haos_otclassify_l WHERE FID = 1040;
INSERT INTO t_haos_otclassify_l(fpkid, fid, flocaleid, fname, fsimplename, fdescription) VALUES ('2=36DV8NNN=K', 1040, 'zh_CN', '任职资格专委会', ' ', '预置数据');
--删除行政组织分类
delete from t_haos_basedatalist where fid = 1020;
delete from t_haos_basedatalist_l where fid = 1020;
--行政组织层级
DELETE FROM t_haos_basedatalist WHERE fid in (1090,1100);
INSERT INTO t_haos_basedatalist(fid, fnumber, fname, fstatus, fcreatorid, fmodifierid, fenable, fcreatetime, fmodifytime, fmasterid, fsimplename, fdescription, findex, fissyspreset, fdisablerid, fdisabledate, fpagekey) VALUES (1020, '1020_S', '行政组织层级', 'C', 1, 1, '1', {ts'2022-03-08 11:04:05'}, {ts'2022-03-08 11:04:06'}, 1090, ' ', '预置数据', 0, '1', 0, NULL, 'haos_adminorglayer');
INSERT INTO t_haos_basedatalist(fid, fnumber, fname, fstatus, fcreatorid, fmodifierid, fenable, fcreatetime, fmodifytime, fmasterid, fsimplename, fdescription, findex, fissyspreset, fdisablerid, fdisabledate, fpagekey) VALUES (1090, '1090_S', '变动场景', 'C', 1, 1, '1', {ts'2022-03-10 08:45:05'}, {ts'2022-03-10 08:45:05'}, 1100, ' ', '预置数据', 0, '1', 0, NULL, 'haos_changescene');

DELETE FROM t_haos_basedatalist_l WHERE fid in (1090,1100);
INSERT INTO t_haos_basedatalist_l(fpkid, fid, flocaleid, fname, fsimplename, fdescription) VALUES ('28GTWZK1H4TT', 1020, 'zh_CN', '行政组织层级', ' ', '预置数据');
INSERT INTO t_haos_basedatalist_l(fpkid, fid, flocaleid, fname, fsimplename, fdescription) VALUES ('27GTEZK2G4TT', 1090, 'zh_CN', '变动场景', ' ', '预置数据');
-- 变动类型
UPDATE t_haos_orgchangetype SET fname = '组织新设' WHERE fid=1010;
UPDATE t_haos_orgchangetype_l SET fname = '组织新设' WHERE fid = 1010 AND flocaleid = 'zh_CN';
UPDATE t_haos_orgchangetype SET fname = '信息变更' WHERE fid=1030;
UPDATE t_haos_orgchangetype_l SET fname = '信息变更' WHERE fid = 1030 AND flocaleid = 'zh_CN';
UPDATE t_haos_orgchangetype SET fname = '组织停用' WHERE fid=1040;
UPDATE t_haos_orgchangetype_l SET fname = '组织停用' WHERE fid = 1040 AND flocaleid = 'zh_CN';
--变动类型
DELETE FROM t_haos_orgchangetype WHERE FID = 1060;
INSERT INTO t_haos_orgchangetype(fid, fnumber, fname, fstatus, fcreatorid, fmodifierid, fenable, fcreatetime, fmodifytime, fmasterid, fsimplename, fdescription, findex, fissyspreset, fdisablerid, fdisabledate, fotclassify) VALUES (1060, '1060_S', '初始化', 'C', 1, 1, '1', {ts'2022-03-08 11:14:16'}, {ts'2022-03-08 11:15:12'}, 1060, ' ', ' ', 0, '0', 0, null,1010);
DELETE FROM t_haos_orgchangetype_l WHERE fpkid = '283FY60+38QH';
INSERT INTO t_haos_orgchangetype_l(fpkid, fid, flocaleid, fname, fsimplename, fdescription) VALUES ('283FY60+38QH', 1060, 'zh_CN', '初始化', ' ', ' ');
UPDATE t_haos_orgchangetype set fotclassify = 1010 WHERE fid in (1010,1020,1030,1040);
UPDATE t_haos_orgchangetype SET fotclassify = 1020 WHERE fid IN (1050);
UPDATE t_haos_orgchangetype set fissyspreset='1' WHERE fid in (1010,1020,1030,1040,1050,1060);
-- 变动操作
DELETE FROM t_haos_changeoperat WHERE fid in (1010,1020,1030,1040);
INSERT INTO t_haos_changeoperat(fid, fnumber, fname, fstatus, fcreatorid, fmodifierid, fenable, fcreatetime, fmodifytime, fmasterid, fsimplename, fdescription, findex, fissyspreset, fdisablerid, fdisabledate, fotclassifyid) VALUES (1010, '1010_S', '新增', 'C', 1, 1, '1', {ts'2022-03-08 11:14:16'}, {ts'2022-03-08 11:14:16'}, 1010, ' ', ' ', 0, '1', 0, null, 1010);
INSERT INTO t_haos_changeoperat(fid, fnumber, fname, fstatus, fcreatorid, fmodifierid, fenable, fcreatetime, fmodifytime, fmasterid, fsimplename, fdescription, findex, fissyspreset, fdisablerid, fdisabledate, fotclassifyid) VALUES (1020, '1020_S', '上级调整', 'C', 1, 1, '1', {ts'2022-03-08 11:14:16'}, {ts'2022-03-08 11:14:16'}, 1020, ' ', ' ', 0, '1', 0, null, 1010);
INSERT INTO t_haos_changeoperat(fid, fnumber, fname, fstatus, fcreatorid, fmodifierid, fenable, fcreatetime, fmodifytime, fmasterid, fsimplename, fdescription, findex, fissyspreset, fdisablerid, fdisabledate, fotclassifyid) VALUES (1030, '1030_S', '信息变更', 'C', 1, 1, '1', {ts'2022-03-08 11:14:16'}, {ts'2022-03-08 11:14:16'}, 1030, ' ', ' ', 0, '1', 0, null, 1010);
INSERT INTO t_haos_changeoperat(fid, fnumber, fname, fstatus, fcreatorid, fmodifierid, fenable, fcreatetime, fmodifytime, fmasterid, fsimplename, fdescription, findex, fissyspreset, fdisablerid, fdisabledate, fotclassifyid) VALUES (1040, '1040_S', '禁用', 'C', 1, 1, '1', {ts'2022-03-08 11:14:16'}, {ts'2022-03-08 11:14:16'}, 1040, ' ', ' ', 0, '1', 0, null, 1010);
DELETE FROM t_haos_changeoperat_l WHERE fid in (1010,1020,1030,1040);
INSERT INTO t_haos_changeoperat_l(fpkid, fid, flocaleid, fname, fsimplename, fdescription) VALUES ('2=GPP=JZGFS5', 1010, 'zh_CN', '新增', ' ', ' ');
INSERT INTO t_haos_changeoperat_l(fpkid, fid, flocaleid, fname, fsimplename, fdescription) VALUES ('2=GPQY+R9K8S', 1020, 'zh_CN', '上级调整', ' ', ' ');
INSERT INTO t_haos_changeoperat_l(fpkid, fid, flocaleid, fname, fsimplename, fdescription) VALUES ('2=GPS4DYF8MP', 1030, 'zh_CN', '信息变更', ' ', ' ');
INSERT INTO t_haos_changeoperat_l(fpkid, fid, flocaleid, fname, fsimplename, fdescription) VALUES ('2=GPT8CBG7X=', 1040, 'zh_CN', '禁用', ' ', ' ');
--场景子类
DELETE FROM t_haos_changescenesub WHERE fid in (1010,1020,1030,1040,1050,1060,1070,1080,1090,1100,1110);
INSERT INTO t_haos_changescenesub(fid, fnumber, fname, fstatus, fcreatorid, fmodifierid, fenable, fcreatetime, fmodifytime, fmasterid, fsimplename, fdescription, findex, fissyspreset, fdisablerid, fdisabledate, fotclassifyid) VALUES (1010, '1010_S', '组织新设', 'C', 1, 1, '1', {ts'2022-03-08 11:14:16'}, {ts'2022-03-08 11:14:16'}, 1010, ' ', ' ', 0, '1', 0, null, 1010);
INSERT INTO t_haos_changescenesub(fid, fnumber, fname, fstatus, fcreatorid, fmodifierid, fenable, fcreatetime, fmodifytime, fmasterid, fsimplename, fdescription, findex, fissyspreset, fdisablerid, fdisabledate, fotclassifyid) VALUES (1020, '1020_S', '上级调整', 'C', 1, 1, '1', {ts'2022-03-08 11:14:16'}, {ts'2022-03-08 11:14:16'}, 1020, ' ', ' ', 0, '1', 0, null, 1010);
INSERT INTO t_haos_changescenesub(fid, fnumber, fname, fstatus, fcreatorid, fmodifierid, fenable, fcreatetime, fmodifytime, fmasterid, fsimplename, fdescription, findex, fissyspreset, fdisablerid, fdisabledate, fotclassifyid) VALUES (1030, '1030_S', '信息变更', 'C', 1, 1, '1', {ts'2022-03-08 11:14:16'}, {ts'2022-03-08 11:14:16'}, 1030, ' ', ' ', 0, '1', 0, null, 1010);
INSERT INTO t_haos_changescenesub(fid, fnumber, fname, fstatus, fcreatorid, fmodifierid, fenable, fcreatetime, fmodifytime, fmasterid, fsimplename, fdescription, findex, fissyspreset, fdisablerid, fdisabledate, fotclassifyid) VALUES (1040, '1040_S', '组织停用', 'C', 1, 1, '1', {ts'2022-03-08 11:14:16'}, {ts'2022-03-08 11:14:16'}, 1040, ' ', ' ', 0, '1', 0, null, 1010);
INSERT INTO t_haos_changescenesub(fid, fnumber, fname, fstatus, fcreatorid, fmodifierid, fenable, fcreatetime, fmodifytime, fmasterid, fsimplename, fdescription, findex, fissyspreset, fdisablerid, fdisabledate, fotclassifyid) VALUES (1050, '1050_S', '更名', 'C', 1, 1, '1', {ts'2022-03-08 11:14:16'}, {ts'2022-03-08 11:14:16'}, 1050, ' ', ' ', 0, '1', 0, null, 1010);
INSERT INTO t_haos_changescenesub(fid, fnumber, fname, fstatus, fcreatorid, fmodifierid, fenable, fcreatetime, fmodifytime, fmasterid, fsimplename, fdescription, findex, fissyspreset, fdisablerid, fdisabledate, fotclassifyid) VALUES (1060, '1060_S', '法律实体变化', 'C', 1, 1, '1', {ts'2022-03-08 11:14:16'}, {ts'2022-03-08 11:14:16'}, 1060, ' ', ' ', 0, '1', 0, null, 1010);
INSERT INTO t_haos_changescenesub(fid, fnumber, fname, fstatus, fcreatorid, fmodifierid, fenable, fcreatetime, fmodifytime, fmasterid, fsimplename, fdescription, findex, fissyspreset, fdisablerid, fdisabledate, fotclassifyid) VALUES (1070, '1070_S', '职责变化', 'C', 1, 1, '1', {ts'2022-03-08 11:14:16'}, {ts'2022-03-08 11:14:16'}, 1070, ' ', ' ', 0, '1', 0, null, 1010);
INSERT INTO t_haos_changescenesub(fid, fnumber, fname, fstatus, fcreatorid, fmodifierid, fenable, fcreatetime, fmodifytime, fmasterid, fsimplename, fdescription, findex, fissyspreset, fdisablerid, fdisabledate, fotclassifyid) VALUES (1080, '1080_S', '协作关系变化', 'C', 1, 1, '1', {ts'2022-03-08 11:14:16'}, {ts'2022-03-08 11:14:16'}, 1080, ' ', ' ', 0, '1', 0, null, 1010);
INSERT INTO t_haos_changescenesub(fid, fnumber, fname, fstatus, fcreatorid, fmodifierid, fenable, fcreatetime, fmodifytime, fmasterid, fsimplename, fdescription, findex, fissyspreset, fdisablerid, fdisabledate, fotclassifyid) VALUES (1090, '1090_S', '业务转入', 'C', 1, 1, '1', {ts'2022-03-08 11:14:16'}, {ts'2022-03-08 11:14:16'}, 1090, ' ', ' ', 0, '1', 0, null, 1010);
INSERT INTO t_haos_changescenesub(fid, fnumber, fname, fstatus, fcreatorid, fmodifierid, fenable, fcreatetime, fmodifytime, fmasterid, fsimplename, fdescription, findex, fissyspreset, fdisablerid, fdisabledate, fotclassifyid) VALUES (1100, '1100_S', '业务转出', 'C', 1, 1, '1', {ts'2022-03-08 11:14:16'}, {ts'2022-03-08 11:14:16'}, 1100, ' ', ' ', 0, '1', 0, null, 1010);
INSERT INTO t_haos_changescenesub(fid, fnumber, fname, fstatus, fcreatorid, fmodifierid, fenable, fcreatetime, fmodifytime, fmasterid, fsimplename, fdescription, findex, fissyspreset, fdisablerid, fdisabledate, fotclassifyid) VALUES (1110, '1110_S', '待停用变化', 'C', 1, 1, '1',{ts'2022-03-08 11:14:16'}, {ts'2022-03-08 11:14:16'}, 1110, ' ', ' ', 0, '1', 0, null, 1010);
DELETE FROM t_haos_changescenesub_l WHERE fid in (1010,1020,1030,1040,1050,1060,1070,1080,1090,1100,1110);
INSERT INTO t_haos_changescenesub_l(fpkid, fid, flocaleid, fname, fsimplename, fdescription) VALUES ('2=GW/7LVZARQ', 1010, 'zh_CN', '组织新设', ' ', ' ');
INSERT INTO t_haos_changescenesub_l(fpkid, fid, flocaleid, fname, fsimplename, fdescription) VALUES ('2=GW29G12HFW', 1020, 'zh_CN', '上级调整', ' ', ' ');
INSERT INTO t_haos_changescenesub_l(fpkid, fid, flocaleid, fname, fsimplename, fdescription) VALUES ('2=GW3W1VKMPI', 1030, 'zh_CN', '信息变更', ' ', ' ');
INSERT INTO t_haos_changescenesub_l(fpkid, fid, flocaleid, fname, fsimplename, fdescription) VALUES ('2=GW5+S/2RJ/', 1040, 'zh_CN', '组织停用', ' ', ' ');
INSERT INTO t_haos_changescenesub_l(fpkid, fid, flocaleid, fname, fsimplename, fdescription) VALUES ('2=GW5VKGUNAA', 1050, 'zh_CN', '更名', ' ', ' ');
INSERT INTO t_haos_changescenesub_l(fpkid, fid, flocaleid, fname, fsimplename, fdescription) VALUES ('2=GW6OLWF0ZL', 1060, 'zh_CN', '法律实体变化', ' ', ' ');
INSERT INTO t_haos_changescenesub_l(fpkid, fid, flocaleid, fname, fsimplename, fdescription) VALUES ('2=GW7JE+O9ZV', 1070, 'zh_CN', '职责变化', ' ', ' ');
INSERT INTO t_haos_changescenesub_l(fpkid, fid, flocaleid, fname, fsimplename, fdescription) VALUES ('2=GW8BWXLY28', 1080, 'zh_CN', '协作关系变化', ' ', ' ');
INSERT INTO t_haos_changescenesub_l(fpkid, fid, flocaleid, fname, fsimplename, fdescription) VALUES ('2=GW9A=P0BJD', 1090, 'zh_CN', '业务转入', ' ', ' ');
INSERT INTO t_haos_changescenesub_l(fpkid, fid, flocaleid, fname, fsimplename, fdescription) VALUES ('2=GW=5Q7+DA4', 1100, 'zh_CN', '业务转出', ' ', ' ');
INSERT INTO t_haos_changescenesub_l(fpkid, fid, flocaleid, fname, fsimplename, fdescription) VALUES ('2=GWA1ZNL815', 1110, 'zh_CN', '待停用变化', ' ', ' ');
--变动场景
DELETE FROM t_haos_changescene WHERE fid in (1010,1020,1030,1040,1050,1060);
DELETE FROM t_haos_cschangeoperat WHERE fid in (1010,1020,1030,1040,1050,1060);
DELETE FROM t_haos_changescene_l WHERE fid in (1010,1020,1030,1040,1050,1060);
INSERT INTO t_haos_changescene(fid, fnumber, fname, fstatus, fcreatorid, fmodifierid, fenable, fcreatetime, fmodifytime, fmasterid, fsimplename, fdescription, findex, fissyspreset, fdisablerid, fdisabledate, forgchangetypeid, fotclassifyid) VALUES (1010, '1010_S', '组织新设', 'C', 1, 1, '1', {ts'2022-03-08 11:14:16'}, {ts'2022-03-08 11:14:16'}, 1010, ' ', ' ', 0, '1', 0, null, 1010, 1010);
INSERT INTO t_haos_changescene(fid, fnumber, fname, fstatus, fcreatorid, fmodifierid, fenable, fcreatetime, fmodifytime, fmasterid, fsimplename, fdescription, findex, fissyspreset, fdisablerid, fdisabledate, forgchangetypeid, fotclassifyid) VALUES (1020, '1020_S', '上级调整', 'C', 1, 1, '1', {ts'2022-03-08 11:14:16'}, {ts'2022-03-08 11:14:16'}, 1020, ' ', ' ', 0, '1', 0, null, 1020, 1010);
INSERT INTO t_haos_changescene(fid, fnumber, fname, fstatus, fcreatorid, fmodifierid, fenable, fcreatetime, fmodifytime, fmasterid, fsimplename, fdescription, findex, fissyspreset, fdisablerid, fdisabledate, forgchangetypeid, fotclassifyid) VALUES (1030, '1030_S', '组织更名', 'C', 1, 1, '1', {ts'2022-03-08 11:14:16'}, {ts'2022-03-08 11:14:16'}, 1030, ' ', ' ', 0, '1', 0, null, 1030, 1010);
INSERT INTO t_haos_changescene(fid, fnumber, fname, fstatus, fcreatorid, fmodifierid, fenable, fcreatetime, fmodifytime, fmasterid, fsimplename, fdescription, findex, fissyspreset, fdisablerid, fdisabledate, forgchangetypeid, fotclassifyid) VALUES (1040, '1040_S', '组织停用', 'C', 1, 1, '1', {ts'2022-03-08 11:14:16'}, {ts'2022-03-08 11:14:16'}, 1040, ' ', ' ', 0, '1', 0, null, 1040, 1010);
INSERT INTO t_haos_changescene(fid, fnumber, fname, fstatus, fcreatorid, fmodifierid, fenable, fcreatetime, fmodifytime, fmasterid, fsimplename, fdescription, findex, fissyspreset, fdisablerid, fdisabledate, forgchangetypeid, fotclassifyid) VALUES (1050, '1050_S', '初始化新增', 'C', 1, 1, '1', {ts'2022-03-08 11:14:16'}, {ts'2022-03-08 11:14:16'}, 1050, ' ', ' ', 0, '1', 0, null, 1060, 1010);
INSERT INTO t_haos_changescene(fid, fnumber, fname, fstatus, fcreatorid, fmodifierid, fenable, fcreatetime, fmodifytime, fmasterid, fsimplename, fdescription, findex, fissyspreset, fdisablerid, fdisabledate, forgchangetypeid, fotclassifyid) VALUES (1060, '1060_S', '初始化禁用', 'C', 1, 1, '1', {ts'2022-03-08 11:14:16'}, {ts'2022-03-08 11:14:16'}, 1060, ' ', ' ', 0, '1', 0, null, 1060, 1010);
INSERT INTO t_haos_changescene_l(fpkid, fid, flocaleid, fname, fsimplename, fdescription) VALUES ('2=MVA+KK9GZN', 1010, 'zh_CN', '组织新设', ' ', ' ');
INSERT INTO t_haos_changescene_l(fpkid, fid, flocaleid, fname, fsimplename, fdescription) VALUES ('2=MVBD2QD9MV', 1020, 'zh_CN', '上级调整', ' ', ' ');
INSERT INTO t_haos_changescene_l(fpkid, fid, flocaleid, fname, fsimplename, fdescription) VALUES ('2=MVCWMFN1SL', 1030, 'zh_CN', '组织更名', ' ', ' ');
INSERT INTO t_haos_changescene_l(fpkid, fid, flocaleid, fname, fsimplename, fdescription) VALUES ('2=MVE=AOBE2S', 1040, 'zh_CN', '组织停用', ' ', ' ');
INSERT INTO t_haos_changescene_l(fpkid, fid, flocaleid, fname, fsimplename, fdescription) VALUES ('25MVBD2QDE4V', 1050, 'zh_CN', '初始化新增', ' ', ' ');
INSERT INTO t_haos_changescene_l(fpkid, fid, flocaleid, fname, fsimplename, fdescription) VALUES ('26MVA+KK95ZN', 1060, 'zh_CN', '初始化禁用', ' ', ' ');
INSERT INTO t_haos_cschangeoperat(fpkid, fid, fbasedataid) VALUES (1020, 1020, 1020);
INSERT INTO t_haos_cschangeoperat(fpkid, fid, fbasedataid) VALUES (1030, 1030, 1030);
INSERT INTO t_haos_cschangeoperat(fpkid, fid, fbasedataid) VALUES (1010, 1010, 1010);
INSERT INTO t_haos_cschangeoperat(fpkid, fid, fbasedataid) VALUES (1040, 1040, 1040);
INSERT INTO t_haos_cschangeoperat(fpkid, fid, fbasedataid) VALUES (1050, 1050, 1010);
INSERT INTO t_haos_cschangeoperat(fpkid, fid, fbasedataid) VALUES (1060, 1060, 1040);
--修改行政组织基础资料名称
UPDATE t_haos_basedatalist SET fname = '保密等级' WHERE fid = 1040;
UPDATE t_haos_basedatalist_l SET fname = '保密等级' WHERE fpkid = '23FU/E3I6CB5';
UPDATE t_haos_basedatalist_l SET fname = '保密等级' WHERE fpkid = '23FU/E3I6CB6';
UPDATE t_haos_basedatalist SET fname = '保密类型' WHERE fid = 1050;
UPDATE t_haos_basedatalist_l SET fname = '保密类型' WHERE fpkid = '23FU0YE2FISJ';
UPDATE t_haos_basedatalist_l SET fname = '保密类型' WHERE fpkid = '23FU0YE2FISK';
