longdescs no pk?

[Christopher Hicks]

On Tue, 4 Nov 2003, Bradley Baetz wrote:

> Theres a bug somewhere on comments being swtiched arround daylight
> saving, because the second 2:30am is 'earlier' than 3am. I'd prefer a PK
> of (bug#, comment#), since that makes it easy to get the current comment
> nyumbers, so we could display them on teh midair checkin list, in
> emails, and so on.

For a minute there I seriously thought I had missed a pre-existing field
for comment#.  Are you sure you want to start comment numbers over for
each bug?  The attachments table already uses an auto_increment primary
key for instance.  To add a field for comment# once would certainly be
possible, yet much more challenging than just:

	alter table longdescs add cid int(10) not null auto_increment primary key;

While I'm certainly willing to defer to "authoritative wisdom" and do this
the harder way I think a simple is cleaner and considered more holy from a
Database Purist perspective.

http://bugzilla.mozilla.org/show_bug.cgi?id=225221

I created a bug for this.  Would someone with sufficient power assign it 
to me?

-- 
</chris>

No, no, you're not thinking, you're just being logical.
-Niels Bohr, physicist (1885-1962)