X-Git-Url: http://git.onelab.eu/?a=blobdiff_plain;ds=sidebyside;f=planetlab5.sql;h=a4ec8917df8b335cf9dc243205ccd38289d4d1de;hb=d30c6dd87cc81e28adb9a2631638badb9ffa0a41;hp=14632827f1f54e9ac279f94eec9df5466d13f058;hpb=2aca52e3a7a985c61228d536228868d7ccb14e79;p=plcapi.git

diff --git a/planetlab5.sql b/planetlab5.sql
index 1463282..a4ec891 100644
--- a/planetlab5.sql
+++ b/planetlab5.sql
@@ -13,6 +13,7 @@
 -- NOTE: this file was first created for version 4.3, the filename might be confusing
 --
 -- $Id$
+-- $URL$
 --
 
 SET client_encoding = 'UNICODE';
@@ -300,7 +301,6 @@ CREATE TABLE nodes (
     ssh_rsa_key text,					-- SSH host key updated by Boot Manager
     key text,						-- Node key generated when boot file is downloaded
 	verified boolean NOT NULL DEFAULT false,		-- whether or not the node & pcu are verified
-	extrainfo text,
 
     -- Timestamps
     date_created timestamp without time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
@@ -769,7 +769,7 @@ CREATE INDEX initscripts_name_idx ON initscripts (name);
 -- Peers
 CREATE TABLE peers (
     peer_id serial PRIMARY KEY,				-- Peer identifier
-    peername text UNIQUE NOT NULL,			-- Peer name
+    peername text 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
@@ -1080,7 +1080,6 @@ nodes.model,
 nodes.boot_nonce,
 nodes.version,
 nodes.verified,
-nodes.extrainfo,
 nodes.ssh_rsa_key,
 nodes.key,
 CAST(date_part('epoch', nodes.date_created) AS bigint) AS date_created,