284 lines
24 KiB
SQL
Executable File
284 lines
24 KiB
SQL
Executable File
-- # $Id$
|
|
-- # $HeadURL$
|
|
-- # $Author$
|
|
|
|
-- Guez default roles
|
|
INSERT INTO opm.opm_group (id, name, description, type_id, is_hidden) VALUES
|
|
( 1003, 'Technician', 'Technician rights', 3, true ),
|
|
( 1005, 'Controller', 'Controller rights', 3, true ),
|
|
( 1007, 'Exercise Controller', 'Exercise Controller rights', 3, true ),
|
|
( 1009, 'Evaluation', 'Evaluation rights', 3, true ),
|
|
( 1010, 'San. Evaluation', 'Sanitation evaluation rights', 3, true );
|
|
|
|
-- INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES ( 1004, 1003);
|
|
-- INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES ( 1006, 1005);
|
|
-- INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES ( 1008, 1007);
|
|
-- INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES ( 1010, 1009);
|
|
|
|
-- Rights (Techniker - 1003)
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,16842752);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,33620224);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,33685504);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,33685760);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,33686016);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,33686272);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,33751040);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,33816576);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,33882112);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,33947648);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,34013184);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,34078720);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,34144256);
|
|
--INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,34209792);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,34275328);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,50397184);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,83951616);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,84017152);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,84082688);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,117506048);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,134283264);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,184614912);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,201392128);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,218169344);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,218169600);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,234946560);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,234946816);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,302055424);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,335609856);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,335610112);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,352387072);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,369164288);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,419495936);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,419561472);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,419627008);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,419496192);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,419692544);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,453050368);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,453115904);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,453181440);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,453246976);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,453312512);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,453443584);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,469827584);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,520159232);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,587268096);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,587268352);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,587268608);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,587268864);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,620822528);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,738263040);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,755040256);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,755105792);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,771817472);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,788594688);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,805371904);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,822149120);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,838926336);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1003,889257984);
|
|
|
|
---- Rights (Leitung - 1005)
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,33620224);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,33685504);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,33685760);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,33686016);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,33686272);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,33751040);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,33816576);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,33882112);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,33947648);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,34013184);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,34078720);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,34144256);
|
|
--INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,34209792);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,50397184);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,83951616);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,84017152);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,117506048);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,134283264);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,184614912);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,201392128);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,218169600);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,234946560);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,234946816);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,302055424);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,335609856);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,335610112);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,352387072);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,369164288);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,419495936);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,419561472);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,419627008);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,419496192);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,453050368);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,453115904);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,453181440);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,453246976);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,453312512);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,453443584);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,469827584);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,469893120);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,469958656);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,520159232);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,587268096);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,587268352);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,587268608);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,587268864);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,620822528);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,755040256);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,755105792);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,771817472);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,788594688);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,805371904);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,822149120);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,838926336);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1005,889257984);
|
|
|
|
---- Rights (Uebungsleitung - 1007)
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,33620224);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,33685504);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,33685760);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,33686016);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,33686272);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,33751040);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,33816576);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,33882112);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,33947648);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,34013184);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,34078720);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,34144256);
|
|
--INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,34209792);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,50397184);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,83951616);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,84017152);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,117506048);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,134283264);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,184614912);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,201392128);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,218169600);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,234946560);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,234946816);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,302055424);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,335609856);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,335610112);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,352387072);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,369164288);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,419495936);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,419561472);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,419627008);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,419496192);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,453050368);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,453115904);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,453181440);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,453246976);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,453312512);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,453443584);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,469827584);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,469893120);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,469958656);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,520159232);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,587268096);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,587268352);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,587268608);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,587268864);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,620822528);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,755040256);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,755105792);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,771817472);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,788594688);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,805371904);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,822149120);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,838926336);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1007,889257984);
|
|
|
|
---- Rights (Auswertung - 1009)
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1009,33620224);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1009,33685504);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1009,33685760);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1009,33686016);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1009,33686272);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1009,33751040);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1009,33816576);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1009,33882112);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1009,34013184);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1009,34078720);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1009,34144256);
|
|
--INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1009,34209792);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1009,50397184);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1009,83951616);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1009,117506048);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1009,134283264);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1009,184614912);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1009,218169600);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1009,234946560);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1009,234946816);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1009,335609856);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1009,335610112);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1009,352387072);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1009,419495936);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1009,419627008);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1009,419496192);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1009,453115904);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1009,453443584);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1009,469827584);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1009,469893120);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1009,469958656);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1009,520159232);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1009,587268096);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1009,587268352);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1009,587268608);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1009,587268864);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1009,620822528);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1009,771817472);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1009,788594688);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1009,805371904);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1009,822149120);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1009,838926336);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1009,167903232);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1009,889257984);
|
|
|
|
---- Rights (PVSan Auswertung - 1010)
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1010,33620224);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1010,33685504);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1010,33685760);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1010,33686016);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1010,33686272);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1010,33751040);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1010,33816576);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1010,33882112);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1010,34013184);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1010,34078720);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1010,34144256);
|
|
--INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1010,34209792);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1010,50397184);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1010,83951616);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1010,117506048);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1010,134283264);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1010,184614912);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1010,218169600);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1010,234946560);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1010,234946816);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1010,335609856);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1010,335610112);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1010,352387072);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1010,419495936);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1010,419627008);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1010,419496192);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1010,453115904);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1010,453443584);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1010,469827584);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1010,469893120);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1010,469958656);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1010,520159232);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1010,587268096);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1010,587268352);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1010,587268608);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1010,587268864);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1010,620822528);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1010,771817472);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1010,788594688);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1010,805371904);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1010,822149120);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1010,838926336);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1010,167903232);
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) VALUES (1010,889257984);
|