X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=database%2Fgroup_roles.sql;h=45118aea811d7ff8dc567793c965914de3c50a8b;hb=88534ccb5763a823eec9147f63c732588e275e6a;hp=c5bcd3251500285a90eb749453a96c0c7e086e9b;hpb=e3d87e31652374c184db31c915814f8bc4d7cbd4;p=ndwebbie.git

diff --git a/database/group_roles.sql b/database/group_roles.sql
index c5bcd32..45118ae 100644
--- a/database/group_roles.sql
+++ b/database/group_roles.sql
@@ -18,6 +18,7 @@ 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');
@@ -33,6 +34,13 @@ 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 roles VALUES('stats_tags_all');
 
 INSERT INTO group_roles (gid,role) VALUES(2,'member_menu');
 INSERT INTO group_roles (gid,role) VALUES(2,'attack_menu');
@@ -47,18 +55,23 @@ 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('D','stats_tags_all');
 
 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('B','stats_tags_all');
 
 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('I','stats_tags_all');
 
 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');
@@ -67,6 +80,7 @@ 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');
@@ -74,6 +88,11 @@ 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');
@@ -82,6 +101,7 @@ 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');
@@ -89,3 +109,12 @@ 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');
+
+INSERT INTO group_roles (gid,role) VALUES('R','stats_tags_all');
+
+INSERT INTO group_roles (gid,role) VALUES('s','stats_tags_all');