Skip to content

Remove `state_changed_at_pipeline_id` column from `vulnerability_state_transitions` table

As part of this #391402 (closed), we introduced a new column state_changed_at_pipeline_id in vulnerability_state_transitions table (!112403 (merged)). Then we decided #393597 (comment 1300638494), the pipeline info is not needed any more or can be removed. Currently there is no data in this column, so safe to remove.

Implementation plan:

  1. %17.4 ignore vulnerability_statistics.state_changed_at_pipeline_id column.
  2. %17.5 remove vulnerability_statistics.state_changed_at_pipeline_id column.
  3. %17.6 remove ignore rule for vulnerability_statistics.state_changed_at_pipeline_id column.
Edited by Adam Cohen