Correct NOT NULL differences between production and structure.sql
In #211781, a number of schema inconsistencies were identified between the GitLab.com production database and the structure.sql
file.
One such problem is columns that are defined as NOT NULL
in one environment but not in another.
A summary can be found in the following (internal only) spreadsheet
This is pretty easily addressable if we have to remove the NOT NULL
, but way harder the other way around.
At the moment all columns we have identified are defined as NOT NULL
in production, but not in structure.sql
, which should be easy to fix.
We should make sure that the definitions in structure.sql
are indeed the preferred ones and remove the NOT NULL
constraints from the columns in production.
Edited by Yannis Roussos