trunk/sql/backups_without_packup_parts.sql

-- find backups without corresponding rows in backup_parts (database consistency check)
select hosts.name as host, shares.name as share, backups.num, backups.date::abstime, type, size, inc_size, inc_deleted, parts, dvd_nr
from backups
join hosts on hostid=hosts.id
join shares on shareid=shares.id
full outer join archive_backup on archive_backup.backup_id = backups.id
full outer join archive on archive.id = archive_backup.archive_id
where backups.id not in (select backup_id from backup_parts)
        and inc_deleted is false
        and size > 0
order by host,share,num
;
1	dpavlin	290	-- find backups without corresponding rows in backup_parts (database consistency check)
2			select hosts.name as host, shares.name as share, backups.num, backups.date::abstime, type, size, inc_size, inc_deleted, parts, dvd_nr
3			from backups
4			join hosts on hostid=hosts.id
5			join shares on shareid=shares.id
6			full outer join archive_backup on archive_backup.backup_id = backups.id
7			full outer join archive on archive.id = archive_backup.archive_id
8			where backups.id not in (select backup_id from backup_parts)
9			and inc_deleted is false
10			and size > 0
11			order by host,share,num
12			;