trunk/sql/all_files.sql

-- dump all files. Might be VERY VERY slow on large backup pools

select
        files.id as unique_id,
        hosts.name as host,
        shares.name as share,
        backupnum as num,
        backups.date as backup_date,
        backups.type as type,
        files.path as path,
        files.date as date,
        files.size as size,
        backups.size as backup_size
from files
join shares on files.shareid = shares.id
join hosts on shares.hostid = hosts.id
join backups on shares.hostid = backups.hostid
        and files.backupnum = backups.num
        and shares.id = backups.shareid
order by backups.date;
1	-- dump all files. Might be VERY VERY slow on large backup pools
2
3	select
4	files.id as unique_id,
5	hosts.name as host,
6	shares.name as share,
7	backupnum as num,
8	backups.date as backup_date,
9	backups.type as type,
10	files.path as path,
11	files.date as date,
12	files.size as size,
13	backups.size as backup_size
14	from files
15	join shares on files.shareid = shares.id
16	join hosts on shares.hostid = hosts.id
17	join backups on shares.hostid = backups.hostid
18	and files.backupnum = backups.num
19	and shares.id = backups.shareid
20	order by backups.date;