BEGIN;
alter table fastdial_contact add column descr_prompt integer;
update fastdial_contact set descr_prompt = '1' where descr_prompt IS NULL;
alter table fastdial_contact alter column descr_prompt set default '1';
alter table fastdial_contact alter column descr_prompt set not null;
ALTER TABLE fastdial_contact ADD CONSTRAINT fastdial_contact_descr_prompt_constraint FOREIGN KEY (descr_prompt) REFERENCES soundfile (id);

alter table fastdial_company add column descr_prompt integer;
update fastdial_company set descr_prompt = '1' where descr_prompt IS NULL;
alter table fastdial_company alter column descr_prompt set default '1';
alter table fastdial_company alter column descr_prompt set not null;
ALTER TABLE fastdial_company ADD CONSTRAINT fastdial_company_descr_prompt_constraint FOREIGN KEY (descr_prompt) REFERENCES soundfile (id);
COMMIT;

