projects
/
cumulus.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Extend object reference syntax with size assertions.
[cumulus.git]
/
contrib
/
upgrade0.6-localdb.sql
diff --git
a/contrib/upgrade0.6-localdb.sql
b/contrib/upgrade0.6-localdb.sql
index
d1449ac
..
49fc1aa
100644
(file)
--- a/
contrib/upgrade0.6-localdb.sql
+++ b/
contrib/upgrade0.6-localdb.sql
@@
-15,7
+15,8
@@
create table segments_new (
path text,
checksum text,
mtime real,
path text,
checksum text,
mtime real,
- size integer
+ size integer,
+ expire_time integer
);
create table segments_used (
);
create table segments_used (
@@
-23,6
+24,8
@@
create table segments_used (
segmentid integer not null,
utilization real
);
segmentid integer not null,
utilization real
);
+create unique index segments_used_index
+ on segments_used(snapshotid, segmentid);
alter table snapshots add column intent real;
alter table snapshots add column intent real;
@@
-33,7
+36,7
@@
update snapshots set intent = 1;
-- Compute the size of each of the segments, if possible, based on our
-- knowledge of the objects stored in them.
insert into segments_new
-- Compute the size of each of the segments, if possible, based on our
-- knowledge of the objects stored in them.
insert into segments_new
-select segmentid, segment, path, checksum, mtime, size
+select segmentid, segment, path, checksum, mtime, size
, null as expire_time
from
(select segmentid, segment, path, checksum from segments)
left join
from
(select segmentid, segment, path, checksum from segments)
left join
@@
-65,8
+68,8
@@
drop view cleaning_order;
drop view segment_info;
create view segment_info as
drop view segment_info;
create view segment_info as
-select segmentid, mtime, size,
cast(size * utilization as integer) as used
,
- utilization
+select segmentid, mtime, size,
expire_time
,
+
cast(size * utilization as integer) as used,
utilization
from segments join
(select segmentid, max(utilization) as utilization
from segments_used group by segmentid)
from segments join
(select segmentid, max(utilization) as utilization
from segments_used group by segmentid)