trunk/sql/zz_clean_archive_reset_dvd_nr.sql

-- WARNING: this is destructive operation which erase all archive data and
-- reset dvd_nr to 1. You have to commit it manually!

begin;
delete from archive_burned ;
delete from archive ;
select setval('dvd_nr', 1, false) ;
1	-- WARNING: this is destructive operation which erase all archive data and
2	-- reset dvd_nr to 1. You have to commit it manually!
3
4	begin;
5	delete from archive_burned ;
6	delete from archive ;
7	select setval('dvd_nr', 1, false) ;