trunk/sql/zz_archive_burned_copy_fix.sql

begin;

select * from archive_burned order by archive_id,part,copy;

select * into a from archive_burned where archive_id in (select archive_id from archive_burned group by archive_id having sum(copy) < 2) ;

update a set copy = 2 ;

insert into archive_burned select * from a;

select * from archive_burned order by archive_id,part,copy;

drop table a ;

-- alternative
-- insert into archive_burned select archive_id,date,part,2,iso_size from archive_burned where archive_id in (select archive_id from archive_burned group by archive_id having count(*) = 1);

1	dpavlin	272	begin;
2
3			select * from archive_burned order by archive_id,part,copy;
4
5			select * into a from archive_burned where archive_id in (select archive_id from archive_burned group by archive_id having sum(copy) < 2) ;
6
7			update a set copy = 2 ;
8
9			insert into archive_burned select * from a;
10
11			select * from archive_burned order by archive_id,part,copy;
12
13			drop table a ;
14
15	dpavlin	358	-- alternative
16			-- insert into archive_burned select archive_id,date,part,2,iso_size from archive_burned where archive_id in (select archive_id from archive_burned group by archive_id having count(*) = 1);
17