Feature #7667

Hierarchy columns should not be nullables

Added by Etienne Massip over 10 years ago. Updated over 8 years ago.

Status:NewStart date:2011-02-21
Priority:NormalDue date:
Assignee:-% Done:

0%

Category:Database
Target version:Candidate for next major release
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.

Related issues

Related to Redmine - Defect #9164: Internal Error when opening Issues or Gantt Closed 2011-09-01

History

#1 Updated by Etienne Massip almost 10 years ago

  • Target version set to Candidate for next major release

#2 Updated by Daniel Felix over 8 years ago

Hi Etienne,

I just found this on the roadmap.

Any news on this issue? :-)

#3 Updated by Etienne Massip over 8 years ago

  • Tracker changed from Defect to Feature
  • Subject changed from Hierarchy columns should not be nullables. to Hierarchy columns should not be nullables

Still here

Also available in: Atom PDF