2 role VARCHAR(32) UNIQUE NOT NULL
5 CREATE TABLE group_roles (
6 gid INTEGER REFERENCES groups(gid),
7 role VARCHAR(32) REFERENCES roles(role)
10 INSERT INTO roles VALUES('member_menu');
11 INSERT INTO roles VALUES('hc_menu');
12 INSERT INTO roles VALUES('bc_menu');
13 INSERT INTO roles VALUES('dc_menu');
14 INSERT INTO roles VALUES('intel_menu');
15 INSERT INTO roles VALUES('attack_menu');
16 INSERT INTO roles VALUES('no_fleet_update');
17 INSERT INTO roles VALUES('admin_users');
18 INSERT INTO roles VALUES('rankings_planet_intel');
20 INSERT INTO group_roles (gid,role) VALUES(2,'member_menu');
21 INSERT INTO group_roles (gid,role) VALUES(2,'attack_menu');
22 INSERT INTO group_roles (gid,role) VALUES(6,'dc_menu');
23 INSERT INTO group_roles (gid,role) VALUES(4,'bc_menu');
24 INSERT INTO group_roles (gid,role) VALUES(5,'intel_menu');
25 INSERT INTO group_roles (gid,role) VALUES(8,'no_fleet_update');
27 INSERT INTO group_roles (gid,role) VALUES(1,'dc_menu');
28 INSERT INTO group_roles (gid,role) VALUES(1,'bc_menu');
29 INSERT INTO group_roles (gid,role) VALUES(1,'hc_menu');
30 INSERT INTO group_roles (gid,role) VALUES(1,'intel_menu');
31 INSERT INTO group_roles (gid,role) VALUES(1,'admin_users');
32 INSERT INTO group_roles (gid,role) VALUES(1,'rankings_planet_intel');
34 INSERT INTO group_roles (gid,role) VALUES(3,'dc_menu');
35 INSERT INTO group_roles (gid,role) VALUES(3,'bc_menu');
36 INSERT INTO group_roles (gid,role) VALUES(3,'hc_menu');
37 INSERT INTO group_roles (gid,role) VALUES(3,'intel_menu');
38 INSERT INTO group_roles (gid,role) VALUES(3,'admin_users');
39 INSERT INTO group_roles (gid,role) VALUES(3,'rankings_planet_intel');