P4DTI issue job000958

TitleBugzilla schema doc is out of date
Statusclosed
Priorityessential
Assigned userNick Barnes
OrganizationRavenbrook
DescriptionThe P4DTI design documentation includes a document [1] describing the Bugzilla database schema. This document is considerably out of date: among other things it doesn't describe the new groups system in bugzilla 2.17.x, or the tables controlling flags and charts. This needs to be up-to-date and accurate for us to rewrite the P4DTI Bugzilla interface based upon it.
AnalysisNew groups system; new per-product group control system; new flags replace attachment statuses; new time estimation system; new charting system (the series_* tables).
How foundinspection
Evidence[1] <http://www.ravenbrook.com/project/p4dti/version/2.1/design/bugzilla-schema/>
Observed in2.1.2
Introduced in2.0.0
Created byNick Barnes
Created on2004-07-15 16:19:37
Last modified byNick Barnes
Last modified on2004-07-15 16:22:22
History2004-07-15 NB Created.

Fixes

Change Effect Date User Description
105973 closed 2004-07-14 10:54:19 Nick Barnes New database schema doc, including Bugzilla 2.16.6 and 2.18rc1.
105972 open 2004-07-14 10:53:21 Nick Barnes Add 2.16.6 and 2.18rc1 to schema doc.
104794 open 2004-07-07 15:26:00 Nick Barnes Publish new schema, adding column flags.is_active.
104793 open 2004-07-07 15:25:16 Nick Barnes Add a column to the 'flags' table.
103809 open 2004-07-02 14:10:54 Nick Barnes New schema including "2.18rc0" (i.e. CVS tip today).
103807 open 2004-07-02 14:09:03 Nick Barnes Renewed database dumps and fixed schema remarks for CVS tip.
95244 open 2004-05-18 15:09:52 Nick Barnes Fix XHTML errors.
95243 open 2004-05-18 15:09:24 Nick Barnes Fix some XHTML errors in the generated doc.
93825 open 2004-05-11 12:46:08 Nick Barnes Schema doc with improved display of modified enum fields.
93824 open 2004-05-11 12:45:27 Nick Barnes Improve handling of modified enum fields.
91754 open 2004-04-30 12:16:39 Nick Barnes Updated description of Bugzilla time series system.
91753 open 2004-04-30 12:15:45 Nick Barnes Correct description of time series system in the Bugzilla schema doc.
85273 open 2004-03-26 17:07:16 Nick Barnes Complete (?) Bugzilla schema description.
85272 open 2004-03-26 17:06:54 Nick Barnes Typo fix in schema remarks.
85271 open 2004-03-26 17:05:47 Nick Barnes Add the time series system and the time tracking system.
85086 open 2004-03-25 16:43:56 Nick Barnes Add documentation for the new 'series' charting system.
85061 open 2004-03-25 13:38:55 Nick Barnes Bugzilla schema now details the flags system.
85060 open 2004-03-25 13:37:57 Nick Barnes Remove redundant warning.
85059 open 2004-03-25 13:35:24 Nick Barnes Schema remarks for the flags system.
84039 open 2004-03-19 16:57:26 Nick Barnes Up-to-date Bugzilla schema documentation.
84038 open 2004-03-19 16:56:55 Nick Barnes Add change comment.
84036 open 2004-03-19 16:53:34 Nick Barnes Fix table appearance and add 2.17.7 dump file.
84035 open 2004-03-19 16:48:59 Nick Barnes Better Bugzilla schema doc for 2.17.x.