longdescs no pk?

Christopher Hicks chicks at chicks.net
Mon Nov 3 23:11:33 UTC 2003


(1) Why doesn't the longdesc table have a primary key?

(2) Would there be any harm in putting an autoincrement key or something
in there?  I can't think of any reason why it would, but my imagination is
currently unusually limited by the sensory overload of being at an
insurance conference at the Opryland.  I wish I was kidding.  :)

(3) Is there a preferred official solution to this?  It would seem like a
primary key across bug_id,who,bug_when would also work.  That's not as
'neat and clean' to store for my purposes, but if that's the official
answer I'll go with it.

I first noticed this when I was trying to hand edit some old comments
using Mysqltool.  (bad bad i know.)  But now I'm trying to track which
bugs have been billed and which haven't and a primary key, any primary
key, would make that a whole lot easier.

Any help on this would be appreciated.  I have't researched this as
thoroughly as I'd like because I'm stuck in a hotel without Internet.  
Ugh!  I hate modems.

-- 
</chris>

Writing about music is like dancing about architecture.




More information about the developers mailing list