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