trunk/sql/fix_found_in_db.sql

-- fix database to repair found_in_db bug fixed in r74

delete from files where id not in (
        select distinct on(shareid,path,date,size) id
        from files
        order by shareid,path,date,size,backupnum asc
);
1	dpavlin	75	-- fix database to repair found_in_db bug fixed in r74
2
3			delete from files where id not in (
4			select distinct on(shareid,path,date,size) id
5			from files
6			order by shareid,path,date,size,backupnum asc
7			);