X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=database%2Fgroup_roles.sql;h=fc50bef26848e1d72b0f5c25568acb7774f404c1;hb=00325acb2f3a1ae09e4a73d09a33f056dfb60fda;hp=20efb1fe7c3f987b1a6f6cfbcd54d83d6597a2c3;hpb=f9f06136c85f9634c409b71e18452c358530556e;p=ndwebbie.git

diff --git a/database/group_roles.sql b/database/group_roles.sql
index 20efb1f..fc50bef 100644
--- a/database/group_roles.sql
+++ b/database/group_roles.sql
@@ -4,7 +4,8 @@ CREATE TABLE roles (
 
 CREATE TABLE group_roles (
 	gid INTEGER REFERENCES groups(gid),
-	role VARCHAR(32) REFERENCES roles(role)
+	role VARCHAR(32) REFERENCES roles(role),
+	PRIMARY KEY(gid,role)
 );
 
 INSERT INTO roles VALUES('member_menu');
@@ -16,6 +17,7 @@ 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 group_roles (gid,role) VALUES(2,'member_menu');
 INSERT INTO group_roles (gid,role) VALUES(2,'attack_menu');
@@ -30,6 +32,7 @@ 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(3,'dc_menu');
 INSERT INTO group_roles (gid,role) VALUES(3,'bc_menu');
@@ -37,3 +40,4 @@ 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');