From: Thierry Parmentelat <thierry.parmentelat@sophia.inria.fr>
Date: Sat, 6 Feb 2010 14:38:35 +0000 (+0000)
Subject: fix order
X-Git-Tag: PLCAPI-5.0-2^2~3
X-Git-Url: http://git.onelab.eu/?p=plcapi.git;a=commitdiff_plain;h=5b3409148b4100ff8cde3636d6c68c8f07ad8a87

fix order
---

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