trunk/sql/all_increments_on_dvd.sql

-- display all files (increments) on one DVD
select
        hosts.name,
        shares.name,
        backups.num,
        backups.date::abstime,
        backups.type,
        backups.size,
        backups.parts,
        backups.inc_size,
        backups.inc_deleted
from archive_backup
join archive on archive_id = archive.id
join backups on backup_id = backups.id
join shares on shareid = shares.id
join hosts on backups.hostid = hosts.id
where dvd_nr = 14 ;
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 ;