BEGIN;

alter table network add column dns_server1 varchar(15);
update network set dns_server1 = '' where dns_server1 is null;
alter table network alter dns_server1 set default '';
alter table network alter dns_server1 set not null;

alter table network add column dns_server2 varchar(15);
update network set dns_server2 = '' where dns_server2 is null;
alter table network alter dns_server2 set default '';
alter table network alter dns_server2 set not null;

alter table network add column ntp_server1 varchar(15);
update network set ntp_server1 = '' where ntp_server1 is null;
alter table network alter ntp_server1 set default '';
alter table network alter ntp_server1 set not null;

alter table network add column ntp_server2 varchar(15);
update network set ntp_server2 = '' where ntp_server2 is null;
alter table network alter ntp_server2 set default '';
alter table network alter ntp_server2 set not null;

COMMIT;
