/[BackupPC]/trunk/lib/BackupPC/SearchLib.pm
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/lib/BackupPC/SearchLib.pm

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

revision 331 by dpavlin, Mon Jan 30 15:12:14 2006 UTC revision 332 by dpavlin, Wed Feb 1 14:35:23 2006 UTC
# Line 462  print STDERR "## sort=". ($param->{'sort Line 462  print STDERR "## sort=". ($param->{'sort
462                  INNER JOIN shares       ON backups.shareID=shares.ID                  INNER JOIN shares       ON backups.shareID=shares.ID
463                  INNER JOIN hosts        ON backups.hostID = hosts.ID                  INNER JOIN hosts        ON backups.hostID = hosts.ID
464                  LEFT OUTER JOIN archive_backup ON archive_backup.backup_id = backups.id                  LEFT OUTER JOIN archive_backup ON archive_backup.backup_id = backups.id
465                  WHERE backups.inc_size > 0 AND backups.size > 0 AND backups.inc_deleted is false AND archive_backup.backup_id IS NULL                  WHERE backups.inc_size > 0 AND backups.size > 0 AND backups.inc_deleted is false AND archive_backup.backup_id IS NULL AND backups.parts > 0
466                  GROUP BY                  GROUP BY
467                          backups.hostID,                          backups.hostID,
468                          hosts.name,                          hosts.name,
Legend:
Removed from v.331  
changed lines
  Added in v.332
  ViewVC Help
Powered by ViewVC 1.1.26