X-Git-Url: http://git.vrable.net/?a=blobdiff_plain;f=contrib%2Fupgrade0.6-localdb.sql;fp=contrib%2Fupgrade0.6-localdb.sql;h=7256f9fcb4efb4c9b1c40b8b03a0ddaec6e08c5b;hb=0546d239071daa82a8b85348a7f66fba10d85aff;hp=d1449ac418516ba92294d4711328b2e856b5ce8d;hpb=d68fe153b690ebdb5cb84c027fc094e6f77a2bb5;p=cumulus.git

diff --git a/contrib/upgrade0.6-localdb.sql b/contrib/upgrade0.6-localdb.sql
index d1449ac..7256f9f 100644
--- a/contrib/upgrade0.6-localdb.sql
+++ b/contrib/upgrade0.6-localdb.sql
@@ -23,6 +23,8 @@ create table segments_used (
     segmentid integer not null,
     utilization real
 );
+create unique index segments_used_index
+    on segments_used(snapshotid, segmentid);
 
 alter table snapshots add column intent real;