alter table channel alter column username set not NULL;
alter table channel alter column username set default '';
alter table channel alter column secret set not NULL;
alter table channel alter column secret set default '';

update national_dialplan set isocode = '' where isocode IS NULL;
alter table national_dialplan alter column isocode set not NULL;
alter table national_dialplan alter column isocode set default '';

update national_dialplan set pattern = '' where pattern IS NULL;
alter table national_dialplan alter column pattern set not NULL;
alter table national_dialplan alter column pattern set default '';

update phoneline set company = '1' where company IS NULL;
alter table phoneline alter column company set not NULL;

update phoneline set contact = '1' where contact IS NULL;
alter table phoneline alter column contact set not NULL;

update phoneline set extension = '' where extension IS NULL;
alter table phoneline alter column extension set not NULL;
alter table phoneline alter column extension set default '';

update zonetab set isocode = '' where isocode IS NULL;
alter table zonetab alter column isocode set not NULL;
alter table zonetab alter column isocode set default '';

update zonetab set coordinates = '' where coordinates IS NULL;
alter table zonetab alter column coordinates set not NULL;
alter table zonetab alter column coordinates set default '';

update zonetab set timezone = '' where timezone IS NULL;
alter table zonetab alter column timezone set not NULL;
alter table zonetab alter column timezone set default '';

update zonetab set comments = '' where comments IS NULL;
alter table zonetab alter column comments set not NULL;
alter table zonetab alter column comments set default '';


