projects
/
BackupPC.git
/ blob
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
history
|
raw
|
HEAD
r10297@llin: dpavlin | 2006-03-01 14:40:39 +0100
[BackupPC.git]
/
sql
/
all_increments_on_dvd.sql
1
-- display all files (increments) on one DVD
2
select
3
hosts.name,
4
shares.name,
5
backups.num,
6
backups.date::abstime,
7
backups.type,
8
backups.size,
9
backups.parts,
10
backups.inc_size,
11
backups.inc_deleted
12
from archive_backup
13
join archive on archive_id = archive.id
14
join backups on backup_id = backups.id
15
join shares on shareid = shares.id
16
join hosts on backups.hostid = hosts.id
17
where dvd_nr = 14 ;