trunk/sql/02a_backups_id.sql

-- add id to backups table

alter table backups add column id int ;
create sequence backups_id_seq ;
alter table backups alter id set default nextval('public.backups_id_seq'::text) ;
update backups set id = nextval('public.backups_id_seq') ;
create unique index backups_id on backups(id) ;
1	-- add id to backups table
2
3	alter table backups add column id int ;
4	create sequence backups_id_seq ;
5	alter table backups alter id set default nextval('public.backups_id_seq'::text) ;
6	update backups set id = nextval('public.backups_id_seq') ;
7	create unique index backups_id on backups(id) ;