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