Skip to content

Use the EE schema as the SSOT

Andreas Brandl requested to merge ab-use-ee-schema into master

What does this MR do?

This MR copies the db/schema.rb file from EE https://gitlab.com/gitlab-org/gitlab-ee/commit/40ea0edbdd6 and uses that as the source of truth going forward. This makes sure we have a consistent schema across the CE/EE codebase since migrations are only being shipped through CE.

Apart from column ordering and the "datetime with timezone" difference, we observe the following issues/differences:

  1. FK names explicitly set on either CE or EE, never conflicting
  2. Use of explicit id: serial to use integer sequences (only examples where EE forces use of integer sequence) on ci_pipeline_schedule_variables

Relates to: https://gitlab.com/gitlab-org/gitlab-ee/issues/12434

Edited by Andreas Brandl

Merge request reports