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 group_roles (gid,role) VALUES(1,'irc_p_nick');
INSERT INTO group_roles (gid,role) VALUES(1,'irc_p_intel');
INSERT INTO group_roles (gid,role) VALUES(1,'irc_masterop');
INSERT INTO group_roles (gid,role) VALUES(1,'irc_masterinvite');
INSERT INTO group_roles (gid,role) VALUES(1,'irc_scanreqs');
INSERT INTO group_roles (gid,role) VALUES(1,'irc_anonscan');
INSERT INTO group_roles (gid,role) VALUES(1,'irc_delquote');
INSERT INTO group_roles (gid,role) VALUES(1,'irc_points_others');
INSERT INTO group_roles (gid,role) VALUES(1,'irc_sms');
INSERT INTO group_roles (gid,role) VALUES(1,'irc_adduser');
INSERT INTO group_roles (gid,role) VALUES(1,'irc_deactivateuser');
INSERT INTO group_roles (gid,role) VALUES(1,'irc_chattr');
INSERT INTO group_roles (gid,role) VALUES(1,'irc_whois');
INSERT INTO group_roles (gid,role) VALUES(1,'irc_flag');
INSERT INTO group_roles (gid,role) VALUES(1,'irc_laston');
INSERT INTO group_roles (gid,role) VALUES(1,'irc_lastseen');

INSERT INTO group_roles (gid,role) VALUES(2,'irc_gs');
INSERT INTO group_roles (gid,role) VALUES(2,'irc_scan');

INSERT INTO group_roles (gid,role) VALUES(3,'irc_p_nick');
INSERT INTO group_roles (gid,role) VALUES(3,'irc_masterop');
INSERT INTO group_roles (gid,role) VALUES(3,'irc_masterinvite');
INSERT INTO group_roles (gid,role) VALUES(3,'irc_scanreqs');
INSERT INTO group_roles (gid,role) VALUES(3,'irc_anonscan');
INSERT INTO group_roles (gid,role) VALUES(3,'irc_delquote');
INSERT INTO group_roles (gid,role) VALUES(3,'irc_points_others');
INSERT INTO group_roles (gid,role) VALUES(3,'irc_sms');
INSERT INTO group_roles (gid,role) VALUES(3,'irc_adduser');
INSERT INTO group_roles (gid,role) VALUES(3,'irc_deactivateuser');
INSERT INTO group_roles (gid,role) VALUES(3,'irc_chattr');
INSERT INTO group_roles (gid,role) VALUES(3,'irc_whois');
INSERT INTO group_roles (gid,role) VALUES(3,'irc_flag');
INSERT INTO group_roles (gid,role) VALUES(3,'irc_laston');
INSERT INTO group_roles (gid,role) VALUES(3,'irc_lastseen');

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

INSERT INTO group_roles (gid,role) VALUES(5,'irc_p_nick');
INSERT INTO group_roles (gid,role) VALUES(5,'irc_p_intel');

INSERT INTO group_roles (gid,role) VALUES(6,'irc_p_intel');
INSERT INTO group_roles (gid,role) VALUES(6,'irc_points_others');
INSERT INTO group_roles (gid,role) VALUES(6,'irc_sms');

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

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

INSERT INTO group_roles (gid,role) VALUES(19,'irc_p_intel');
