X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=database%2Fgroup_roles.sql;h=e1c81b1f6e07f973066e129e5165ff1bac7debc5;hb=be99623fcecb41431020f1cd46a2dca56f9c467a;hp=fc50bef26848e1d72b0f5c25568acb7774f404c1;hpb=00325acb2f3a1ae09e4a73d09a33f056dfb60fda;p=ndwebbie.git diff --git a/database/group_roles.sql b/database/group_roles.sql index fc50bef..e1c81b1 100644 --- a/database/group_roles.sql +++ b/database/group_roles.sql @@ -18,14 +18,57 @@ INSERT INTO roles VALUES('no_fleet_update'); INSERT INTO roles VALUES('admin_users'); INSERT INTO roles VALUES('rankings_planet_intel'); INSERT INTO roles VALUES('alliances_resources'); +INSERT INTO roles VALUES('alliances'); +INSERT INTO roles VALUES('graphs_intel'); +INSERT INTO roles VALUES('members'); +INSERT INTO roles VALUES('members_points_nolimit'); +INSERT INTO roles VALUES('covop'); +INSERT INTO roles VALUES('calls_list'); +INSERT INTO roles VALUES('calls_edit'); +INSERT INTO roles VALUES('calls_leeches'); +INSERT INTO roles VALUES('raids_info'); +INSERT INTO roles VALUES('raids_edit'); +INSERT INTO roles VALUES('stats_intel'); +INSERT INTO roles VALUES('stats_details'); +INSERT INTO roles VALUES('stats_missions'); +INSERT INTO roles VALUES('stats_scans'); +INSERT INTO roles VALUES('stats_planetdata'); +INSERT INTO roles VALUES('intel'); +INSERT INTO roles VALUES('intel_members'); +INSERT INTO roles VALUES('intel_member'); +INSERT INTO roles VALUES('intel_naps'); +INSERT INTO roles VALUES('textexport_alliance'); +INSERT INTO roles VALUES('stats_find_nick'); +INSERT INTO roles VALUES('members_defenders'); INSERT INTO group_roles (gid,role) VALUES(2,'member_menu'); INSERT INTO group_roles (gid,role) VALUES(2,'attack_menu'); +INSERT INTO group_roles (gid,role) VALUES(2,'members'); +INSERT INTO group_roles (gid,role) VALUES(2,'covop'); +INSERT INTO group_roles (gid,role) VALUES(2,'stats_details'); +INSERT INTO group_roles (gid,role) VALUES(2,'stats_missions'); +INSERT INTO group_roles (gid,role) VALUES(2,'stats_scans'); +INSERT INTO group_roles (gid,role) VALUES(2,'stats_planetdata'); + INSERT INTO group_roles (gid,role) VALUES(6,'dc_menu'); +INSERT INTO group_roles (gid,role) VALUES(6,'calls_list'); +INSERT INTO group_roles (gid,role) VALUES(6,'calls_edit'); +INSERT INTO group_roles (gid,role) VALUES(6,'calls_leeches'); +INSERT INTO group_roles (gid,role) VALUES(6,'members_defenders'); + INSERT INTO group_roles (gid,role) VALUES(4,'bc_menu'); +INSERT INTO group_roles (gid,role) VALUES(4,'raids_info'); +INSERT INTO group_roles (gid,role) VALUES(4,'raids_edit'); + INSERT INTO group_roles (gid,role) VALUES(5,'intel_menu'); +INSERT INTO group_roles (gid,role) VALUES(5,'intel'); + INSERT INTO group_roles (gid,role) VALUES(8,'no_fleet_update'); +INSERT INTO group_roles (gid,role) VALUES(9,'members_points_nolimit'); +INSERT INTO group_roles (gid,role) VALUES(9,'stats_intel'); +INSERT INTO group_roles (gid,role) VALUES(9,'stats_find_nick'); + INSERT INTO group_roles (gid,role) VALUES(1,'dc_menu'); INSERT INTO group_roles (gid,role) VALUES(1,'bc_menu'); INSERT INTO group_roles (gid,role) VALUES(1,'hc_menu'); @@ -33,6 +76,19 @@ INSERT INTO group_roles (gid,role) VALUES(1,'intel_menu'); INSERT INTO group_roles (gid,role) VALUES(1,'admin_users'); INSERT INTO group_roles (gid,role) VALUES(1,'rankings_planet_intel'); INSERT INTO group_roles (gid,role) VALUES(1,'alliances_resources'); +INSERT INTO group_roles (gid,role) VALUES(1,'alliances'); +INSERT INTO group_roles (gid,role) VALUES(1,'graphs_intel'); +INSERT INTO group_roles (gid,role) VALUES(1,'calls_list'); +INSERT INTO group_roles (gid,role) VALUES(1,'calls_edit'); +INSERT INTO group_roles (gid,role) VALUES(1,'calls_leeches'); +INSERT INTO group_roles (gid,role) VALUES(1,'raids_info'); +INSERT INTO group_roles (gid,role) VALUES(1,'raids_edit'); +INSERT INTO group_roles (gid,role) VALUES(1,'intel'); +INSERT INTO group_roles (gid,role) VALUES(1,'intel_members'); +INSERT INTO group_roles (gid,role) VALUES(1,'intel_member'); +INSERT INTO group_roles (gid,role) VALUES(1,'intel_naps'); +INSERT INTO group_roles (gid,role) VALUES(1,'textexport_alliance'); +INSERT INTO group_roles (gid,role) VALUES(1,'members_defenders'); INSERT INTO group_roles (gid,role) VALUES(3,'dc_menu'); INSERT INTO group_roles (gid,role) VALUES(3,'bc_menu'); @@ -41,3 +97,16 @@ INSERT INTO group_roles (gid,role) VALUES(3,'intel_menu'); INSERT INTO group_roles (gid,role) VALUES(3,'admin_users'); INSERT INTO group_roles (gid,role) VALUES(3,'rankings_planet_intel'); INSERT INTO group_roles (gid,role) VALUES(3,'alliances_resources'); +INSERT INTO group_roles (gid,role) VALUES(3,'alliances'); +INSERT INTO group_roles (gid,role) VALUES(3,'graphs_intel'); +INSERT INTO group_roles (gid,role) VALUES(3,'calls_list'); +INSERT INTO group_roles (gid,role) VALUES(3,'calls_edit'); +INSERT INTO group_roles (gid,role) VALUES(3,'calls_leeches'); +INSERT INTO group_roles (gid,role) VALUES(3,'raids_info'); +INSERT INTO group_roles (gid,role) VALUES(3,'raids_edit'); +INSERT INTO group_roles (gid,role) VALUES(3,'intel'); +INSERT INTO group_roles (gid,role) VALUES(3,'intel_members'); +INSERT INTO group_roles (gid,role) VALUES(3,'intel_member'); +INSERT INTO group_roles (gid,role) VALUES(3,'intel_naps'); +INSERT INTO group_roles (gid,role) VALUES(3,'textexport_alliance'); +INSERT INTO group_roles (gid,role) VALUES(3,'members_defenders');