generate increment filenames for DVD

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@300 8392b6e1-25fa-0310-8288-cc32f8e212ea

diff --git a/sql/dump_increments_filenames_from_dvd.sql b/sql/dump_increments_filenames_from_dvd.sql
new file mode 100644 (file)
index 0000000..adc0b45
--- /dev/null
+++ b/sql/dump_increments_filenames_from_dvd.sql
@@ -0,0 +1,19 @@
+-- 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
+;