-- dbkey="hmp"

/*项目团队列表关联权限*/

-- 新增 （新增子项目团队、创建项目及团队）权限二合一
DELETE FROM T_HRCS_PERMRELAT WHERE FID = 1529624738534605824;
DELETE FROM T_HRCS_PERMRELAT WHERE FID = 1529698349542883328;
INSERT INTO T_HRCS_PERMRELAT(FID,FCREATETIME,FPERMITEMID,FMODIFIERID,FMODIFYTIME,FAPPID,FDESCRIPTION,FCREATORID,FENTITYTYPEID) VALUES (1529698349542883328,now(),'QXX0002',1,now(),'217WYC/L9U7E',' ',1,'haos_projteambaseinfo');
DELETE FROM t_hrcs_permrelatentry WHERE FENTRYID = 1529698349542884352;
INSERT INTO t_hrcs_permrelatentry(FID,FISSYSPRESET,FPERMITEMID,FENTRYID,FSEQ,FAPPID,FENTITYTYPEID) VALUES (1529698349542883328,'1','QXX0002',1529698349542884352,1,'217WYC/L9U7E','haos_projectgroupadd');


-- 协作关系变更
DELETE FROM T_HRCS_PERMRELAT WHERE FID = 1529829466916873216;
INSERT INTO T_HRCS_PERMRELAT(FID,FCREATETIME,FPERMITEMID,FMODIFIERID,FMODIFYTIME,FAPPID,FDESCRIPTION,FCREATORID,FENTITYTYPEID) VALUES (1529829466916873216,now(),'HRQXX0232',1,now(),'217WYC/L9U7E',' ',1,'haos_projteambaseinfo');
DELETE FROM t_hrcs_permrelatentry WHERE FENTRYID = 1529829466916894720;
INSERT INTO t_hrcs_permrelatentry(FID,FISSYSPRESET,FPERMITEMID,FENTRYID,FSEQ,FAPPID,FENTITYTYPEID) VALUES (1529829466916873216,'1','HRQXX0232',1529829466916894720,1,'217WYC/L9U7E','haos_projteamcooprelalter');


-- 信息变更
DELETE FROM T_HRCS_PERMRELAT WHERE FID = 1529811344193290240;
INSERT INTO T_HRCS_PERMRELAT(fid,fcreatetime,fpermitemid,fmodifierid,fmodifytime,fappid,fdescription,fcreatorid,fentitytypeid) VALUES (1529811344193290240,now(),'HRQXX0260',1,now(),'217WYC/L9U7E',' ',1,'haos_projteambaseinfo');
DELETE FROM t_hrcs_permrelatentry WHERE FENTRYID = 1529811344193289216;
INSERT INTO t_hrcs_permrelatentry(fid,fissyspreset,fpermitemid,fentryid,fseq,fappid,fentitytypeid) VALUES (1529811344193290240,'1','HRQXX0260',1529811344193289216,1,'217WYC/L9U7E','haos_projectgroupchange');

-- 上级调整
DELETE FROM t_hrcs_permrelat WHERE fid = 1540672807011130368;
INSERT INTO t_hrcs_permrelat (fid, fcreatorid, fcreatetime, fmodifierid, fmodifytime, fentitytypeid, fappid, fpermitemid, fdescription) VALUES (1540672807011130368, 1, now(), 1, now(), 'haos_projteambaseinfo', '217WYC/L9U7E', 'HRQXX0255', ' ');
DELETE FROM t_hrcs_permrelatentry WHERE fentryid = 1540672807011131392;
INSERT INTO t_hrcs_permrelatentry (fid, fentryid, fseq, fentitytypeid, fappid, fpermitemid, fissyspreset) VALUES (1540672807011130368, 1540672807011131392, 1, 'haos_projectgroupchange', '217WYC/L9U7E', 'HRQXX0255', '1');

-- 禁用关联权限
DELETE FROM t_hrcs_permrelat WHERE fid = 1545038766358496256;
INSERT INTO t_hrcs_permrelat (fid, fcreatorid, fcreatetime, fmodifierid, fmodifytime, fentitytypeid, fappid, fpermitemid, fdescription) VALUES (1545038766358496256, 1, now(), 1, now(), 'haos_projteambaseinfo', '217WYC/L9U7E', 'QXX0005', ' ');
DELETE FROM t_hrcs_permrelatentry WHERE fentryid = 1545038766358495232;
INSERT INTO t_hrcs_permrelatentry (fid, fentryid, fseq, fentitytypeid, fappid, fpermitemid, fissyspreset) VALUES (1545038766358496256, 1545038766358495232, 1, 'haos_projectgroupforbidde', '217WYC/L9U7E', 'QXX0005', '1');

