From 18ee3e55f628026a1f6a93754cf9887fda3bbacb Mon Sep 17 00:00:00 2001
From: Thierry Parmentelat <thierry.parmentelat@sophia.inria.fr>
Date: Fri, 17 Nov 2006 10:43:17 +0000
Subject: [PATCH] added in view site_slices WHERE deleted is false so that
 deleted slices dont get reported in Site, and more importantly dont get
 counted when checking for max_slices at slice creation

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

diff --git a/planetlab4.sql b/planetlab4.sql
index 812135d6..cdb20f63 100644
--- a/planetlab4.sql
+++ b/planetlab4.sql
@@ -9,7 +9,7 @@
 --
 -- Copyright (C) 2006 The Trustees of Princeton University
 --
--- $Id: planetlab4.sql,v 1.38 2006/11/15 21:34:48 tmack Exp $
+-- $Id: planetlab4.sql,v 1.39 2006/11/16 17:03:36 mlhuang Exp $
 --
 
 --------------------------------------------------------------------------------
@@ -591,6 +591,7 @@ CREATE VIEW site_slices AS
 SELECT site_id,
 array_accum(slice_id) AS slice_ids
 FROM slices
+WHERE deleted is false
 GROUP BY site_id;
 
 -- Slices - peer relationship
-- 
2.47.0