From 7e87a2ec0638e9116253ff73b207b6f4f6cd8c60 Mon Sep 17 00:00:00 2001 From: Tony Mack Date: Wed, 15 Nov 2006 16:42:12 +0000 Subject: [PATCH] - fix peer_slice_slice_id_idx --- planetlab4.sql | 15 +++++++++++++-- 1 file changed, 13 insertions(+), 2 deletions(-) diff --git a/planetlab4.sql b/planetlab4.sql index 8b38319e..1ae1461c 100644 --- a/planetlab4.sql +++ b/planetlab4.sql @@ -9,7 +9,7 @@ -- -- Copyright (C) 2006 The Trustees of Princeton University -- --- $Id: planetlab4.sql,v 1.34 2006/11/14 09:44:40 thierry Exp $ +-- $Id: planetlab4.sql,v 1.35 2006/11/15 10:59:54 thierry Exp $ -- -------------------------------------------------------------------------------- @@ -25,6 +25,17 @@ CREATE AGGREGATE array_accum ( initcond = '{}' ); +-------------------------------------------------------------------------------- +-- Version +-------------------------------------------------------------------------------- + +--version +CREATE TABLE plc_db_version ( + version integer NOT NULL +) WITH OIDS; + +INSERT INTO plc_db_version (version) VALUES (4); + -------------------------------------------------------------------------------- -- Accounts -------------------------------------------------------------------------------- @@ -589,7 +600,7 @@ CREATE TABLE peer_slice ( PRIMARY KEY (peer_id, slice_id) ) WITH OIDS; CREATE INDEX peer_slice_peer_id_idx ON peer_slice (peer_id); -CREATE INDEX peer_slice_slice_id_idx ON peer_slice (node_id); +CREATE INDEX peer_slice_slice_id_idx ON peer_slice (slice_id); CREATE VIEW peer_slices AS SELECT peer_id, -- 2.47.0