X-Git-Url: http://git.onelab.eu/?a=blobdiff_plain;f=planetlab5.sql;fp=planetlab5.sql;h=fccc8ac73822104b5d5364c90cb9abf2ff9c8522;hb=7c328b743dd874fef3a85b6ac48a36ad8ef17590;hp=f2d261a601f848b95f7fa7cb898ffb55244c4836;hpb=9ab41b6e3f38f8aef3521dd05519e8064bdbca6b;p=plcapi.git

diff --git a/planetlab5.sql b/planetlab5.sql
index f2d261a..fccc8ac 100644
--- a/planetlab5.sql
+++ b/planetlab5.sql
@@ -771,13 +771,15 @@ CREATE INDEX initscripts_name_idx ON initscripts (name);
 -- Peers
 CREATE TABLE peers (
     peer_id serial PRIMARY KEY,				-- Peer identifier
-    peername text NOT NULL,				-- Peer name
+    peername text UNIQUE NOT NULL,			-- Peer name
     peer_url text NOT NULL,				-- (HTTPS) URL of the peer PLCAPI interface
     cacert text,					-- (SSL) Public certificate of peer API server
     key text,						-- (GPG) Public key used for authentication
+    shortname text,					-- abbreviated name for displaying foreign objects
     deleted boolean NOT NULL DEFAULT false
 ) WITH OIDS;
 CREATE INDEX peers_peername_idx ON peers (peername) WHERE deleted IS false;
+CREATE INDEX peers_shortname_idx ON peers (shortname) WHERE deleted IS false;
 
 -- Objects at each peer
 CREATE TABLE peer_site (