X-Git-Url: http://git.rot13.org/?p=BackupPC.git;a=blobdiff_plain;f=sql%2Fxx_display_archive.sql;fp=sql%2Fxx_display_archive.sql;h=7dfb43f29d768fcd4a7aedf223f67ece31333dd3;hp=0000000000000000000000000000000000000000;hb=584b370f69032e4f1ea1ab37e83b523044cceeba;hpb=d9578b0f7c2269b3658cae14b62ae4dd7bb6b7da

diff --git a/sql/xx_display_archive.sql b/sql/xx_display_archive.sql
new file mode 100644
index 0000000..7dfb43f
--- /dev/null
+++ b/sql/xx_display_archive.sql
@@ -0,0 +1,13 @@
+select
+	hosts.name as host,
+	shares.name,
+	backups.num as share,
+	inc_size,
+	inc_deleted,
+	parts
+from archive_backup
+	join backups on backups.id = backup_id
+	join shares on shares.id = shareid
+	join hosts on hosts.id = shares.hostid
+where archive_id = 21 order by hosts.name, shares.name, backups.num ;
+