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	dpavlin	219	-- 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;