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 shares on shareid = shares.id
16 join hosts on backups.hostid = hosts.id
17 full outer join backup_parts on backups.id = backup_parts.backup_id
18 where backups.size > 0
29 having count(backup_parts.backup_id) <> parts