Skip to content

Remove column default

Bishwa Hang Rai requested to merge 444338-remove-default-org-id into master

What does this MR do and why?

The code changes the default value of the organization_id column in the subscription_add_on_purchases table from 1 to NULL.

Previous MR to add the organization_id: Add organization_id column (!154406 - merged)

[ASK]: The migration in this MR to change default value is post deployment migration. I hope this is enough to make sure that the both migrations to add organization_id with default 1, added in previous MR, and the migration to change the default to null added in this MR, will run without problem in self-managed instances context, when %17.1 is released?

Database

There are 0 rows for groups without organization_id based on simple Postgres.ai check:

select * from namespaces where type = 'Group' and organization_id IS NULL;

Link: https://console.postgres.ai/gitlab/gitlab-production-main/sessions/28936/commands/90195

MR acceptance checklist

Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

How to set up and validate locally

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

Related to #444338

Edited by Bishwa Hang Rai

Merge request reports