/[BackupPC]/trunk/sql/backups_full.sql
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Diff of /trunk/sql/backups_full.sql

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 103 by dpavlin, Tue Aug 30 22:43:57 2005 UTC revision 238 by dpavlin, Thu Nov 17 15:00:26 2005 UTC
# Line 4  select Line 4  select
4          hosts.name as host,          hosts.name as host,
5          shares.name as share,          shares.name as share,
6          backupnum as num,          backupnum as num,
7          backups.date as backup_date,          abstime(backups.date) as backup_date,
8          backups.type as type,          backups.type as type,
9          min(files.date) as from,          abstime(min(files.date)) as from,
10          max(files.date) as to,          abstime(max(files.date)) as to,
11          count(*) as files,          count(*) as files,
12          sum(files.size) as size,          sum(files.size) as size,
13          sum(backups.size) as backup_size          sum(backups.size) as backup_size
Legend:
Removed from v.103  
changed lines
  Added in v.238
  ViewVC Help
Powered by ViewVC 1.1.26