/[BackupPC]/trunk/sql/zz_dst_files_fix.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/zz_dst_files_fix.sql

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

revision 248 by dpavlin, Thu Nov 17 17:22:31 2005 UTC revision 249 by dpavlin, Fri Dec 9 16:27:49 2005 UTC
# Line 1  Line 1 
1    drop index dst_i1 ;
2    drop index dst_i2 ;
3    drop index dst_i3 ;
4    drop table dst_files_ids ;
5    drop table dst_files ;
6    
7    
8  select hostid,shareid,num,abstime(date),size,inc_size into dst_files from backups where date > abstime('2005-10-24')::int order by abstime,hostid,num;  select hostid,shareid,num,abstime(date),size,inc_size into dst_files from backups where date > abstime('2005-10-24')::int order by abstime,hostid,num;
9    
10    delete from archive_backup where backup_id in (select id from backups where date > abstime('2005-10-24')::int) ;
11  delete from backups where date > abstime('2005-10-24')::int;  delete from backups where date > abstime('2005-10-24')::int;
12  vacuum analyze backups;  vacuum analyze backups;
13    
Legend:
Removed from v.248  
changed lines
  Added in v.249
  ViewVC Help
Powered by ViewVC 1.1.26