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	-- 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	);