INSERT INTO roles VALUES('irc_p_nick');
INSERT INTO roles VALUES('irc_p_intel');
INSERT INTO roles VALUES('irc_masterop');
INSERT INTO roles VALUES('irc_masterinvite');
INSERT INTO roles VALUES('irc_gs');
INSERT INTO roles VALUES('irc_scanreqs');
INSERT INTO roles VALUES('irc_scan');
INSERT INTO roles VALUES('irc_anonscan');
INSERT INTO roles VALUES('irc_delquote');
INSERT INTO roles VALUES('irc_points_others');
INSERT INTO roles VALUES('irc_sms');
INSERT INTO roles VALUES('irc_adduser');
INSERT INTO roles VALUES('irc_deactivateuser');
INSERT INTO roles VALUES('irc_chattr');
INSERT INTO roles VALUES('irc_whois');
INSERT INTO roles VALUES('irc_flag');
INSERT INTO roles VALUES('irc_laston');
INSERT INTO roles VALUES('irc_lastseen');
INSERT INTO roles VALUES('irc_getships');
INSERT INTO roles VALUES('irc_getfleet');
INSERT INTO roles VALUES('irc_sethost');
INSERT INTO roles VALUES('irc_setpnick');
INSERT INTO roles VALUES('irc_a');
INSERT INTO roles VALUES('irc_d');
INSERT INTO roles VALUES('irc_s');
INSERT INTO roles VALUES('irc_h');
INSERT INTO roles VALUES('irc_sethostile');
INSERT INTO roles VALUES('irc_setnick');
INSERT INTO roles VALUES('irc_setally');
INSERT INTO roles VALUES('irc_setchannel');
INSERT INTO roles VALUES('irc_anondef');
INSERT INTO roles VALUES('irc_defcall');
INSERT INTO roles VALUES('irc_settype');
INSERT INTO roles VALUES('irc_calltake');
INSERT INTO roles VALUES('irc_setcalc');
INSERT INTO roles VALUES('irc_getcalc');
INSERT INTO roles VALUES('irc_sendsms');
INSERT INTO roles VALUES('irc_smsstatus');
INSERT INTO roles VALUES('irc_forum_others');
INSERT INTO roles VALUES('irc_newtag');
INSERT INTO roles VALUES('irc_addtag');
INSERT INTO roles VALUES('irc_deltag');
INSERT INTO roles VALUES('irc_say');
INSERT INTO roles VALUES('irc_cmd');

INSERT INTO group_roles (gid,role) VALUES('T','irc_p_nick');
INSERT INTO group_roles (gid,role) VALUES('T','irc_p_intel');
INSERT INTO group_roles (gid,role) VALUES('T','irc_masterop');
INSERT INTO group_roles (gid,role) VALUES('T','irc_masterinvite');
INSERT INTO group_roles (gid,role) VALUES('T','irc_scanreqs');
INSERT INTO group_roles (gid,role) VALUES('T','irc_anonscan');
INSERT INTO group_roles (gid,role) VALUES('T','irc_delquote');
INSERT INTO group_roles (gid,role) VALUES('T','irc_points_others');
INSERT INTO group_roles (gid,role) VALUES('T','irc_sms');
INSERT INTO group_roles (gid,role) VALUES('T','irc_adduser');
INSERT INTO group_roles (gid,role) VALUES('T','irc_deactivateuser');
INSERT INTO group_roles (gid,role) VALUES('T','irc_chattr');
INSERT INTO group_roles (gid,role) VALUES('T','irc_whois');
INSERT INTO group_roles (gid,role) VALUES('T','irc_flag');
INSERT INTO group_roles (gid,role) VALUES('T','irc_laston');
INSERT INTO group_roles (gid,role) VALUES('T','irc_lastseen');
INSERT INTO group_roles (gid,role) VALUES('T','irc_getships');
INSERT INTO group_roles (gid,role) VALUES('T','irc_getfleet');
INSERT INTO group_roles (gid,role) VALUES('T','irc_sethost');
INSERT INTO group_roles (gid,role) VALUES('T','irc_setpnick');
INSERT INTO group_roles (gid,role) VALUES('T','irc_a');
INSERT INTO group_roles (gid,role) VALUES('T','irc_d');
INSERT INTO group_roles (gid,role) VALUES('T','irc_s');
INSERT INTO group_roles (gid,role) VALUES('T','irc_h');
INSERT INTO group_roles (gid,role) VALUES('T','irc_sethostile');
INSERT INTO group_roles (gid,role) VALUES('T','irc_setnick');
INSERT INTO group_roles (gid,role) VALUES('T','irc_setally');
INSERT INTO group_roles (gid,role) VALUES('T','irc_setchannel');
INSERT INTO group_roles (gid,role) VALUES('T','irc_anondef');
INSERT INTO group_roles (gid,role) VALUES('T','irc_defcall');
INSERT INTO group_roles (gid,role) VALUES('T','irc_settype');
INSERT INTO group_roles (gid,role) VALUES('T','irc_calltake');
INSERT INTO group_roles (gid,role) VALUES('T','irc_setcalc');
INSERT INTO group_roles (gid,role) VALUES('T','irc_getcalc');
INSERT INTO group_roles (gid,role) VALUES('T','irc_sendsms');
INSERT INTO group_roles (gid,role) VALUES('T','irc_smsstatus');
INSERT INTO group_roles (gid,role) VALUES('T','irc_forum_others');
INSERT INTO group_roles (gid,role) VALUES('T','irc_say');
INSERT INTO group_roles (gid,role) VALUES('T','irc_cmd');

