2 role VARCHAR(20) UNIQUE NOT NULL
5 CREATE TABLE group_roles (
6 gid INTEGER REFERENCES groups(gid),
7 role VARCHAR(20) 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');
18 INSERT INTO group_roles (gid,role) VALUES(2,'member_menu');
19 INSERT INTO group_roles (gid,role) VALUES(2,'attack_menu');
20 INSERT INTO group_roles (gid,role) VALUES(6,'dc_menu');
21 INSERT INTO group_roles (gid,role) VALUES(4,'bc_menu');
22 INSERT INTO group_roles (gid,role) VALUES(5,'intel_menu');
23 INSERT INTO group_roles (gid,role) VALUES(8,'no_fleet_update');
25 INSERT INTO group_roles (gid,role) VALUES(1,'dc_menu');
26 INSERT INTO group_roles (gid,role) VALUES(1,'bc_menu');
27 INSERT INTO group_roles (gid,role) VALUES(1,'hc_menu');
28 INSERT INTO group_roles (gid,role) VALUES(1,'intel_menu');
30 INSERT INTO group_roles (gid,role) VALUES(3,'dc_menu');
31 INSERT INTO group_roles (gid,role) VALUES(3,'bc_menu');
32 INSERT INTO group_roles (gid,role) VALUES(3,'hc_menu');
33 INSERT INTO group_roles (gid,role) VALUES(3,'intel_menu');