X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=database%2Fgroup_roles.sql;h=8a51c2b6c8fccdc973c4953adb90829478679dc8;hb=5d49b3579d2ad39f6ae9bc2dba37ebbf0334e0da;hp=e890bb5ce7e6e7b6a13606e625639f665234de69;hpb=49c23244b1ba61909b726bb9189665a33027a1af;p=ndwebbie.git

diff --git a/database/group_roles.sql b/database/group_roles.sql
index e890bb5..8a51c2b 100644
--- a/database/group_roles.sql
+++ b/database/group_roles.sql
@@ -1,10 +1,11 @@
 CREATE TABLE roles (
-	role VARCHAR(20) UNIQUE NOT NULL
+	role VARCHAR(32) UNIQUE NOT NULL
 );
 
 CREATE TABLE group_roles (
 	gid INTEGER REFERENCES groups(gid),
-	role VARCHAR(20) REFERENCES roles(role)
+	role VARCHAR(32) REFERENCES roles(role),
+	PRIMARY KEY(gid,role)
 );
 
 INSERT INTO roles VALUES('member_menu');
@@ -14,20 +15,69 @@ INSERT INTO roles VALUES('dc_menu');
 INSERT INTO roles VALUES('intel_menu');
 INSERT INTO roles VALUES('attack_menu');
 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('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('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 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(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(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(1,'dc_menu');
 INSERT INTO group_roles (gid,role) VALUES(1,'bc_menu');
 INSERT INTO group_roles (gid,role) VALUES(1,'hc_menu');
 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,'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,'raids_info');
+INSERT INTO group_roles (gid,role) VALUES(1,'raids_edit');
 
 INSERT INTO group_roles (gid,role) VALUES(3,'dc_menu');
 INSERT INTO group_roles (gid,role) VALUES(3,'bc_menu');
 INSERT INTO group_roles (gid,role) VALUES(3,'hc_menu');
 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,'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,'raids_info');
+INSERT INTO group_roles (gid,role) VALUES(3,'raids_edit');