projects
/
BackupPC.git
/ blob
commit
grep
author
committer
pickaxe
?
search:
re
7dfb43f29d768fcd4a7aedf223f67ece31333dd3
[BackupPC.git]
/
sql
/
xx_display_archive.sql
1
select
2
hosts.name as host,
3
shares.name,
4
backups.num as share,
5
inc_size,
6
inc_deleted,
7
parts
8
from archive_backup
9
join backups on backups.id = backup_id
10
join shares on shares.id = shareid
11
join hosts on hosts.id = shares.hostid
12
where archive_id = 21 order by hosts.name, shares.name, backups.num ;
13