-- if LLDP is active on a network.
alter table network add column lldp varchar(3);
update network set lldp = 'no' where lldp IS NULL;
alter table network alter column lldp set not null;
alter table network alter column lldp set default 'no';
update network set lldp = 'no' where id = 1;
alter table network add constraint network_lldp_check CHECK (lldp IN ('yes', 'no'));
