Remove pipeline_id column from requirements_management_test_reports
What does this MR do?
Removes pipeline_id
from requirements_management_test_reports
. We realized that it was a mistake to add this column.
It is ignored since last release.
related to #225154 (closed)
Migration output
UP
== 20200807143901 RemovePipelineIdFromTestReports: migrating ==================
-- remove_column(:requirements_management_test_reports, :pipeline_id, :integer)
-> 0.0033s
== 20200807143901 RemovePipelineIdFromTestReports: migrated (0.0033s) =========
DOWN
== 20200810191256 RemovePipelineIdFromTestReports: reverting ==================
-- add_column(:requirements_management_test_reports, :pipeline_id, :integer)
-> 0.0018s
-- add_foreign_key(:requirements_management_test_reports, :ci_pipelines, {:column=>:pipeline_id, :on_delete=>:nullify})
-> 0.0032s
== 20200810191256 RemovePipelineIdFromTestReports: reverted (0.0111s) =========
Table size:
EXPLAIN SELECT id FROM requirements_management_test_reports;
Index Only Scan using requirements_management_test_reports_pkey on public.requirements_management_test_reports (cost=0.14..6.64 rows=233 width=8) (actual time=1.186..1.211 rows=233 loops=1)
Edited by Toon Claes