Hierarchy columns should not be nullables
rgt columns of
issues table, as well as
projects table should be defined as
This could prevent users from running Redmine with corrupted data due to a wrong db migration by import/export.
Updated by Go MAEDA about 2 months ago
- File 0001-Add-not-null-constraints-to-lft-rgt-and-root_id-in-i.patch 0001-Add-not-null-constraints-to-lft-rgt-and-root_id-in-i.patch added
- File 0002-Add-not-null-constraints-to-lft-and-rgt-in-issues-ta.patch 0002-Add-not-null-constraints-to-lft-and-rgt-in-issues-ta.patch added
The attached patches add not null constraints to "root_id", "lft", and "rgt" columns in issues and projects tables.