UPDATE t_haos_structproject set fistoallareas = '1' where fid <>1040;
IF NOT EXISTS (SELECT 1 FROM t_haos_structproject WHERE fid = 1040 and frootorgid<>0) 
DELETE FROM t_haos_structproject WHERE fid = 1040;
IF NOT EXISTS (SELECT 1 FROM t_haos_structproject WHERE fid = 1040 and frootorgid<>0) 
INSERT INTO t_haos_structproject (fid, fnumber, fname, fsimplename, fdescription, fcreatorid, fcreatetime, fmodifierid, fmodifytime, fstatus, fenable, fissyspreset, findex, fdisablerid, fdisabledate, fmasterid, fotclassifyid, fisincludevirtualorg, fiscustomorg, forgid, frelyonstructprojectid, frootorgid, froottype, frootnumber, frootname, frooteffdt, frootdescription, feffdt, fistoallareas) VALUES (1040, 'SY_1040_S', '管理权架构', ' ', '供央国企智慧云使用，区分干部管理归属的组织。', 1, {ts'2023-09-25  00:00:00'}, 1, {ts'2023-09-25  00:00:00'}, 'C', '1', '1', 0, 0, null, 1040, 1010, '0', '0', 100000, 0, 0, '1', ' ', ' ', null, ' ', {ts'1900-01-01  00:00:00'},'0');
DELETE FROM t_haos_structproject_l WHERE fid = 1040;
INSERT INTO t_haos_structproject_l (fpkid, fid, flocaleid, fname, fsimplename, fdescription, frootname, frootdescription) VALUES ('3KVK4VJPP/Z+', 1040, 'zh_CN', '干部管理权架构', ' ', '仅供央国企人事云使用，用于定义管理干部的组织归属。', ' ', ' ');
UPDATE t_haos_structproject SET fname='干部管理权架构',fdescription='仅供央国企人事云使用，用于定义管理干部的组织归属。' WHERE fid = 1040;
