Ravenbrook / Projects / Perforce Defect Tracking Integration / Master Product Sources / Design

Perforce Defect Tracking Integration Project


Bugzilla database schema

Nick Barnes, Ravenbrook Limited, 2000-11-14

1. Introduction

The automatically-generated Bugzilla schema documentation has moved to the main project tools directory. This document remains as for redirection and to hold some information which was not appropriate for that new format.

2. Bugzilla History

Bugzilla releases

This table gives the dates of all the Bugzilla releases since 2.0, and of each P4DTI release which changed the set of supported Bugzilla releases, and shows the history of P4DTI support for each release.

  P4DTI Releases  
Date Release First Deprecated Last Notes
1998-09-19 2.0 - - - Never supported by the P4DTI. Not described in this document.
1999-02-10 2.2 - - - Never supported by the P4DTI. Not described in this document.
1999-04-30 2.4 - - - Never supported by the P4DTI. Not described in this document.
1999-08-30 2.6 - - - Never supported by the P4DTI. Not described in this document.
1999-11-19 2.8 - - - Never supported by the P4DTI. Not described in this document.
2000-05-09 2.10 1.0.0 1.5.0 1.5.3 The first Bugzilla release supported by the P4DTI.
2001-02-19 P4DTI release 1.0.0, supporting Bugzilla 2.10.
2001-04-27 2.12 1.1.2 1.5.0 1.5.3  
2001-07-16 P4DTI release 1.1.2, supporting Bugzilla 2.10 and 2.12.
2001-08-29 2.14 1.2.0 1.5.0 1.5.3  
2001-10-18 P4DTI release 1.2.0, supporting Bugzilla 2.10, 2.12, and 2.14.
2002-01-05 2.14.1 1.4.0 1.5.0 1.5.3 A security patch release.
2002-02-04 P4DTI release 1.4.0, supporting Bugzilla 2.10, 2.12, 2.14, and 2.14.1.
2002-05-10 2.16rc1 - - - A release candidate. Never supported by the P4DTI.
2002-06-07 2.16rc2 - - - A release candidate. Never supported by the P4DTI.
2002-06-07 2.14.2 - - - A security patch release. Never formally supported by the P4DTI.
2002-07-28 2.16 - - - Never formally supported by the P4DTI.
2002-07-28 2.14.3 - - - A security patch release. Never formally supported by the P4DTI.
2002-09-30 2.16.1 1.5.0 2.0.0 2.1.2 A security patch release.
2002-09-30 2.14.4 1.5.0 2.0.0 2.1.2 A security patch release. The first Bugzilla-on-Windows release supported by the P4DTI.
2002-11-01 P4DTI release 1.5.0, supporting Bugzilla 2.14.4 and 2.16.1. Bugzilla 2.14.4 supported on Windows. Bugzilla 2.10, 2.12, 2.14, 2.14.1 deprecated. Patches also supplied for Bugzilla 2.14.2, 2.14.3, and 2.16.
2002-11-25 2.17.1 - - - A development release. Never supported by the P4DTI.
2003-01-02 2.16.2 2.0.0 2.0.0 2.1.2 A security patch release.
2003-01-02 2.14.5 2.0.0 2.2.0 2.2.2 A security patch release.
2003-01-02 2.17.3 - - - A development release. Never supported by the P4DTI. There was no release 2.17.2.
2003-04-25 2.16.3 2.0.0 2.1.0 2.1.2 A security patch release.
2003-04-25 2.17.4 - - - A development release. Never supported by the P4DTI.
2003-06-02 P4DTI release 2.0.0, supporting Bugzilla 2.14.5 and 2.16.3. Bugzilla 2.14.5 supported on Windows. Bugzilla 2.14.4, 2.16.1, and 2.16.2 deprecated.
2003-11-03 2.17.5 - - - A development release. Never supported by the P4DTI.
2003-11-03 2.16.4 2.1.0 2.2.0 2.2.2  
2003-11-10 2.17.6 - - - A development release. Never supported by the P4DTI.
2003-12-13 P4DTI release 2.1.0, supporting Bugzilla 2.14.5 and 2.16.4. Bugzilla 2.14.5 supported on Windows. Bugzilla 2.14.4, 2.16.1, 2.16.2, and 2.16.3 deprecated.
2004-03-03 2.16.5 2.2.0 2.2.0 2.2.2  
2004-03-03 2.17.7 - - - A development release. Never supported by the P4DTI.
2004-07-10 2.16.6 2.2.0 2.2.1 2.2.2  
2004-07-10 2.18rc1 - - - A release candidate. Never supported by the P4DTI.
2004-07-28 2.18rc2 - - - A release candidate. Never supported by the P4DTI.
2004-08-02 P4DTI release 2.2.0, supporting Bugzilla 2.16.6 and intended to support 2.18. Only Bugzilla 2.18 on Windows. Bugzilla 2.14.5, 2.16.4, and 2.16.5 deprecated.
2004-10-24 2.16.7 2.2.1 2.2.1 2.2.2  
2004-10-24 2.18rc3 - - - A release candidate. Never supported by the P4DTI.
2004-10-24 2.19.1 - - - A development release. Never supported by the P4DTI.
2005-01-15 2.16.8 2.2.1 2.3.0 2.3.2  
2005-01-15 2.18 2.2.1 2.3.0 2.3.2  
2005-01-15 2.19.2 - - - A development release. Never supported by the P4DTI.
2005-02-02 P4DTI release 2.2.1, supporting Bugzilla 2.16.8 and 2.18. Only Bugzilla 2.18 on Windows. Bugzilla 2.14.5, 2.16.4, 2.16.5, 2.16.6, and 2.16.7 deprecated.
2005-05-12 2.16.9 - - - A security patch release. Never supported by the P4DTI.
2005-05-12 2.18.1 - - - A security patch release. Never supported by the P4DTI.
2005-05-12 2.19.3 - - - A development release. Never supported by the P4DTI.
2005-05-19 2.16.10 - - - A security patch release. Never supported by the P4DTI.
2005-07-08 2.18.2 - - - A security patch release. Never supported by the P4DTI.
2005-07-08 2.20rc1 - - - A release candidate. Never supported by the P4DTI.
2005-07-09 2.18.3 - - - A security patch release. Never supported by the P4DTI.
2005-08-08 2.20rc2 - - - A release candidate. Never supported by the P4DTI.
2005-10-01 2.18.4 2.3.0 2.3.3 2.3.5 A security patch release.
2005-10-01 2.20 2.3.0 2.3.3 2.3.5  
2005-10-01 2.21.1 - - - A development release. Never supported by the P4DTI.
2005-10-21 P4DTI release 2.3.0, supporting Bugzilla 2.18.4 and 2.20. Bugzilla 2.16.8 and 2.18 deprecated.
2006-02-21 2.16.11 - - - A security patch release. Never supported by the P4DTI.
2006-02-21 2.18.5 2.3.3 2.3.3 2.3.5 A security patch release
2006-02-21 2.20.1 - - - A security patch release. Never supported by the P4DTI.
2006-02-21 2.22rc1 - - - A release candidate. Never supported by the P4DTI.
2006-04-23 2.20.2 2.3.3 2.4.0 - A security patch release.
2006-04-23 2.22 2.3.3 2.4.0 -
2006-04-23 2.23.1 - - - A development release. Never supported by the P4DTI.
2006-06-14 P4DTI release 2.3.3, supporting Bugzilla 2.20.2 and 2.22. Bugzilla 2.18.4, 2.18.5, and 2.20 deprecated.
2006-07-09 2.23.2 - - - A development release. Never supported by the P4DTI.
2006-10-15 2.18.6 - - - A security patch release. Never supported by the P4DTI.
2006-10-15 2.20.3 - - - A security patch release. Never supported by the P4DTI.
2006-10-15 2.22.1 - - - A security patch release. Never supported by the P4DTI.
2006-10-15 2.23.3 - - - A development release. Never supported by the P4DTI.
2007-02-02 2.20.4 2.4.0 2.4.0 - A security patch release.
2007-02-02 2.22.2 2.4.0 - - A security patch release.
2007-02-02 2.23.4 - - - A development release. Never supported by the P4DTI.
2007-02-26 3.0rc1 - - - A release candidate. Never supported by the P4DTI.
2007-05-09 3.0 2.4.0 - -
2007-06-08 P4DTI release 2.4.0, supporting Bugzilla 2.22.2 and 3.0. Bugzilla 2.20.2, 2.20.4, and 2.22 deprecated.
2007-08-23 2.20.5 - - - A security patch release.
2007-08-23 2.22.3 - - - A security patch release.
2007-08-23 3.0.1 - - - A security patch release.
2007-08-23 3.1.1 - - - A development release.
2007-09-19 3.0.2 - - - A security patch release.
2007-09-19 3.1.2 - - - A development release.
2008-01-09 3.0.3 - - - A security patch release.
2008-02-02 3.1.3 - - - A development release.
2008-05-04 2.20.6 - - - A security patch release.
2008-05-04 2.22.4 - - - A security patch release.
2008-05-04 3.0.4 - - - A security patch release.
2008-05-04 3.1.4 - - - A development release.
2008-08-12 2.22.5 - - - A security patch release.
2008-08-12 3.0.5 - - - A security patch release.
2008-08-12 3.2rc1 - - - A release candidate. Never supported by the P4DTI.
2008-11-07 2.20.7 - - - A security patch release.
2008-11-07 2.22.6 - - - A security patch release.
2008-11-07 3.0.6 - - - A security patch release.
2008-11-07 3.2rc2 - - - A release candidate. Never supported by the P4DTI.
2008-11-30 3.2 - - -
2009-01-06 3.3.1 - - - A development release. Never supported by the P4DTI.
2009-02-03 2.22.7 - - - A security patch release.
2009-02-03 3.0.7 - - - A security patch release.
2009-02-03 3.2.1 - - - A security patch release.
2009-02-03 3.3.2 - - - A development release. Never supported by the P4DTI.
2009-02-03 3.0.8 - - - A security patch release.
2009-02-03 3.2.2 - - - A security patch release.
2009-02-03 3.3.3 - - - A development release. Never supported by the P4DTI.

