Customizing Bugzilla 4.0.2 Bug ID numbers
- by Marcus Polk
Is it possible to customize Bugzilla bug numbers and add a letter designator, to immediately know it came from Bugzilla?
My company is evaluating Bugzilla and has now added many new bugs. We also use 2 other bug databases. This wasn't my decision and I believe they were trying to incorporate better reporting, etc.
I read an answer here about "seeding" Bugzilla bug numbers, by setting the "AUTO_INCREMENT" field in the "bugs" table to a different value. I wish I would've thought about this sooner and found this board. Setting that value to start at 9000 or some extraordinary value would have ensured that we knew exactly which bugs came from Bugzilla.
However, would it be possible to change the field in the "bugs" table to accept letters, as well? Of course that would probably just mess up the whole auto incrementing of the numbers.
Any help or advice is greatly appreciated. Thank you.