From 07982140f95f85fd818cf88cc05dee67425bd62a Mon Sep 17 00:00:00 2001
From: Tony Mack <tmack@cs.princeton.edu>
Date: Wed, 21 Feb 2007 20:00:12 +0000
Subject: [PATCH] - add 'ext_consortium_id' field to 'sites' table and
 'view_sites' view

---
 planetlab4.sql | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

diff --git a/planetlab4.sql b/planetlab4.sql
index f24939f..753b005 100644
--- a/planetlab4.sql
+++ b/planetlab4.sql
@@ -9,7 +9,7 @@
 --
 -- Copyright (C) 2006 The Trustees of Princeton University
 --
--- $Id: planetlab4.sql,v 1.70 2007/01/31 19:54:42 mlhuang Exp $
+-- $Id: planetlab4.sql,v 1.71 2007/02/01 23:05:59 mlhuang Exp $
 --
 
 SET client_encoding = 'UNICODE';
@@ -91,6 +91,7 @@ CREATE TABLE sites (
     latitude real,
     longitude real,
     url text,
+    ext_consortium_id integer,	-- external consortium id     
 
     -- Timestamps
     date_created timestamp without time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
@@ -900,6 +901,7 @@ sites.max_slivers,
 sites.latitude,
 sites.longitude,
 sites.url,
+sites.ext_consortium_id,
 CAST(date_part('epoch', sites.date_created) AS bigint) AS date_created,
 CAST(date_part('epoch', sites.last_updated) AS bigint) AS last_updated,
 peer_site.peer_id,
-- 
2.43.0