BEGIN;

alter table phonetype add column speech_start varchar(12);
update phonetype set speech_start = '' where speech_start IS NULL;
alter table phonetype alter column speech_start set NOT NULL;
alter table phonetype alter column speech_start set default '';

alter table phonetype add column speech_stop varchar(12);
update phonetype set speech_stop = '' where speech_stop IS NULL;
alter table phonetype alter column speech_stop set NOT NULL;
alter table phonetype alter column speech_stop set default '';

INSERT INTO phonetype (id, cmsid, name, profile, lines, protocol, speech_start, speech_stop)
  VALUES (2000, 1,   'Antenna Carephone AP2000',     3, 1, 'DAHDI', 'w4w', 'w0w');

COMMIT;


