Removing the ignored column project_pages_metadata.artifacts_archive_id

What does this MR do and why?

This is step 2 / 3 of removing the column: project_pages_metadata.artifacts_archive_id

Issue: #353365 (closed)

Database

Up

== 20220324110247 UntrackDeletionsOnCiJobArtifacts: migrating =================
-- execute("DROP TRIGGER IF EXISTS ci_job_artifacts_loose_fk_trigger ON ci_job_artifacts")
   -> 0.0009s
== 20220324110247 UntrackDeletionsOnCiJobArtifacts: migrated (0.0009s) ========

== 20220324180717 RemoveProjectPagesMetadataArtifactsArchiveIdColumn: migrating 
-- remove_column(:project_pages_metadata, :artifacts_archive_id)
   -> 0.0029s
== 20220324180717 RemoveProjectPagesMetadataArtifactsArchiveIdColumn: migrated (0.0030s) 

== 20220329175119 RemoveLeftoverCiJobArtifactDeletions: migrating =============
-- execute("DELETE FROM \"loose_foreign_keys_deleted_records\"\nWHERE\n(\"loose_foreign_keys_deleted_records\".\"partition\", \"loose_foreign_keys_deleted_records\".\"id\") IN (\n  SELECT \"loose_foreign_keys_deleted_records\".\"partition\", \"loose_foreign_keys_deleted_records\".\"id\"\n  FROM \"loose_foreign_keys_deleted_records\"\n  WHERE\n  \"loose_foreign_keys_deleted_records\".\"fully_qualified_table_name\" = 'public.ci_job_artifacts' AND\n  \"loose_foreign_keys_deleted_records\".\"status\" = 1\n  LIMIT 100\n)\n")
   -> 0.0013s
== 20220329175119 RemoveLeftoverCiJobArtifactDeletions: migrated (0.0013s) ====

Down

bin/rails db:migrate:down VERSION=20220329175119

== 20220329175119 RemoveLeftoverCiJobArtifactDeletions: reverting =============
== 20220329175119 RemoveLeftoverCiJobArtifactDeletions: reverted (0.0000s) ====

bin/rails db:migrate:down VERSION=20220324180717

== 20220324180717 RemoveProjectPagesMetadataArtifactsArchiveIdColumn: reverting 
-- column_exists?(:project_pages_metadata, :artifacts_archive_id)
   -> 0.0005s
-- add_column(:project_pages_metadata, :artifacts_archive_id, :bigint)
   -> 0.0009s
-- transaction_open?()
   -> 0.0000s
-- index_exists?(:project_pages_metadata, :artifacts_archive_id, {:name=>"index_project_pages_metadata_on_artifacts_archive_id", :algorithm=>:concurrently})
   -> 0.0011s
-- execute("SET statement_timeout TO 0")
   -> 0.0002s
-- add_index(:project_pages_metadata, :artifacts_archive_id, {:name=>"index_project_pages_metadata_on_artifacts_archive_id", :algorithm=>:concurrently})
   -> 0.0013s
-- execute("RESET statement_timeout")
   -> 0.0002s
== 20220324180717 RemoveProjectPagesMetadataArtifactsArchiveIdColumn: reverted (0.0080s) 

bin/rails db:migrate:down VERSION=20220324110247

== 20220324110247 UntrackDeletionsOnCiJobArtifacts: reverting =================
-- execute("CREATE TRIGGER ci_job_artifacts_loose_fk_trigger\nAFTER DELETE ON ci_job_artifacts REFERENCING OLD TABLE AS old_table\nFOR EACH STATEMENT\nEXECUTE FUNCTION insert_into_loose_foreign_keys_deleted_records();\n")
   -> 0.0007s
== 20220324110247 UntrackDeletionsOnCiJobArtifacts: reverted (0.0007s) ========

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

• I have evaluated the MR acceptance checklist for this MR.