Project categories and data integrity

General discussion of Mantis.

Moderators: Developer, Contributor

Post Reply
mcain

Project categories and data integrity

Post by mcain »

A user of my local Mantis install pointed out something strange in the category filter. In the drop down there are categories that do not exist as categories for the project.

I looked at the mantis_bug_table and there is category as a string field not as a foreign key like project_id, reporter_id etc. I am guessing these categories did exist in the past, but had since been deleted.

2 questions:
-Is my understanding of this situation correct?
-Why is it done this way? For Performance? I may be a bit of a nazi about database design, but a strict foreign key link seems the way to go for me.
Post Reply