Skip to content

Convert design_user_mentions.note_id to Bigint for self managed

Prabakaran Murugesan requested to merge 417402-swap-integer-and-bigint-for-design_user_mentions-in-self-managed into master

What does this MR do and why?

This MR swaps the design_user_mentions.note_id and design_user_mentions.note_id_convert_to_bigint columns for self-managed instances. This was already done for GitLab.com with Swap design_user_mentions.note_id to bigint (!115285 - merged).

Migrating int PKs to bigint process is outlined here.

The timeline for GitLab.com was the following:

Since we made the decision to commit schema changes to structure.sql for the above MRs, we now need to take into account the state of the schema from which the self-managed instance was created.

How to set up and validate locally

Numbered steps to set up and validate the change are strongly suggested.

MR acceptance checklist

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

Related to #417402 (closed)

Edited by Prabakaran Murugesan

Merge request reports