text: -- +migrate Up
  
  ALTER TABLE builds ADD COLUMN build_signed   BOOLEAN;
  ALTER TABLE builds ADD COLUMN build_verified BOOLEAN;
  
  UPDATE builds SET build_signed   = 0;
  UPDATE builds SET build_verified = 0;
  
  CREATE INDEX ix_build_status_running ON builds (build_status)
    WHERE build_status IN ('pending', 'running');
  
  -- +migrate Down
  
  ALTER TABLE builds DROP COLUMN build_signed;
  ALTER TABLE builds DROP COLUMN build_verified;
  DROP INDEX ix_build_status_running;
  