insert into project_group (name, owner_id, group_type) values ('fedora_cla', (SELECT id FROM person WHERE username = 'admin'), 'tracker');insert into project_group (name, owner_id, group_type) values ('redhat_cla', (SELECT id FROM person WHERE username = 'admin'), 'tracker');insert into project_group (name, owner_id, group_type) values ('dell_cla', (SELECT id FROM person WHERE username = 'admin'), 'tracker');insert into role (person_id, project_group_id, role_type, role_domain, role_status, internal_comments, sponsor_id, creation, approval) values(select a.person_id, b.project_group_id, a.role_type, a.role_domain, a.role_status, a.internal_comments, a.sponsor_id, a.creation, a.approval) from role a, project_group bwhere a.project_group_id is (select id from project_group where name = 'cla_done') and b.id is (select id from project_group where name = 'fedora_cla');