alter table iv_price_lists add column credit_percent numeric(12,5);
alter table iv_price_lists alter column credit_percent set default 0;

alter table iv_offers add column credit_percent numeric(12,5);
alter table iv_offers alter column credit_percent set default 0;

alter table iv_offers add column status varchar(10);
alter table iv_offers alter column status set default 'new';

alter table iv_invoices add column status varchar(10);
alter table iv_invoices alter column status set default 'new';

update iv_price_lists set credit_percent = 0;
update iv_offers set status = 'new', credit_percent = 0;
update iv_invoices set status = 'new';