0010593: Wrong category used when old one deleted.

Notes
(0022482) vboctor (administrator) 2009-07-12 17:16	This is an issue with all our lookup values. I wonder if we should ban deletion of entities that are referenced by issues. This is to force re-assigning these issues to alternate categories/versions/users, etc. If we do that, then issue goes away. This will also keep our database more consistent.

(0022483) vboctor (administrator) 2009-07-12 17:16	Reminder sent to: jreese @jreese, what do you think?

(0026065) anthropic (reporter) 2010-07-13 01:26 edited on: 2010-07-13 01:27	I think there should be 3 changes after I had to delete a project and all the categories for the project were lost and I now have 1000 issues without a category. 1. A link table between category and project so if the project is deleted the category can remain, also so there is less duplication and more consistency in the database for category names (I had a colleague add the same category in four projects with three different spellings which annoyed me greatly!). 2. A way to re-link a category to another project, perhaps a category admin page. and 3. A way to search for orphaned issues that have category or other fields that are no longer valid.

Relationships