Bug ID domain?

[Bradley Baetz]

On Thu, Apr 24, 2003 at 11:44:19PM +0100, Gervase Markham wrote:
> >What is the domain of possible values for bug IDs?  I get the idea that IDs
> >are positive integers, but is this codified somewhere?
> 
> Well, currently they are auto-allocated by the database, starting at 1 
> and going upwards, so it's codified like that. The domain is 1 -> 2^31 
> at least.

and we could make it unsigned and go to 2^32.
> 
> >...I'd like to use a special bug_id to store the default value for a given
> >field_id.  NULL is out, unfortunately, because I need that primary key.
> >Would using a number like 0 or -1 be safe?

Why not store the default as a column in the table which defines all of
the fields? thats the sensible place for it.

Bradley