git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@299
8392b6e1-25fa-0310-8288-
cc32f8e212ea
--- /dev/null
+-- 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 ;