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