Bugzilla Schema doc

[Nick.Barnes at pobox.com]

At 2010-05-28 11:21:09+0000, Nick.Barnes at pobox.com writes:
> At 2010-05-28 11:02:50+0000, Gervase Markham writes:
> > On 28/05/10 09:26, Nick.Barnes at pobox.com wrote:
> > > Please can I have a volunteer to take over the maintenance of the
> > > I've received a lot of praise for this resource over the years; I'm
> > > sure there's someone out there who wants to carry it on.  The fact all
> > > the underlying schema tables are generated through a MySQL interface
> > > from actual installations of every single Bugzilla version since 2.0
> > > makes it definitive, and the "show range of schema versions" feature
> > > is tremendously useful when upgrading custom Bugzillas or when porting
> > > third-party tools.
> > 
> > I utterly agree it's a great tool.
> > 
> > Does supporting it mean that you need an installation of every single 
> > Bugzilla version since 2.0, or does it read the schema data as a one-off 
> > and then store it itself?
> 
> It reads the data as a one-off and stores it as a pickle file.  I
> identify identical schemas, mark them up in the remarks, and discard
> the un-needed pickles.  I have all the pickles up to 3.4.something.

For more detail, and all the source code, see
<http://www.ravenbrook.com/project/p4dti/tool/cgi/bugzilla-schema/code.html>

Nick B