--from backups
--join shares on backups.shareid=shares.id
--join hosts on shares.hostid = hosts.id
---left outer join archive_backup on backups.id = archive_backup.backup_id
---left outer join archive on archive_backup.archive_id = archive.id
+--left outer join archive_backup_parts on backups.id = archive_backup_parts.backup_id
+--left outer join archive on archive_backup_parts.archive_id = archive.id
--where backups.parts > 0 and size > 0
--order by backups.date
--;
JOIN backups ON backup_id = backups.id
JOIN hosts ON hostid = hosts.id
JOIN shares ON shareid = shares.id
-ORDER BY backup_id, part_nr
;
+CREATE VIEW backups_burned AS
+SELECT
+ backup_id,
+ count(backup_id) = count(backup_part_id) as burned
+FROM archive
+JOIN archive_parts ON archive.id = archive_id
+JOIN backup_parts ON backup_part_id = backup_id
+GROUP BY backup_id
+;
+
+-- triggers for backup_parts consistency
create or replace function backup_parts_check() returns trigger as '
declare
b_parts integer;