X-Git-Url: http://git.onelab.eu/?a=blobdiff_plain;f=planetlab5.sql;fp=planetlab5.sql;h=aa79b56506646e34186271eb7dd9b5e1f55c23c3;hb=5b3409148b4100ff8cde3636d6c68c8f07ad8a87;hp=1ae9aef2f810d84c113ed5db1def93154665e515;hpb=89293f4a7291654595c95dd0b603bdd7b2702d12;p=plcapi.git

diff --git a/planetlab5.sql b/planetlab5.sql
index 1ae9aef..aa79b56 100644
--- a/planetlab5.sql
+++ b/planetlab5.sql
@@ -50,6 +50,20 @@ CREATE AGGREGATE array_accum (
     initcond = '{}'
 );
 
+--------------------------------------------------------------------------------
+-- Roles
+--------------------------------------------------------------------------------
+
+-- Valid account roles
+CREATE TABLE roles (
+    role_id integer PRIMARY KEY,			-- Role identifier
+    name text UNIQUE NOT NULL				-- Role symbolic name
+) WITH OIDS;
+INSERT INTO roles (role_id, name) VALUES (10, 'admin');
+INSERT INTO roles (role_id, name) VALUES (20, 'pi');
+INSERT INTO roles (role_id, name) VALUES (30, 'user');
+INSERT INTO roles (role_id, name) VALUES (40, 'tech');
+
 --------------------------------------------------------------------------------
 -- The building block for attaching tags
 --------------------------------------------------------------------------------
@@ -308,16 +322,6 @@ GROUP BY person_id;
 -- Account roles
 --------------------------------------------------------------------------------
 
--- Valid account roles
-CREATE TABLE roles (
-    role_id integer PRIMARY KEY,			-- Role identifier
-    name text UNIQUE NOT NULL				-- Role symbolic name
-) WITH OIDS;
-INSERT INTO roles (role_id, name) VALUES (10, 'admin');
-INSERT INTO roles (role_id, name) VALUES (20, 'pi');
-INSERT INTO roles (role_id, name) VALUES (30, 'user');
-INSERT INTO roles (role_id, name) VALUES (40, 'tech');
-
 CREATE TABLE person_role (
     person_id integer REFERENCES persons NOT NULL,	-- Account identifier
     role_id integer REFERENCES roles NOT NULL,		-- Role identifier