trunk/sql/dump_increments_filenames_from_dvd.sql

-- display all files (increments) on one DVD
select
        hosts.name || '_' ||
        shares.name || '_' ||
        backups.num as increment_name,
        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
order by inc_size desc
;
1	dpavlin	300	-- display all files (increments) on one DVD
2			select
3			hosts.name \|\| '_' \|\|
4			shares.name \|\| '_' \|\|
5			backups.num as increment_name,
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
18			order by inc_size desc
19			;