The P4DTI currently supports Bugzilla 2.22.2 and 3.0. Support for 2.20.2, 2.20.4, and 2.22 is deprecated. During the lifetime of this document it has also had some form of support for various Bugzilla releases from 2.10 onwards, as shown in the above table.

A. References

B. Document History

2000-11-14 NB Created.
2001-03-02 RB Transferred copyright to Perforce under their license.
2001-04-06 NB Added sample queries.
2001-09-12 NB Updated to reflect schema updates in Bugzilla 2.12 and 2.14
2002-01-31 NB Added notes on Bugzilla 2.14.1.
2002-05-31 NB Updated for Bugzilla 2.16 (based on 2.16rc1).
2002-09-26 NB Updated for Bugzilla 2.16/2.14.2/2.14.3.
2002-10-04 NB Added notes on Bugzilla 2.14.4 and 2.16.1, and on identical schemas.
2003-05-14 NB Added extensive notes on schema changes, in section 2.
2003-06-06 NB Added table of Bugzilla releases showing release date and support status.
2003-06-06 NB Added notes on schema changes in 2.17.x.
2003-06-13 NB Added first cut at description of new Bugzilla tables.
2003-06-27 NB Added more on recent schema changes. Colour-coded all schema changes.
2003-07-09 NB Completely changed the way this document is produced. The schema tables themselves are now created and coloured automatically by querying MySQL.
2003-11-04 NB Add Bugzilla 2.16.4 and 2.17.5.
2003-11-10 NB Add Bugzilla 2.17.6.
2004-03-19 NB Add Bugzilla 2.17.7; improve documentation of the groups system; improve automated schema change descriptions.
2004-03-26 NB Add documentation of the flags system, the time series system, and the time tracking system.
2004-04-30 NB Correct some documentation of the time series system based on feedback from the author.
2004-07-14 NB Add 2.16.6 and 2.18rc1.
2004-07-28 NB Add 2.18rc2.
2004-11-11 NB Add 2.16.7, 2.18rc3, 2.19.1. Change document-generation code to improve colouring, link consistency, control, and robustness.
2004-11-15 NB Gutted this document as the meat has moved.
2005-01-18 NB Updated to reflect recent Bugzilla releases.
2005-09-06 NB Updated to reflect recent Bugzilla releases.
2007-06-01 NB Updated to reflect recent Bugzilla releases and support plans.

This document is copyright © 2001-2004 Perforce Software, Inc. All rights reserved.

Redistribution and use of this document in any form, with or without modification, is permitted provided that redistributions of this document retain the above copyright notice, this condition and the following disclaimer.

This document is provided by the copyright holders and contributors "as is" and any express or implied warranties, including, but not limited to, the implied warranties of merchantability and fitness for a particular purpose are disclaimed. In no event shall the copyright holders and contributors be liable for any direct, indirect, incidental, special, exemplary, or consequential damages (including, but not limited to, procurement of substitute goods or services; loss of use, data, or profits; or business interruption) however caused and on any theory of liability, whether in contract, strict liability, or tort (including negligence or otherwise) arising in any way out of the use of this document, even if advised of the possibility of such damage.

Generated by //info.ravenbrook.com/project/p4dti/version/2.2/design/bugzilla-schema/make_schema_doc.py#3
Using remarks from //info.ravenbrook.com/project/p4dti/version/2.2/design/bugzilla-schema/schema_remarks.py#6

Ravenbrook / Projects / Perforce Defect Tracking Integration / Master Product Sources / Design