X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=database%2Froles.sql;h=d98dce654d471ed9cceb3ac48f97a210c8511b5a;hb=ca8f6135c9709112a5d6605ac34064f5946d9570;hp=49de3231f378a6731c302e68af784baf401dd414;hpb=7091b004eee879d36792d6da3b8fd4fb1b5f71bf;p=NDIRC.git diff --git a/database/roles.sql b/database/roles.sql index 49de323..d98dce6 100644 --- a/database/roles.sql +++ b/database/roles.sql @@ -1,20 +1,105 @@ 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 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(1,'irc_getships'); +INSERT INTO group_roles (gid,role) VALUES(1,'irc_getfleet'); +INSERT INTO group_roles (gid,role) VALUES(1,'irc_sethost'); +INSERT INTO group_roles (gid,role) VALUES(1,'irc_setpnick'); +INSERT INTO group_roles (gid,role) VALUES(1,'irc_a'); +INSERT INTO group_roles (gid,role) VALUES(1,'irc_d'); +INSERT INTO group_roles (gid,role) VALUES(1,'irc_s'); +INSERT INTO group_roles (gid,role) VALUES(1,'irc_h'); + +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(3,'irc_getships'); +INSERT INTO group_roles (gid,role) VALUES(3,'irc_getfleet'); +INSERT INTO group_roles (gid,role) VALUES(3,'irc_sethost'); +INSERT INTO group_roles (gid,role) VALUES(3,'irc_setpnick'); +INSERT INTO group_roles (gid,role) VALUES(3,'irc_a'); +INSERT INTO group_roles (gid,role) VALUES(3,'irc_d'); +INSERT INTO group_roles (gid,role) VALUES(3,'irc_s'); +INSERT INTO group_roles (gid,role) VALUES(3,'irc_h'); + +INSERT INTO group_roles (gid,role) VALUES(4,'irc_points_others'); +INSERT INTO group_roles (gid,role) VALUES(4,'irc_a'); 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(6,'irc_getships'); +INSERT INTO group_roles (gid,role) VALUES(6,'irc_getfleet'); +INSERT INTO group_roles (gid,role) VALUES(6,'irc_d'); + +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'); +INSERT INTO group_roles (gid,role) VALUES(19,'irc_h');