Feature #7667: Hierarchy columns should not be nullables - Redmine

Actions

Feature #7667

open

Status:

New

Priority:

Normal

Assignee:

Category:

Database

Target version:

Start date:

2011-02-21

Due date:

% Done:

Estimated time:

Resolution:

Description

The root_id, lft, rgt columns of issues table, as well as lft and rgt of projects table should be defined as NOT NULL.

This could prevent users from running Redmine with corrupted data due to a wrong db migration by import/export.

Files

Download all files

0002-Add-not-null-constraints-to-lft-and-rgt-in-issues-ta.patch (1.15 KB) 0002-Add-not-null-constraints-to-lft-and-rgt-in-issues-ta.patch		Go MAEDA, 2024-01-02 06:22
0001-Add-not-null-constraints-to-lft-rgt-and-root_id-in-i.patch (1.19 KB) 0001-Add-not-null-constraints-to-lft-rgt-and-root_id-in-i.patch		Go MAEDA, 2024-01-02 06:22

Related issues

Actions

Also available in: Atom PDF