-- do DHCP on a certain network.
alter table network add column dhcp varchar(3) not null default 'yes';
alter table network add constraint network_dhcp_check CHECK (dhcp IN ('yes', 'no'));
update network set dhcp = 'no' where id = 1;
