alter table locations modify LTL int not null;
alter table locations modify MTL int not null;
alter table locations modify ARIS int not null;
alter table locations modify VacuumR int not null;
alter table locations modify VacuumE int not null;
alter table locations modify RFCA int not null;
alter table locations modify He int not null;
alter table locations modify N2 int not null;
alter table locations modify CO2 int not null;
alter table locations modify Ar int not null;
alter table locations modify overhead double not null;
alter table locations modify power double not null;
alter table locations modify DDCU varchar(50) not null;

alter table rackdata modify MTL_calc int not null;
alter table rackdata modify LTL_calc int not null;

alter table rackinterfaces modify LTL int not null;
alter table rackinterfaces modify MTL int not null;
alter table rackinterfaces modify ARIS int not null;
alter table rackinterfaces modify VacuumR int not null;
alter table rackinterfaces modify VacuumE int not null;
alter table rackinterfaces modify RFCA int not null;
alter table rackinterfaces modify He int not null;
alter table rackinterfaces modify N2 int not null;
alter table rackinterfaces modify CO2 int not null;
alter table rackinterfaces modify Ar int not null;

alter table constraints add required int;
alter table constraints modify name blob not null;
delete from constraints where name="";
alter table constraints modify trigger int not null;
alter table constraints modify required int not null;

alter table runs add peak_uplink_duration double not null default 0;
alter table runs add peak_downlink_duration double not null default 0;
alter table runs add peak_ethernet_duration double not null default 0;
alter table runs add peak_1553_duration double not null default 0;
alter table runs add peak_HRL_duration double not null default 0;

alter table runs add video_uplink double not null default 0;
alter table runs add video_downlink double not null default 0;
alter table runs add video_rate double not null default 0;

alter table runs add middeckmass double not null default 35;
alter table racks add attached bool not null default 0;