INSERT INTO group_roles (gid,role) VALUES('M','irc_gs');
INSERT INTO group_roles (gid,role) VALUES('M','irc_scan');
INSERT INTO group_roles (gid,role) VALUES('M','irc_newtag');
INSERT INTO group_roles (gid,role) VALUES('M','irc_addtag');
INSERT INTO group_roles (gid,role) VALUES('M','irc_deltag');

INSERT INTO group_roles (gid,role) VALUES('H','irc_p_nick');
INSERT INTO group_roles (gid,role) VALUES('H','irc_masterop');
INSERT INTO group_roles (gid,role) VALUES('H','irc_masterinvite');
INSERT INTO group_roles (gid,role) VALUES('H','irc_scanreqs');
INSERT INTO group_roles (gid,role) VALUES('H','irc_anonscan');
INSERT INTO group_roles (gid,role) VALUES('H','irc_delquote');
INSERT INTO group_roles (gid,role) VALUES('H','irc_points_others');
INSERT INTO group_roles (gid,role) VALUES('H','irc_sms');
INSERT INTO group_roles (gid,role) VALUES('H','irc_adduser');
INSERT INTO group_roles (gid,role) VALUES('H','irc_deactivateuser');
INSERT INTO group_roles (gid,role) VALUES('H','irc_chattr');
INSERT INTO group_roles (gid,role) VALUES('H','irc_whois');
INSERT INTO group_roles (gid,role) VALUES('H','irc_flag');
INSERT INTO group_roles (gid,role) VALUES('H','irc_laston');
INSERT INTO group_roles (gid,role) VALUES('H','irc_lastseen');
INSERT INTO group_roles (gid,role) VALUES('H','irc_getships');
INSERT INTO group_roles (gid,role) VALUES('H','irc_getfleet');
INSERT INTO group_roles (gid,role) VALUES('H','irc_sethost');
INSERT INTO group_roles (gid,role) VALUES('H','irc_setpnick');
INSERT INTO group_roles (gid,role) VALUES('H','irc_a');
INSERT INTO group_roles (gid,role) VALUES('H','irc_d');
INSERT INTO group_roles (gid,role) VALUES('H','irc_s');
INSERT INTO group_roles (gid,role) VALUES('H','irc_h');
INSERT INTO group_roles (gid,role) VALUES('H','irc_sethostile');
INSERT INTO group_roles (gid,role) VALUES('H','irc_setnick');
INSERT INTO group_roles (gid,role) VALUES('H','irc_setally');
INSERT INTO group_roles (gid,role) VALUES('H','irc_setchannel');
INSERT INTO group_roles (gid,role) VALUES('H','irc_anondef');
INSERT INTO group_roles (gid,role) VALUES('H','irc_defcall');
INSERT INTO group_roles (gid,role) VALUES('H','irc_settype');
INSERT INTO group_roles (gid,role) VALUES('H','irc_calltake');
INSERT INTO group_roles (gid,role) VALUES('H','irc_setcalc');
INSERT INTO group_roles (gid,role) VALUES('H','irc_getcalc');
INSERT INTO group_roles (gid,role) VALUES('H','irc_sendsms');
INSERT INTO group_roles (gid,role) VALUES('H','irc_smsstatus');
INSERT INTO group_roles (gid,role) VALUES('H','irc_forum_others');

