From c7cf9628d6e44fa007dac5987c940850fba6aa79 Mon Sep 17 00:00:00 2001
From: dpavlin <dpavlin@8392b6e1-25fa-0310-8288-cc32f8e212ea>
Date: Thu, 26 Jan 2006 23:10:05 +0000
Subject: [PATCH] generate increment filenames for DVD

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@300 8392b6e1-25fa-0310-8288-cc32f8e212ea
---
 sql/dump_increments_filenames_from_dvd.sql | 19 +++++++++++++++++++
 1 file changed, 19 insertions(+)
 create mode 100644 sql/dump_increments_filenames_from_dvd.sql

diff --git a/sql/dump_increments_filenames_from_dvd.sql b/sql/dump_increments_filenames_from_dvd.sql
new file mode 100644
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
+;
-- 
2.20.1