alter table racks add attached bool not null default 0;

update racks set attached=1 where acronym="EXPRESS Pallet 1";
update racks set attached=1 where acronym="EXPRESS Pallet 2";
update racks set attached=1 where acronym="EXPRESS Pallet 3";
update racks set attached=1 where acronym="AMS (Truss Site)";
update racks set attached=1 where acronym="SEDA (JEM-EF 9)";
update racks set attached=1 where acronym="LCDE (JEM-EF 8)";
update racks set attached=1 where acronym="MAXI (JEM-EF 3)";
update racks set attached=1 where acronym="SMILES (JEM-EF 3)";
update racks set attached=1 where acronym="PET (JEM-EF 5)";
update racks set attached=1 where acronym="OSS-4 (JEM-EF 4)";
update racks set attached=1 where acronym="LTMPF (JEM-EF 2)";
update racks set attached=1 where acronym="OSS-6 (JEM-EF 6)";
update racks set attached=1 where acronym="PARCS (JEM-EF 11)";
update racks set attached=1 where acronym="Columbus EPF DX";
update racks set attached=1 where acronym="Columbus EPF DZ";
update racks set attached=1 where acronym="Columbus EPF OX";
update racks set attached=1 where acronym="Columbus EPF OZ";
