287311 - Change old enum fields from varchars to integers with foreign keys

Status: NEW

(Bugzilla :: Database, enhancement)

Description

[Max Kanat-Alexander]

I moved the old "enum" fields to be varchars, because that happened to be the
easiest thing to do to get rid of enums.

Now, they need to be changed to be integers in the bugs table, which point to
the correct varchar value in a separate table.

This is a meta bug, we'll move the fields one at a time, each in a separate bug.

Comment 1

[Max Kanat-Alexander]

Oh, by the way, as these changes are being made, they should have no UI impact.
That is, they should be entirely architectural changes. Any UI changes can
happen later.

Comment 2

[Max Kanat-Alexander]

Ahhh, crap! There are no midairs on dep changes. :-( Adding all the deps again.
Sorry about that.

Comment 3

[Kevin Benton]

Please note that this re-normalization does have a penalty to reporting...  Not a big deal, but it is what it is...

Comment 5

[Kevin Benton]

It seems that removing bugs.keywords is the right way to go with this too.  I know that mattyt proposed that the column should be smaller, but I propose going a step further - remove the field and just use the bug_keyword_map table instead.  bugs.keywords just contains information that's duplicated in the map anyway.

Comment 6

[Kevin Benton]

Sorry all - wrong bug.  Just realized that 86545 is about buglist.cgi not removing the keywords column in buglist.cgi

Comment 7

[Kevin Benton]

I am unable to work this bug at this time due to other priorities.  Reassigning to default assignee.