Adding Peter's ALTER

ALTER TABLE offices ADD active TINYINT(1) NOT NULL DEFAULT '1' AFTER term_end;