From: Tony Mack <tmack@cs.princeton.edu>
Date: Wed, 15 Nov 2006 16:42:12 +0000 (+0000)
Subject: - fix peer_slice_slice_id_idx
X-Git-Tag: pycurl-7_13_1~303
X-Git-Url: http://git.onelab.eu/?p=plcapi.git;a=commitdiff_plain;h=7e87a2ec0638e9116253ff73b207b6f4f6cd8c60

- fix peer_slice_slice_id_idx
---

diff --git a/planetlab4.sql b/planetlab4.sql
index 8b38319..1ae1461 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,