Geo - Create new verification state table for Terraform::StateVersion

Problem

We need to split the verification details for the replicables using the same table to store the verification stat (4) into a separate tables. With these changes, the Geo::VerificationStateBackfillWorker that iterates over the table corresponding to the replicable to backfill the corresponding verification state table will also perform the cleanup of records when we change the selective sync scope to a new set of organizations.

Replicable Models using the same table to store the verification state:

• Model: Ci::PipelineArtifact
  • Immutable
  • Schema: gitlab_ci
  • Table ci_pipeline_artifacts
• Model: Packages::PackageFile
  • Immutable
  • Schema: gitlab_main
  • Table packages_package_files
  • Large and High-traffic table on GL.com
• Model: SnippetRepository
  • Mutable
  • Schema: gitlab_main
  • Table: snippet_repositories
• Model: Terraform::StateVersion
  • Immutable
  • Schema: gitlab_main
  • Table: terraform_state_versions

Proposal

1. Create the four verification state tables in regular schema migrations.
2. Backfill work to be done in - #515873 (closed)