alter table network add column vlan_id integer;
update network set vlan_id = (select vlan_id from building where id = network.building) where vlan_id IS NULL;
alter table network alter column vlan_id set default '0';
alter table network alter column vlan_id set NOT NULL;

alter table network add column vlan_qos integer;
update network set vlan_qos = (select vlan_qos from building where id = network.building) where vlan_qos IS NULL;
alter table network alter column vlan_qos set default '7';
alter table network alter column vlan_qos set NOT NULL;

alter table building drop column vlan_id;
alter table building drop column vlan_qos;
