bug resolution and foreign keys

[Craig]

I need to change the bug resolution fields in our setup.

I noticed that "bugs.resolution" is a varchar and refers to 
"resolution.value".

Is there a reason why "bugs.resolution" cannot point to "resolution.id" 
and have a foreign field constraint?

Given that bugs.resolution points to resolution.value, what is the 
"best" way to change the the list of possible bug resolutions? I was 
going to just mark all of the current rows with "isactive = 0" and then 
just add all of the new rows.

Thoughts?