ALTER TABLE childConfigPerBuildTable
  ADD COLUMN last_updated TIMESTAMP DEFAULT CURRENT_TIMESTAMP
    ON UPDATE CURRENT_TIMESTAMP,
  ADD COLUMN status ENUM('fail','pass','inflight','missing','aborted')
    NOT NULL DEFAULT 'inflight',
  ADD COLUMN final BOOL NOT NULL DEFAULT false,
  ADD INDEX last_updated_index(last_updated);

INSERT INTO schemaVersionTable (schemaVersion, scriptName) VALUES
  (16, '00016_alter_childconfigperbuild_table_add_status.sql');