1 -- check consistency of data for one DVD image. This is more detailed than
2 -- error message from BackupPC_Bur
6 backups.num as increment_name,
11 count(backup_parts.backup_id) as backup_parts,
15 join archive on archive_id = archive.id
16 join backups on backup_id = backups.id
17 join shares on shareid = shares.id
18 join hosts on backups.hostid = hosts.id
19 full outer join backup_parts on backups.id = backup_parts.backup_id
31 having count(backup_parts.backup_id) <> parts
32 order by inc_size desc