alter table schedule add column greeting integer;
update schedule set greeting = '1' where greeting IS NULL;
alter table schedule alter column greeting set default '1';
alter table schedule alter column greeting set not null;

alter table schedule add column phoneline1 integer;
update schedule set phoneline1 = '1' where phoneline1 IS NULL;
alter table schedule alter column phoneline1 set default '1';
alter table schedule alter column phoneline1 set not null;

alter table schedule add column phoneline2 integer;
update schedule set phoneline2 = '1' where phoneline2 IS NULL;
alter table schedule alter column phoneline2 set default '1';
alter table schedule alter column phoneline2 set not null;

alter table schedule add column phoneline3 integer;
update schedule set phoneline3 = '1' where phoneline3 IS NULL;
alter table schedule alter column phoneline3 set default '1';
alter table schedule alter column phoneline3 set not null;

update schedule set phoneline1 = phoneline;

ALTER TABLE schedule ADD CONSTRAINT schedule_greeting_constraint  FOREIGN KEY (greeting) REFERENCES soundfile(id);
ALTER TABLE schedule ADD CONSTRAINT schedule_phoneline1_constraint  FOREIGN KEY (phoneline1) REFERENCES phoneline (id);
ALTER TABLE schedule ADD CONSTRAINT schedule_phoneline2_constraint  FOREIGN KEY (phoneline2) REFERENCES phoneline (id);
ALTER TABLE schedule ADD CONSTRAINT schedule_phoneline3_constraint  FOREIGN KEY (phoneline3) REFERENCES phoneline (id);
