bug 225221 "longdescs table needs a primary key"

[Matthew P. Barnson]

Three small words for why there's no primary key in longdescs:
"Blame Terry Weissman" :)

Bugzilla was his first learning experience in SQL... what was it, six years ago now?  Dude, I've been doing this a long time; I remember playing with Bugzilla when bugzilla.mozilla.org had less than 10,000 bugs...  Here was Terry's answer to me in 2000 asking a question about portability (from the old FAQ):

"I'm not a real SQL or database person. I just wanted to make a useful tool, and build it on top of free software. So, I picked MySQL, and learned SQL by staring at the MySQL manual and some code lying around here, and wrote Bugzilla."

So there's your answer for the database design.  Yes, it should be fixed.  But there's a definite historical reason for "common sense" database administration stuff being neglected in the creation of the tool for ya :)

-- 
Matthew P. Barnson
- - - -
Thought for the moment:
It will be generally found that those who sneer habitually at human
nature and affect to despise it, are among its worst and least pleasant
examples.
		-- Charles Dickens