Converted rankings

[ndwebbie.git] / database / group_roles.sql

diff --git a/database/group_roles.sql b/database/group_roles.sql
index b6165abbd3b55983fcb6b497bd5d12f430d8c9ed..20efb1fe7c3f987b1a6f6cfbcd54d83d6597a2c3 100644 (file)
--- a/database/group_roles.sql
+++ b/database/group_roles.sql
@@ -1,10 +1,10 @@
 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)
 );
 
 INSERT INTO roles VALUES('member_menu');
@@ -15,6 +15,7 @@ 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 group_roles (gid,role) VALUES(2,'member_menu');
 INSERT INTO group_roles (gid,role) VALUES(2,'attack_menu');
@@ -28,9 +29,11 @@ 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(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');