Bug ID domain?

[Jason Pyeron]

On Thu, 24 Apr 2003, Sean McAfee wrote:

>Sure, that'd be the most straightforward way to handle the issue.
>However, the tables I've already proposed have swollen the number of
>tables in the Bugzilla schema by almost 50%.  I'd be happier if those
>existing tables could be leveraged to hold default data as well, rather
>than introduce five new ones.  (I admit that this is more of an aesthetic
>thing for me.)

I personally don't worry about the number of tables AS LONG AS the names are 
well formatted and obvious. i.e. cf_*, cf_type*, etc.

To address the 'hack' issue. The domain of the bugids is db driven. It 
cannot be assumed that 0 will always be unused. Further to go negative 
would provide future issues. This is true if the column def is changed to 
unsigned in the future.

If you are worried about table bloat, then make use of the comment feature 
at creation time for tables.

Jason Pyeron

-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-                                                               -
- Jason Pyeron                   http://www.pyerotechnics.com   -
- Owner & Lead                  Pyerotechnics Development, Inc. -
- +1 410 808 6646 (c)           500 West University Parkway #1S -
- +1 410 467 2266 (f)           Baltimore, Maryland  21210-3253 -
-                                                               -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

This message is for the designated recipient only and may contain 
privileged, proprietary, or otherwise private information. If you
have received it in error, purge the message from your system and 
notify the sender immediately.  Any other use of the email by you 
is prohibited.