INSERT INTO group_roles (gid,role) VALUES('B','irc_points_others');
INSERT INTO group_roles (gid,role) VALUES('B','irc_a');

INSERT INTO group_roles (gid,role) VALUES('I','irc_p_nick');
INSERT INTO group_roles (gid,role) VALUES('I','irc_p_intel');
INSERT INTO group_roles (gid,role) VALUES('I','irc_sethostile');
INSERT INTO group_roles (gid,role) VALUES('I','irc_setnick');
INSERT INTO group_roles (gid,role) VALUES('I','irc_setally');
INSERT INTO group_roles (gid,role) VALUES('I','irc_setchannel');

INSERT INTO group_roles (gid,role) VALUES('D','irc_p_intel');
INSERT INTO group_roles (gid,role) VALUES('D','irc_points_others');
INSERT INTO group_roles (gid,role) VALUES('D','irc_sms');
INSERT INTO group_roles (gid,role) VALUES('D','irc_getships');
INSERT INTO group_roles (gid,role) VALUES('D','irc_getfleet');
INSERT INTO group_roles (gid,role) VALUES('D','irc_d');
INSERT INTO group_roles (gid,role) VALUES('D','irc_sethostile');
INSERT INTO group_roles (gid,role) VALUES('D','irc_anondef');
INSERT INTO group_roles (gid,role) VALUES('D','irc_defcall');
INSERT INTO group_roles (gid,role) VALUES('D','irc_settype');
INSERT INTO group_roles (gid,role) VALUES('D','irc_calltake');
INSERT INTO group_roles (gid,role) VALUES('D','irc_setcalc');
INSERT INTO group_roles (gid,role) VALUES('D','irc_getcalc');
INSERT INTO group_roles (gid,role) VALUES('D','irc_sendsms');
INSERT INTO group_roles (gid,role) VALUES('D','irc_smsstatus');

INSERT INTO group_roles (gid,role) VALUES('S','irc_scanreqs');
INSERT INTO group_roles (gid,role) VALUES('S','irc_anonscan');

INSERT INTO group_roles (gid,role) VALUES('R','irc_p_nick');
INSERT INTO group_roles (gid,role) VALUES('R','irc_p_intel');
INSERT INTO group_roles (gid,role) VALUES('R','irc_points_others');
INSERT INTO group_roles (gid,role) VALUES('R','irc_whois');
INSERT INTO group_roles (gid,role) VALUES('R','irc_flag');
INSERT INTO group_roles (gid,role) VALUES('R','irc_laston');
INSERT INTO group_roles (gid,role) VALUES('R','irc_lastseen');
INSERT INTO group_roles (gid,role) VALUES('R','irc_forum_others');

INSERT INTO group_roles (gid,role) VALUES('s','irc_p_intel');
INSERT INTO group_roles (gid,role) VALUES('s','irc_h');
INSERT INTO group_roles (gid,role) VALUES('s','irc_points_others');
INSERT INTO group_roles (gid,role) VALUES('s','irc_sms');
INSERT INTO group_roles (gid,role) VALUES('s','irc_getships');
INSERT INTO group_roles (gid,role) VALUES('s','irc_getfleet');
INSERT INTO group_roles (gid,role) VALUES('s','irc_d');
INSERT INTO group_roles (gid,role) VALUES('s','irc_sethostile');
INSERT INTO group_roles (gid,role) VALUES('s','irc_anondef');
INSERT INTO group_roles (gid,role) VALUES('s','irc_defcall');
INSERT INTO group_roles (gid,role) VALUES('s','irc_settype');
INSERT INTO group_roles (gid,role) VALUES('s','irc_calltake');
INSERT INTO group_roles (gid,role) VALUES('s','irc_setcalc');
INSERT INTO group_roles (gid,role) VALUES('s','irc_getcalc');
