--select * from hib.[grouprole]

Delete from hib.[grouprole]


Insert into hib.[grouprole] (groupid, roleid)
values (1,4)


Insert into hib.[grouprole] (groupid, roleid)
values (15,3)


Insert into hib.[grouprole] (groupid, roleid)
values (3,1)
Insert into hib.[grouprole] (groupid, roleid)
values (3,5)

Insert into hib.[grouprole] (groupid, roleid)
values (5,1)
Insert into hib.[grouprole] (groupid, roleid)
values (5,5)

Insert into hib.[grouprole] (groupid, roleid)
values (7,1)
Insert into hib.[grouprole] (groupid, roleid)
values (7,5)

Insert into hib.[grouprole] (groupid, roleid)
values (9,1)
Insert into hib.[grouprole] (groupid, roleid)
values (9,5)

Insert into hib.[grouprole] (groupid, roleid)
values (11,1)
Insert into hib.[grouprole] (groupid, roleid)
values (11,5)

Insert into hib.[grouprole] (groupid, roleid)
values (13,1)
Insert into hib.[grouprole] (groupid, roleid)
values (13,5)

Insert into hib.[grouprole] (groupid, roleid)
values (16,1)
Insert into hib.[grouprole] (groupid, roleid)
values (16,5)

--select * from hib.[grouprole] gr left join hib.[group] g on g.id=gr.groupid left join hib.[role] r on r.id=gr.roleid order by groupid