Login
[x]
Log in using an account from:
Fedora Account System
Red Hat Associate
Red Hat Customer
Or login using a Red Hat Bugzilla account
Forgot Password
Login:
Hide Forgot
Create an Account
Red Hat Bugzilla – Attachment 291818 Details for
Bug 420611
3.41 Update database code in Bugzilla 3.0 to work with data from Red Hat 2.18 Bugzilla
[?]
New
Simple Search
Advanced Search
My Links
Browse
Requests
Reports
Current State
Search
Tabular reports
Graphical reports
Duplicates
Other Reports
User Changes
Plotly Reports
Bug Status
Bug Severity
Non-Defaults
|
Product Dashboard
Help
Page Help!
Bug Writing Guidelines
What's new
Browser Support Policy
5.0.4.rh83 Release notes
FAQ
Guides index
User guide
Web Services
Contact
Legal
This site requires JavaScript to be enabled to function correctly, please enable it.
db-scheam-diff between rh_bz_2.18 and bz3
db-schema-diff.html (text/html), 155.43 KB, created by
Tony Fu
on 2008-01-16 05:38:11 UTC
(
hide
)
Description:
db-scheam-diff between rh_bz_2.18 and bz3
Filename:
MIME Type:
Creator:
Tony Fu
Created:
2008-01-16 05:38:11 UTC
Size:
155.43 KB
patch
obsolete
><html> ><body> ><table border='1'> ><tr> > <td bgcolor='#FFFF66'>Table/Field exists in bugzilla_3 but not in bugzilla_2_18</td> ></tr> ><tr> > <td bgcolor='#9966FF'>Table/Field exists in bugzilla_2_18 but not in bugzilla_3</td> ></tr> ><tr> > <td bgcolor='#FF0033'>New Field in bugzilla_3 that is set to NOT NULL</td> ></tr> ><tr> > <td bgcolor='#33CC66'>Format 2.18/3 => Similar Fields Between Bugzilla_2_18 and Bugzilla_3 but have different attributes</td> ></tr> ></table> ><br/><br/><br/> > <table border='1' width='75%' bgcolor='#FFFF66'> > <tr> > <th>NAME</th> > <td colspan="5">attach_data</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">!! table found in bugzilla_3 but not in bugzilla_2_18 !!</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr bgcolor='#FFFF66'> > <td>id</td> > <td>MEDIUMINT</td> > <td> </td> > <td bgcolor='#FF0033'><b>NO</b></td> > <td>PRI</td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > <tr bgcolor='#FFFF66'> > <td>thedata</td> > <td>LONGBLOB</td> > <td> </td> > <td bgcolor='#FF0033'><b>NO</b></td> > <td> </td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%'> > <tr> > <th>NAME</th> > <td colspan="5">attachments</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">Users can upload attachments to bugs. An attachment can be marked as a patch. Attachments are stored in the attachments table</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr> > <td>attach_id</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td>PRI</td> > <td>a unique ID</td> > </tr> > <tr> > <td>bug_id</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td>MUL</td> > <td>the bug to which this is attached (foreign key bugs.bug_id)</td> > </tr> > <tr> > <td>creation_ts</td> > <td>DATETIME</td> > <td> </td> > <td>NO</td> > <td>MUL</td> > <td>the creation time</td> > </tr> > <tr bgcolor='#FFFF66'> > <td>modification_time</td> > <td>DATETIME</td> > <td> </td> > <td>YES</td> > <td>MUL</td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > <tr> > <td>description</td> > <td>MEDIUMTEXT</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>a description of the attachment</td> > </tr> > <tr> > <td>mimetype</td> > <td>MEDIUMTEXT</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>the MIME type of the attachment</td> > </tr> > <tr> > <td>ispatch</td> > <td>TINYINT</td> > <td> </td> > <td>YES</td> > <td> </td> > <td>non-zero if this attachment is a patch file</td> > </tr> > <tr> > <td>filename</td> > <td>VARCHAR</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>the filename of the attachment</td> > </tr> > <tr> > <td>submitter_id</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td>MUL</td> > <td>the userid of the attachment (foreign key profiles.userid)</td> > </tr> > <tr> > <td>isobsolete</td> > <td>TINYINT</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>Non-zero if this attachment is marked as</td> > </tr> > <tr> > <td>isprivate</td> > <td>TINYINT</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>Non-zero if this attachment is private</td> > </tr> > <tr bgcolor='#FFFF66'> > <td>isurl</td> > <td>TINYINT</td> > <td> </td> > <td>YES</td> > <td> </td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > <tr> > <td>it_id</td> > <td>TINYINT</td> > <td> </td> > <td>YES</td> > <td> </td> > <td>the id of an attachment in IssueTracker which is a separate system, it allows a bug report to show Bugzillla attachments and IssueTracker attachments in the same list</td> > </tr> > <tr bgcolor='#9966FF'> > <td>thedata</td> > <td>longblob</td> > <td></td> > <td>NO</td> > <td></td> > <td>!! field in bugzilla_2.18 but not in bugzilla_3 !!</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%'> > <tr> > <th>NAME</th> > <td colspan="5">bug_group_map</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">Which bugs are in which groups.</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr> > <td>bug_id</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td>PRI</td> > <td>The id of a bug that belongs to some group (foreign key bugs.bug_id)</td> > </tr> > <tr> > <td>group_id</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td>PRI</td> > <td>The group id (foreign key groups.id)</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%'> > <tr> > <th>NAME</th> > <td colspan="5">bug_severity</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">The severity values of bugs</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr> > <td>id</td> > <td>SMALLINT</td> > <td> </td> > <td>NO</td> > <td>PRI</td> > <td>a unique ID</td> > </tr> > <tr> > <td>value</td> > <td>VARCHAR</td> > <td> </td> > <td>NO</td> > <td>UNI</td> > <td>A possible value of the field</td> > </tr> > <tr bgcolor='#FFFF66'> > <td>sortkey</td> > <td>SMALLINT</td> > <td> </td> > <td>YES</td> > <td>MUL</td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > <tr bgcolor='#FFFF66'> > <td>isactive</td> > <td>TINYINT</td> > <td>1</td> > <td>YES</td> > <td> </td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%'> > <tr> > <th>NAME</th> > <td colspan="5">bug_status</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">The status values of bugs</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr> > <td>id</td> > <td>SMALLINT</td> > <td> </td> > <td>NO</td> > <td>PRI</td> > <td>a unique ID</td> > </tr> > <tr> > <td>value</td> > <td>VARCHAR</td> > <td> </td> > <td>NO</td> > <td>UNI</td> > <td>A possible value of the field</td> > </tr> > <tr> > <td>sortkey</td> > <td>SMALLINT</td> > <td> </td> > <td>NO</td> > <td bgcolor='#33CC66'>/MUL</td> > <td>A number used to determine the order in which values are shown</td> > </tr> > <tr> > <td>isactive</td> > <td>TINYINT</td> > <td>1</td> > <td>NO</td> > <td> </td> > <td>1 if this value is available in the user interface 0 otherwise</td> > </tr> > <tr> > <td>is_open</td> > <td>TINYINT</td> > <td>1</td> > <td>NO</td> > <td> </td> > <td>if the bug status is an open state</td> > </tr> > <tr> > <td>description</td> > <td>MEDIUMTEXT</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>bug status description</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%'> > <tr> > <th>NAME</th> > <td colspan="5">bugs</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">The bugs themselves.</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr> > <td>bug_id</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td>PRI</td> > <td>bug ID</td> > </tr> > <tr> > <td>assigned_to</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td>MUL</td> > <td>The current owner of the bug (foreign key profiles.userid)</td> > </tr> > <tr> > <td>bug_file_loc</td> > <td bgcolor='#33CC66'>text/MEDIUMTEXT</td> > <td> </td> > <td>YES</td> > <td> </td> > <td>A URL which points to more information about the bug</td> > </tr> > <tr> > <td>bug_severity</td> > <td>VARCHAR</td> > <td> </td> > <td>NO</td> > <td>MUL</td> > <td>the severity value of a bug. foreign key bug_severity.value</td> > </tr> > <tr> > <td>bug_status</td> > <td>VARCHAR</td> > <td> </td> > <td>NO</td> > <td>MUL</td> > <td>The workflow status of the bug. foreign key</td> > </tr> > <tr> > <td>creation_ts</td> > <td>DATETIME</td> > <td> </td> > <td>NO</td> > <td>MUL</td> > <td>The times of the bug creation</td> > </tr> > <tr> > <td>delta_ts</td> > <td bgcolor='#33CC66'>timestamp/DATETIME</td> > <td> </td> > <td>NO</td> > <td>MUL</td> > <td>The timestamp of the last update. This includes updates to some related tables</td> > </tr> > <tr> > <td>short_desc</td> > <td>MEDIUMTEXT</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>A short description of the bug</td> > </tr> > <tr> > <td>op_sys</td> > <td>VARCHAR</td> > <td> </td> > <td>NO</td> > <td>MUL</td> > <td>The operating system on which the bug was observed. foreign key op_sys.value</td> > </tr> > <tr> > <td>priority</td> > <td>VARCHAR</td> > <td> </td> > <td>NO</td> > <td>MUL</td> > <td>The priority of the bug. foreign key priority.value</td> > </tr> > <tr> > <td>product_id</td> > <td>SMALLINT</td> > <td> </td> > <td>NO</td> > <td>MUL</td> > <td>The product (foreign key products.id)</td> > </tr> > <tr> > <td>rep_platform</td> > <td>VARCHAR</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>The platform on which the bug was reported. foreign key rep_platform.value</td> > </tr> > <tr> > <td>reporter</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td>MUL</td> > <td>The user who reported this (foreign key profiles.userid)</td> > </tr> > <tr> > <td>version</td> > <td>VARCHAR</td> > <td> </td> > <td>NO</td> > <td>MUL</td> > <td>The product version (foreign key versions.value)</td> > </tr> > <tr> > <td>component_id</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td>MUL</td> > <td>The product component (foreign key components.id)</td> > </tr> > <tr> > <td>resolution</td> > <td>VARCHAR</td> > <td> </td> > <td>YES</td> > <td>MUL</td> > <td>The bug resolution foreign key resolution.value</td> > </tr> > <tr> > <td>target_milestone</td> > <td>VARCHAR</td> > <td>---</td> > <td>NO</td> > <td>MUL</td> > <td>The milestone by which this bug should be resolved. (foreign key milestones.value)</td> > </tr> > <tr> > <td>qa_contact</td> > <td>MEDIUMINT</td> > <td> </td> > <td>YES</td> > <td>MUL</td> > <td>The QA contact (foreign key profiles.userid)</td> > </tr> > <tr> > <td>status_whiteboard</td> > <td>MEDIUMTEXT</td> > <td> </td> > <td bgcolor='#33CC66'>YES/NO</td> > <td> </td> > <td>This seems to be just a small whiteboard field</td> > </tr> > <tr> > <td>votes</td> > <td>MEDIUMINT</td> > <td> </td> > <td>YES</td> > <td>MUL</td> > <td>The number of votes</td> > </tr> > <tr> > <td>keywords</td> > <td>MEDIUMTEXT</td> > <td> </td> > <td>YES</td> > <td> </td> > <td>A set of keywords. Note that this duplicates information in the keywords table.(foreign key keyworddefs.name)</td> > </tr> > <tr> > <td>lastdiffed</td> > <td>DATETIME</td> > <td> </td> > <td>YES</td> > <td> </td> > <td>The time at which information about this bug changing was last emailed to the cc list</td> > </tr> > <tr> > <td>everconfirmed</td> > <td>TINYINT</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>1 if this bug has ever been confirmed. This is used for validation of some sort</td> > </tr> > <tr> > <td>reporter_accessible</td> > <td>TINYINT</td> > <td>1</td> > <td>NO</td> > <td> </td> > <td>1 if the reporter can see this bug (even if in the wrong group) 0 otherwise</td> > </tr> > <tr> > <td>cclist_accessible</td> > <td>TINYINT</td> > <td>1</td> > <td>NO</td> > <td> </td> > <td>1 if people on the CC list can see this bug (even if in the wrong group);0 otherwise</td> > </tr> > <tr> > <td>estimated_time</td> > <td>DECIMAL</td> > <td bgcolor='#33CC66'>/0.00</td> > <td bgcolor='#33CC66'>2)"/NO</td> > <td> </td> > <td>The original estimate of the total effort required to fix this bug (in hours)</td> > </tr> > <tr> > <td>remaining_time</td> > <td>DECIMAL</td> > <td bgcolor='#33CC66'>/0.00</td> > <td bgcolor='#33CC66'>2)"/NO</td> > <td> </td> > <td>The current estimate of the remaining effort required to fix this bug (in hours)</td> > </tr> > <tr bgcolor='#FFFF66'> > <td>deadline</td> > <td>DATETIME</td> > <td> </td> > <td>YES</td> > <td> </td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > <tr> > <td>alias</td> > <td>VARCHAR</td> > <td> </td> > <td>YES</td> > <td bgcolor='#33CC66'>/UNI</td> > <td>An alias for the bug which can be used instead of the bug number.</td> > </tr> > <tr> > <td>cust_facing</td> > <td>VARCHAR</td> > <td> </td> > <td>YES</td> > <td> </td> > <td>used to mark extra status information in bug reports and is used by certain groups</td> > </tr> > <tr> > <td>devel_whiteboard</td> > <td>VARCHAR</td> > <td> </td> > <td>YES</td> > <td> </td> > <td>used to mark extra status information in bug reports and used by devel group</td> > </tr> > <tr> > <td>fixed_in</td> > <td>VARCHAR</td> > <td> </td> > <td>YES</td> > <td> </td> > <td> it is a text field to enter version that a bug has been fixed in, it is not strictly enforced, (examples: rpm package version, a release version)</td> > </tr> > <tr> > <td>internal_whiteboard</td> > <td>VARCHAR</td> > <td> </td> > <td>YES</td> > <td> </td> > <td>used to mark extra status information in bug reports and used by bz group</td> > </tr> > <tr> > <td>qa_whiteboard</td> > <td>VARCHAR</td> > <td> </td> > <td>YES</td> > <td> </td> > <td>used to mark extra status information in bug reports and used by qa group</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%'> > <tr> > <th>NAME</th> > <td colspan="5">bugs_activity</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">Activity on the bugs table.</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr> > <td>bug_id</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td>MUL</td> > <td>Which bug (foreign key bugs.bug_id)</td> > </tr> > <tr> > <td>attach_id</td> > <td>MEDIUMINT</td> > <td> </td> > <td>YES</td> > <td>MUL</td> > <td>If the change was to an attachment (foreign key attachments.attach_id)</td> > </tr> > <tr> > <td>who</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td>MUL</td> > <td>Which user (foreign key profiles.userid)</td> > </tr> > <tr> > <td>bug_when</td> > <td>DATETIME</td> > <td> </td> > <td>NO</td> > <td>MUL</td> > <td>When was the change made?</td> > </tr> > <tr> > <td>fieldid</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td>MUL</td> > <td>What was the fieldid? (foreign key fielddefs.id)</td> > </tr> > <tr> > <td>added</td> > <td>VARCHAR</td> > <td> </td> > <td>YES</td> > <td> </td> > <td>The new value of this field</td> > </tr> > <tr> > <td>removed</td> > <td>VARCHAR</td> > <td> </td> > <td>YES</td> > <td> </td> > <td>The old value of this field</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%'> > <tr> > <th>NAME</th> > <td colspan="5">bz_it_map</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">Mapping bugzilla bug ids with issue tracker ids.</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr> > <td>bz_id</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td bgcolor='#33CC66'>PRI/MUL</td> > <td>Bugzilla bug id (foreign key bugs.bug_id)</td> > </tr> > <tr> > <td>it_id</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>Issue tracker id</td> > </tr> > <tr> > <td>it_score</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>Issue tracker score</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%' bgcolor='#FFFF66'> > <tr> > <th>NAME</th> > <td colspan="5">bz_schema</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">!! table found in bugzilla_3 but not in bugzilla_2_18 !!</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr bgcolor='#FFFF66'> > <td>schema_data</td> > <td>LONGBLOB</td> > <td> </td> > <td bgcolor='#FF0033'><b>NO</b></td> > <td> </td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > <tr bgcolor='#FFFF66'> > <td>version</td> > <td>DECIMAL</td> > <td> </td> > <td bgcolor='#FF0033'><b>NO</b></td> > <td> </td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%'> > <tr> > <th>NAME</th> > <td colspan="5">category_group_map</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">Which groups does a user have to be in to view chart data in a given category.</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr> > <td>category_id</td> > <td>SMALLINT</td> > <td> </td> > <td>NO</td> > <td>PRI</td> > <td>The series category (foreign key series_categories.id)</td> > </tr> > <tr> > <td>group_id</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td>PRI</td> > <td>Users who have asked to receive email when a bug changes (foreign key groups.id)</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%'> > <tr> > <th>NAME</th> > <td colspan="5">cc</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">Users who have asked to receive email when a bug changes.</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr> > <td>bug_id</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td>PRI</td> > <td>The bug (foreign key bugs.bug_id)</td> > </tr> > <tr> > <td>who</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td>PRI</td> > <td>The user (foreign key profiles.userid)</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%' bgcolor='#FFFF66'> > <tr> > <th>NAME</th> > <td colspan="5">classifications</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">!! table found in bugzilla_3 but not in bugzilla_2_18 !!</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr bgcolor='#FFFF66'> > <td>id</td> > <td>SMALLINT</td> > <td> </td> > <td bgcolor='#FF0033'><b>NO</b></td> > <td>PRI</td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > <tr bgcolor='#FFFF66'> > <td>name</td> > <td>VARCHAR</td> > <td> </td> > <td bgcolor='#FF0033'><b>NO</b></td> > <td>UNI</td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > <tr bgcolor='#FFFF66'> > <td>description</td> > <td>MEDIUMTEXT</td> > <td> </td> > <td>YES</td> > <td> </td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > <tr bgcolor='#FFFF66'> > <td>sortkey</td> > <td>SMALLINT</td> > <td> </td> > <td bgcolor='#FF0033'><b>NO</b></td> > <td> </td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%'> > <tr> > <th>NAME</th> > <td colspan="5">component_cc</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">Maps every component to its users in the cclist, one user per record</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr> > <td>user_id</td> > <td>MEDIUMINT</td> > <td> </td> > <td bgcolor='#33CC66'>YES/NO</td> > <td bgcolor='#33CC66'>MUL/PRI</td> > <td>The user id (foreign key profiles.userid)</td> > </tr> > <tr> > <td>component_id</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td bgcolor='#33CC66'>MUL/PRI</td> > <td>The component id (foreign key components.id)</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%'> > <tr> > <th>NAME</th> > <td colspan="5">components</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">the work for each product is divided into the components of that product, each component is represented by a row in the componenets table</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr> > <td>id</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td>PRI</td> > <td>The component id.</td> > </tr> > <tr> > <td>name</td> > <td>VARCHAR</td> > <td> </td> > <td>NO</td> > <td>MUL</td> > <td>The component name</td> > </tr> > <tr> > <td>product_id</td> > <td>SMALLINT</td> > <td> </td> > <td>NO</td> > <td>MUL</td> > <td>The product (foreign key products.id)</td> > </tr> > <tr> > <td>initialowner</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td>MUL</td> > <td>The default initial owner of bugs in this component. On component creation (foreign key profiles.userid)</td> > </tr> > <tr> > <td>initialqacontact</td> > <td>MEDIUMINT</td> > <td> </td> > <td>YES</td> > <td>MUL</td> > <td>The initial qa_contact field for bugs of this component. Note that the use of the qa_contact field is optional (foreign key profiles.userid) </td> > </tr> > <tr> > <td>description</td> > <td>MEDIUMTEXT</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>A description of the component.</td> > </tr> > <tr> > <td>initialcclist</td> > <td>MEDIUMTEXT</td> > <td> </td> > <td>YES</td> > <td> </td> > <td>is a string data type with a ':' separated list of bugzilla user id's to allow multiple people to automatically get cc'ed when bugs were created for a componet</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%'> > <tr> > <th>NAME</th> > <td colspan="5">dependencies</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">Which bugs depend on other bugs.</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr> > <td>blocked</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td>MUL</td> > <td>Which bug is blocked (foreign key bugs.bug_id)</td> > </tr> > <tr> > <td>dependson</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td>MUL</td> > <td>Which bug does it depend on (foreign key bugs.bug_id)</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%'> > <tr> > <th>NAME</th> > <td colspan="5">duplicates</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">Which bugs are duplicates of which other bugs.</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr> > <td>dupe_of</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td>MUL</td> > <td>The bug which is duplicated (foreign key bugs.bug_id)</td> > </tr> > <tr> > <td>dupe</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td>PRI</td> > <td>The duplicate bug (foreign key bugs.bug_id)</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%' bgcolor='#FFFF66'> > <tr> > <th>NAME</th> > <td colspan="5">email_setting</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">!! table found in bugzilla_3 but not in bugzilla_2_18 !!</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr bgcolor='#FFFF66'> > <td>user_id</td> > <td>MEDIUMINT</td> > <td> </td> > <td bgcolor='#FF0033'><b>NO</b></td> > <td>PRI</td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > <tr bgcolor='#FFFF66'> > <td>relationship</td> > <td>TINYINT</td> > <td> </td> > <td bgcolor='#FF0033'><b>NO</b></td> > <td>PRI</td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > <tr bgcolor='#FFFF66'> > <td>event</td> > <td>TINYINT</td> > <td> </td> > <td bgcolor='#FF0033'><b>NO</b></td> > <td>PRI</td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%'> > <tr> > <th>NAME</th> > <td colspan="5">ext_bz_bug_map</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">has the links of our bug ids to external bug ids to that allow bugzilla ids to have references to external bugs in outside bug trackers</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr> > <td>bug_id</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td bgcolor='#33CC66'>PRI/MUL</td> > <td>bugzilla bug id (foreign key bugs.bug_id)</td> > </tr> > <tr> > <td>ext_bz_id</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td bgcolor='#33CC66'>PRI/MUL</td> > <td>id for external bugzilla (foreign key external_bugzilla.id)</td> > </tr> > <tr> > <td>ext_bz_bug_id</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>external bugzilla bug id</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%'> > <tr> > <th>NAME</th> > <td colspan="5">external_bugzilla</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">lists the trackers we know about</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr> > <td>id</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td>PRI</td> > <td>the tracker id</td> > </tr> > <tr> > <td>url</td> > <td>VARCHAR</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>the url of the tracker</td> > </tr> > <tr> > <td>description</td> > <td>VARCHAR</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>description of the tracker</td> > </tr> > <tr> > <td>full_url</td> > <td>VARCHAR</td> > <td> </td> > <td>YES</td> > <td> </td> > <td>the full url of the tracker</td> > </tr> > <tr> > <td>is_bz</td> > <td>TINYINT</td> > <td> </td> > <td>YES</td> > <td> </td> > <td>is it a bugzilla tracker</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%'> > <tr> > <th>NAME</th> > <td colspan="5">fielddefs</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">The fields of a bug.</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr bgcolor='#FFFF66'> > <td>id</td> > <td>MEDIUMINT</td> > <td> </td> > <td bgcolor='#FF0033'><b>NO</b></td> > <td>PRI</td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > <tr> > <td>name</td> > <td>VARCHAR</td> > <td> </td> > <td>NO</td> > <td>UNI</td> > <td>field name or definition (some fields are names of other tables or of fields in other tables)</td> > </tr> > <tr bgcolor='#FFFF66'> > <td>type</td> > <td>SMALLINT</td> > <td> </td> > <td>YES</td> > <td> </td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > <tr bgcolor='#FFFF66'> > <td>custom</td> > <td>TINYINT</td> > <td> </td> > <td>YES</td> > <td> </td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > <tr> > <td>description</td> > <td bgcolor='#33CC66'>mediumtext/TINYTEXT</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>long description</td> > </tr> > <tr> > <td>mailhead</td> > <td>TINYINT</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>whether or not to send the field description in mail notifications.</td> > </tr> > <tr> > <td>sortkey</td> > <td>SMALLINT</td> > <td> </td> > <td>NO</td> > <td>MUL</td> > <td>the order of fields in mail notifications.</td> > </tr> > <tr bgcolor='#FFFF66'> > <td>obsolete</td> > <td>TINYINT</td> > <td> </td> > <td>YES</td> > <td> </td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > <tr bgcolor='#FFFF66'> > <td>enter_bug</td> > <td>TINYINT</td> > <td> </td> > <td>YES</td> > <td> </td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > <tr bgcolor='#9966FF'> > <td>fieldid</td> > <td>mediumint(9)</td> > <td></td> > <td>NO</td> > <td>PRI</td> > <td>!! field in bugzilla_2.18 but not in bugzilla_3 !!</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%'> > <tr> > <th>NAME</th> > <td colspan="5">flagexclusions</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">It may be forbidden to set a given flag on an item (bug or attachment) if that item is in a given product or component. This table records such exclusions.</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr> > <td>type_id</td> > <td>SMALLINT</td> > <td> </td> > <td>NO</td> > <td>MUL</td> > <td>The flag type. (foreign key flagtypes.id)</td> > </tr> > <tr> > <td>product_id</td> > <td>SMALLINT</td> > <td> </td> > <td>YES</td> > <td>MUL</td> > <td>The product (foreign key products.id)</td> > </tr> > <tr> > <td>component_id</td> > <td>MEDIUMINT</td> > <td> </td> > <td>YES</td> > <td>MUL</td> > <td>The component (foreign key components.id)</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%'> > <tr> > <th>NAME</th> > <td colspan="5">flaginclusions</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">An item (bug or attachment) may be required to be in a given product or component for a flag to be set. This table records such requirements.</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr> > <td>type_id</td> > <td>SMALLINT</td> > <td> </td> > <td>NO</td> > <td>MUL</td> > <td>The flag type. (foreign key flagtypes.id)</td> > </tr> > <tr> > <td>product_id</td> > <td>SMALLINT</td> > <td> </td> > <td>YES</td> > <td>MUL</td> > <td>The product (foreign key products.id)</td> > </tr> > <tr> > <td>component_id</td> > <td>MEDIUMINT</td> > <td> </td> > <td>YES</td> > <td>MUL</td> > <td>The component (foreign key components.id)</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%'> > <tr> > <th>NAME</th> > <td colspan="5">flags</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">This table records the flags set on bugs or attachments.</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr> > <td>id</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td>PRI</td> > <td>A unique ID.</td> > </tr> > <tr> > <td>type_id</td> > <td>SMALLINT</td> > <td> </td> > <td>NO</td> > <td>MUL</td> > <td>The flag type. (foreign key flagtypes.id)</td> > </tr> > <tr> > <td>status</td> > <td>CHAR</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>+ (granted)</td> > </tr> > <tr> > <td>bug_id</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td>MUL</td> > <td>bug. (foreign key bugs.bug_id)</td> > </tr> > <tr> > <td>attach_id</td> > <td>MEDIUMINT</td> > <td> </td> > <td>YES</td> > <td>MUL</td> > <td>The attachment (foreign key attachments.attach_id)</td> > </tr> > <tr> > <td>creation_date</td> > <td>DATETIME</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>The date the flag was created.</td> > </tr> > <tr> > <td>modification_date</td> > <td>DATETIME</td> > <td> </td> > <td>YES</td> > <td> </td> > <td>The date the flag was most recently modified or created</td> > </tr> > <tr> > <td>setter_id</td> > <td>MEDIUMINT</td> > <td> </td> > <td>YES</td> > <td>MUL</td> > <td>The ID of the user who created (foreign key profiles.userid)</td> > </tr> > <tr> > <td>requestee_id</td> > <td>MEDIUMINT</td> > <td> </td> > <td>YES</td> > <td>MUL</td> > <td>The ID of the user to whom this request flag is addressed (foreign key profiles.userid)</td> > </tr> > <tr> > <td>is_active</td> > <td>TINYINT</td> > <td>1</td> > <td>NO</td> > <td> </td> > <td> when a flag is created for the first time on a bug report is_active is set to 1 when the flag is deleted, the row is not really deleted, the is_active value is set to 0,if a flag is then reinstated later for a bug, it just gets is_active reset to 1 again</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%'> > <tr> > <th>NAME</th> > <td colspan="5">flagtypes</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">The types of flags available for bugs and attachments. See the notes on flags.</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr> > <td>id</td> > <td>SMALLINT</td> > <td> </td> > <td>NO</td> > <td>PRI</td> > <td>The flag type ID</td> > </tr> > <tr> > <td>name</td> > <td>VARCHAR</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>The short flag name</td> > </tr> > <tr> > <td>description</td> > <td bgcolor='#33CC66'>text/MEDIUMTEXT</td> > <td> </td> > <td bgcolor='#33CC66'>YES/NO</td> > <td> </td> > <td>The description of the flag</td> > </tr> > <tr> > <td>cc_list</td> > <td>VARCHAR</td> > <td> </td> > <td>YES</td> > <td> </td> > <td>A string containing email addresses to which notification of requests for this flag should be sent. This is filtered using the groups system before messages are actually sent</td> > </tr> > <tr> > <td>target_type</td> > <td>CHAR</td> > <td>b</td> > <td>NO</td> > <td> </td> > <td>type for attachment flags</td> > </tr> > <tr> > <td>is_active</td> > <td>TINYINT</td> > <td>1</td> > <td>NO</td> > <td> </td> > <td>1 if the flag appears in the UI and can be set; 0 otherwise.</td> > </tr> > <tr> > <td>is_requestable</td> > <td>TINYINT</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>1 if the flag may be requested; 0 otherwise.</td> > </tr> > <tr> > <td>is_requesteeble</td> > <td>TINYINT</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>1 if a request for this flag may be aimed at a particular user; 0 otherwise</td> > </tr> > <tr> > <td>is_multiplicable</td> > <td>TINYINT</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>1 if multiple instances of this flag may be set on the same item; 0 otherwise.</td> > </tr> > <tr> > <td>sortkey</td> > <td>SMALLINT</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>An integer used for sorting flags for display.</td> > </tr> > <tr> > <td>grant_group_id</td> > <td>MEDIUMINT</td> > <td> </td> > <td>YES</td> > <td>MUL</td> > <td>Group membership required to grant this flag. (foreign key groups.id)</td> > </tr> > <tr> > <td>request_group_id</td> > <td>MEDIUMINT</td> > <td> </td> > <td>YES</td> > <td> </td> > <td>Group membership required to request this flag. (foreign key groups.id)</td> > </tr> > <tr> > <td>view_group_id</td> > <td>MEDIUMINT</td> > <td> </td> > <td>YES</td> > <td>MUL</td> > <td>corresponds to the groups table id designating which group a person needs to be in to see that flag choice in a bug report (foreign key groups.id)</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%'> > <tr> > <th>NAME</th> > <td colspan="5">group_control_map</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">This table describes the relationship of groups to products (whether membership in a given group is required for entering or editing a bug in a given product).</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr> > <td>group_id</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td>PRI</td> > <td>The group. (foreign key groups.id)</td> > </tr> > <tr> > <td>product_id</td> > <td>SMALLINT</td> > <td> </td> > <td>NO</td> > <td>PRI</td> > <td>The product. (foreign key products.id)</td> > </tr> > <tr> > <td>entry</td> > <td>TINYINT</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>1 if membership of this group is required to enter a bug in this product; 0 otherwise.</td> > </tr> > <tr> > <td>membercontrol</td> > <td>TINYINT</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>Determines what control members of this group have over whether a bug for this product is placed in this group</td> > </tr> > <tr> > <td>othercontrol</td> > <td>TINYINT</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>Determines what control non-group-members have over whether a new bug for this product is placed in this group.</td> > </tr> > <tr> > <td>canedit</td> > <td>TINYINT</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>1 if membership of this group is required to edit a bug in this product; 0 otherwise.</td> > </tr> > <tr bgcolor='#FFFF66'> > <td>editcomponents</td> > <td>TINYINT</td> > <td> </td> > <td>YES</td> > <td> </td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > <tr bgcolor='#FFFF66'> > <td>editbugs</td> > <td>TINYINT</td> > <td> </td> > <td>YES</td> > <td> </td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > <tr bgcolor='#FFFF66'> > <td>canconfirm</td> > <td>TINYINT</td> > <td> </td> > <td>YES</td> > <td> </td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%'> > <tr> > <th>NAME</th> > <td colspan="5">group_group_map</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">Groups can be configured such that membership of one group automatically confers rights over some other groups. This table records that configuration</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr> > <td>member_id</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td bgcolor='#33CC66'>PRI/MUL</td> > <td>The group whose membership grants membership or bless privilege for another group (foreign key groups.id)</td> > </tr> > <tr> > <td>grantor_id</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td bgcolor='#33CC66'>PRI/MUL</td> > <td>The group whose membership or bless privilege is automatically granted.(foreign key groups.id)</td> > </tr> > <tr bgcolor='#FFFF66'> > <td>grant_type</td> > <td>TINYINT</td> > <td> </td> > <td>YES</td> > <td> </td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > <tr> > <td>isbless</td> > <td>TINYINT</td> > <td> </td> > <td>NO</td> > <td> </td> > <td> is set to 1 or 0 based on whether people belonging to that group can bless others into that group gives them admin rights to put people in that group</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%'> > <tr> > <th>NAME</th> > <td colspan="5">groups</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">This table describes a number of user groups. Each group allows its members to perform a restricted activity. </td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr> > <td>id</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td>PRI</td> > <td>The group id.</td> > </tr> > <tr> > <td>name</td> > <td>VARCHAR</td> > <td> </td> > <td>NO</td> > <td>UNI</td> > <td>A short name for the group.</td> > </tr> > <tr> > <td>description</td> > <td bgcolor='#33CC66'>text/MEDIUMTEXT</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>A long description of the group.</td> > </tr> > <tr> > <td>isbuggroup</td> > <td>TINYINT</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>1 if this is a group controlling access to a set of bugs.</td> > </tr> > <tr> > <td>userregexp</td> > <td>VARCHAR</td> > <td> </td> > <td>YES</td> > <td> </td> > <td>a regexp used to determine membership of new users.</td> > </tr> > <tr> > <td>isactive</td> > <td>TINYINT</td> > <td>1</td> > <td>NO</td> > <td> </td> > <td>1 if bugs can be added to this group; 0 otherwise.</td> > </tr> > <tr bgcolor='#FFFF66'> > <td>icon_url</td> > <td>TINYTEXT</td> > <td> </td> > <td>YES</td> > <td> </td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > <tr> > <td>contract</td> > <td>TINYINT</td> > <td> </td> > <td>YES</td> > <td> </td> > <td>remnants of an old RH feature where a group was designated</td> > </tr> > <tr> > <td>last_changed</td> > <td>DATETIME</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>the date when a group had its attributes changed last, BZ uses the date to determine whether a persons groups permissions needs to be re-assessed or re-derived as Bugzilla considers it</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%'> > <tr> > <th>NAME</th> > <td colspan="5">keyworddefs</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">Names and definitions of the keywords.</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr> > <td>id</td> > <td>SMALLINT</td> > <td> </td> > <td>NO</td> > <td>PRI</td> > <td>A unique number identifying this keyword.</td> > </tr> > <tr> > <td>name</td> > <td>VARCHAR</td> > <td> </td> > <td>NO</td> > <td>UNI</td> > <td>The keyword itself.</td> > </tr> > <tr> > <td>description</td> > <td>MEDIUMTEXT</td> > <td> </td> > <td>YES</td> > <td> </td> > <td>The meaning of the keyword.</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%'> > <tr> > <th>NAME</th> > <td colspan="5">keywords</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">Bugs may have keywords. This table defines which bugs have which keywords. The keywords are defined in the keyworddefs table.</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr> > <td>bug_id</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td>PRI</td> > <td>The bug (foreign key bugs.bug_id)</td> > </tr> > <tr> > <td>keywordid</td> > <td>SMALLINT</td> > <td> </td> > <td>NO</td> > <td>PRI</td> > <td>The keyword ID (foreign key keyworddefs.id)</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%'> > <tr> > <th>NAME</th> > <td colspan="5">logincookies</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">Bugzilla generates a cookie each time a user logs in, and uses it for subsequent authentication. The cookies generated are stored in this table.</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr> > <td>cookie</td> > <td>VARCHAR</td> > <td> </td> > <td>NO</td> > <td>PRI</td> > <td>The cookie</td> > </tr> > <tr> > <td>userid</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td>MUL</td> > <td>The user id; (foreign key profiles.userid)</td> > </tr> > <tr bgcolor='#FFFF66'> > <td>ipaddr</td> > <td>VARCHAR</td> > <td> </td> > <td>YES</td> > <td> </td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > <tr> > <td>lastused</td> > <td bgcolor='#33CC66'>timestamp/DATETIME</td> > <td> </td> > <td>NO</td> > <td>MUL</td> > <td>The timestamp of this login.</td> > </tr> > <tr> > <td>session</td> > <td>VARCHAR</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>series of user login cookies</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%'> > <tr> > <th>NAME</th> > <td colspan="5">longdescs</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">Each bug has a number of comments associated with it. These are stored individually in this table.</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr bgcolor='#FFFF66'> > <td>comment_id</td> > <td>MEDIUMINT</td> > <td> </td> > <td bgcolor='#FF0033'><b>NO</b></td> > <td>PRI</td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > <tr> > <td>bug_id</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td>MUL</td> > <td>bug (foreign key bugs.bug_id)</td> > </tr> > <tr> > <td>who</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td>MUL</td> > <td>the user who added this text (foreign key profiles.userid)</td> > </tr> > <tr> > <td>bug_when</td> > <td>DATETIME</td> > <td> </td> > <td>NO</td> > <td>MUL</td> > <td>when the text was added</td> > </tr> > <tr> > <td>work_time</td> > <td>DECIMAL</td> > <td bgcolor='#33CC66'>/0.00</td> > <td bgcolor='#33CC66'>2)"/NO</td> > <td> </td> > <td>Number of hours worked on this bug (for time tracking purposes).</td> > </tr> > <tr> > <td>thetext</td> > <td>MEDIUMTEXT</td> > <td> </td> > <td bgcolor='#33CC66'>YES/NO</td> > <td bgcolor='#33CC66'>/MUL</td> > <td>the text itself.</td> > </tr> > <tr> > <td>isprivate</td> > <td>TINYINT</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>Non-zero if this comment is private</td> > </tr> > <tr bgcolor='#FFFF66'> > <td>already_wrapped</td> > <td>TINYINT</td> > <td> </td> > <td>YES</td> > <td> </td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > <tr bgcolor='#FFFF66'> > <td>type</td> > <td>SMALLINT</td> > <td> </td> > <td>YES</td> > <td> </td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > <tr bgcolor='#FFFF66'> > <td>extra_data</td> > <td>VARCHAR</td> > <td> </td> > <td>YES</td> > <td> </td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > <tr> > <td>public_in_it</td> > <td>TINYINT</td> > <td> </td> > <td>YES</td> > <td> </td> > <td>when a bug has an IssueTracker ID attached to it, Bugzilla will send any comments to each IssueTracker as well using XMLRPC so a person can check a box on BZ that says whether that comment should be public or private in the IssueTracker report and that value is also stored in the longdescs table</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%'> > <tr> > <th>NAME</th> > <td colspan="5">milestones</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">Products may have milestones defined. The intention is that a milestone should be a point in a project at which a set of bugs has been resolved</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr bgcolor='#FFFF66'> > <td>id</td> > <td>MEDIUMINT</td> > <td> </td> > <td bgcolor='#FF0033'><b>NO</b></td> > <td>PRI</td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > <tr> > <td>product_id</td> > <td>SMALLINT</td> > <td> </td> > <td>NO</td> > <td bgcolor='#33CC66'>PRI/MUL</td> > <td>The product (foreign key products.id)</td> > </tr> > <tr> > <td>value</td> > <td>VARCHAR</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>The name of the milestone (e.g. 3.1 RTM)</td> > </tr> > <tr> > <td>sortkey</td> > <td>SMALLINT</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>A number used for sorting milestones for a given product.</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%'> > <tr> > <th>NAME</th> > <td colspan="5">namedqueries</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">Users can name queries. Links to named query pages appear in a navigation footer bar on most Bugzilla pages. A query named (Default query) is a user default query</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr bgcolor='#FFFF66'> > <td>id</td> > <td>MEDIUMINT</td> > <td> </td> > <td bgcolor='#FF0033'><b>NO</b></td> > <td>PRI</td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > <tr> > <td>userid</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td bgcolor='#33CC66'>PRI/MUL</td> > <td>The user whose query this is (foreign key profiles.userid)</td> > </tr> > <tr> > <td>name</td> > <td>VARCHAR</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>The name of the query.</td> > </tr> > <tr> > <td>query</td> > <td>MEDIUMTEXT</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>The query (text to append to the query page URL).</td> > </tr> > <tr bgcolor='#FFFF66'> > <td>query_type</td> > <td>TINYINT</td> > <td> </td> > <td>YES</td> > <td> </td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > <tr> > <td>public</td> > <td>TINYINT</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>public is whether the query can be shared with others if others know the right query name</td> > </tr> > <tr bgcolor='#9966FF'> > <td>linkinfooter</td> > <td>tinyint(4)</td> > <td></td> > <td>NO</td> > <td></td> > <td>!! field in bugzilla_2.18 but not in bugzilla_3 !!</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%' bgcolor='#FFFF66'> > <tr> > <th>NAME</th> > <td colspan="5">namedqueries_link_in_footer</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">!! table found in bugzilla_3 but not in bugzilla_2_18 !!</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr bgcolor='#FFFF66'> > <td>namedquery_id</td> > <td>MEDIUMINT</td> > <td> </td> > <td bgcolor='#FF0033'><b>NO</b></td> > <td>PRI</td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > <tr bgcolor='#FFFF66'> > <td>user_id</td> > <td>MEDIUMINT</td> > <td> </td> > <td bgcolor='#FF0033'><b>NO</b></td> > <td>PRI</td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%' bgcolor='#FFFF66'> > <tr> > <th>NAME</th> > <td colspan="5">namedquery_group_map</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">!! table found in bugzilla_3 but not in bugzilla_2_18 !!</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr bgcolor='#FFFF66'> > <td>namedquery_id</td> > <td>MEDIUMINT</td> > <td> </td> > <td bgcolor='#FF0033'><b>NO</b></td> > <td>PRI</td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > <tr bgcolor='#FFFF66'> > <td>group_id</td> > <td>MEDIUMINT</td> > <td> </td> > <td bgcolor='#FF0033'><b>NO</b></td> > <td>MUL</td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%'> > <tr> > <th>NAME</th> > <td colspan="5">op_sys</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">the possible values of the operating system field of a bug</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr> > <td>id</td> > <td bgcolor='#33CC66'>tinyint(4)/SMALLINT</td> > <td> </td> > <td>NO</td> > <td>PRI</td> > <td>a unique ID.</td> > </tr> > <tr> > <td>value</td> > <td>VARCHAR</td> > <td> </td> > <td>NO</td> > <td>UNI</td> > <td>A possible value of the field</td> > </tr> > <tr bgcolor='#FFFF66'> > <td>sortkey</td> > <td>SMALLINT</td> > <td> </td> > <td>YES</td> > <td>MUL</td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > <tr bgcolor='#FFFF66'> > <td>isactive</td> > <td>TINYINT</td> > <td>1</td> > <td>YES</td> > <td> </td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%'> > <tr> > <th>NAME</th> > <td colspan="5">priority</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">the possible values of the priority field of a bug</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr> > <td>id</td> > <td bgcolor='#33CC66'>tinyint(4)/SMALLINT</td> > <td> </td> > <td>NO</td> > <td>PRI</td> > <td>a unique ID.</td> > </tr> > <tr> > <td>value</td> > <td>VARCHAR</td> > <td> </td> > <td>NO</td> > <td>UNI</td> > <td>A possible value of the field</td> > </tr> > <tr bgcolor='#FFFF66'> > <td>sortkey</td> > <td>SMALLINT</td> > <td> </td> > <td>YES</td> > <td>MUL</td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > <tr bgcolor='#FFFF66'> > <td>isactive</td> > <td>TINYINT</td> > <td>1</td> > <td>YES</td> > <td> </td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%'> > <tr> > <th>NAME</th> > <td colspan="5">products</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">The work managed by Bugzilla is divided into products</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr> > <td>id</td> > <td>SMALLINT</td> > <td> </td> > <td>NO</td> > <td>PRI</td> > <td>The product ID.</td> > </tr> > <tr> > <td>name</td> > <td>VARCHAR</td> > <td> </td> > <td>NO</td> > <td>UNI</td> > <td>The product name.</td> > </tr> > <tr bgcolor='#FFFF66'> > <td>classification_id</td> > <td>SMALLINT</td> > <td>1</td> > <td>YES</td> > <td> </td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > <tr> > <td>description</td> > <td>MEDIUMTEXT</td> > <td> </td> > <td>YES</td> > <td> </td> > <td>The description of the product</td> > </tr> > <tr> > <td>milestoneurl</td> > <td bgcolor='#33CC66'>varchar(2000)/TINYTEXT</td> > <td> </td> > <td bgcolor='#33CC66'>YES/NO</td> > <td> </td> > <td>The URL of a document describing the product milestones.</td> > </tr> > <tr> > <td>disallownew</td> > <td>TINYINT</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>New bugs can only be created for this product if this is 0.</td> > </tr> > <tr> > <td>votesperuser</td> > <td>SMALLINT</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>Total votes which a single user has for bugs of this product.</td> > </tr> > <tr> > <td>maxvotesperbug</td> > <td>SMALLINT</td> > <td>10000</td> > <td>NO</td> > <td> </td> > <td>Maximum number of votes which a bug may have.</td> > </tr> > <tr> > <td>votestoconfirm</td> > <td>SMALLINT</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>How many votes are required for this bug to become NEW.</td> > </tr> > <tr> > <td>defaultmilestone</td> > <td>VARCHAR</td> > <td>---</td> > <td>NO</td> > <td> </td> > <td>The default milestone for a new bug.</td> > </tr> > <tr> > <td>depends</td> > <td>TINYINT</td> > <td> </td> > <td>YES</td> > <td> </td> > <td>remnant of old interaction with another tool</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%' bgcolor='#FFFF66'> > <tr> > <th>NAME</th> > <td colspan="5">profile_setting</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">!! table found in bugzilla_3 but not in bugzilla_2_18 !!</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr bgcolor='#FFFF66'> > <td>user_id</td> > <td>MEDIUMINT</td> > <td> </td> > <td bgcolor='#FF0033'><b>NO</b></td> > <td>PRI</td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > <tr bgcolor='#FFFF66'> > <td>setting_name</td> > <td>VARCHAR</td> > <td> </td> > <td bgcolor='#FF0033'><b>NO</b></td> > <td>PRI</td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > <tr bgcolor='#FFFF66'> > <td>setting_value</td> > <td>VARCHAR</td> > <td> </td> > <td bgcolor='#FF0033'><b>NO</b></td> > <td> </td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%'> > <tr> > <th>NAME</th> > <td colspan="5">profiles</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">Bugzilla has users. Each user is represented by one row in the profiles table. Each user is referred by a number (profiles.userid) and an email address (profiles.login_name).</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr> > <td>userid</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td>PRI</td> > <td>user id</td> > </tr> > <tr> > <td>login_name</td> > <td>VARCHAR</td> > <td> </td> > <td>NO</td> > <td>UNI</td> > <td>The user's email address. Used when logging in or providing mailto: links.</td> > </tr> > <tr> > <td>cryptpassword</td> > <td>VARCHAR</td> > <td> </td> > <td>YES</td> > <td> </td> > <td>The user's password. The Perl function crypt is used.</td> > </tr> > <tr> > <td>realname</td> > <td>VARCHAR</td> > <td> </td> > <td bgcolor='#33CC66'>YES/NO</td> > <td> </td> > <td>The user's real name.</td> > </tr> > <tr> > <td>disabledtext</td> > <td>MEDIUMTEXT</td> > <td> </td> > <td>YES</td> > <td> </td> > <td>If non-empty</td> > </tr> > <tr bgcolor='#FFFF66'> > <td>disable_mail</td> > <td>TINYINT</td> > <td> </td> > <td>YES</td> > <td> </td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > <tr> > <td>mybugslink</td> > <td>TINYINT</td> > <td>1</td> > <td>NO</td> > <td> </td> > <td>indicates whether a 'My Bugs' link should appear at the bottom of each page.</td> > </tr> > <tr bgcolor='#FFFF66'> > <td>extern_id</td> > <td>VARCHAR</td> > <td> </td> > <td>YES</td> > <td> </td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > <tr> > <td>emailflags</td> > <td>MEDIUMTEXT</td> > <td> </td> > <td>YES</td> > <td> </td> > <td> a string that contains a user's email preferences for receiving bugzilla notifications</td> > </tr> > <tr> > <td>refreshed_when</td> > <td>DATETIME</td> > <td bgcolor='#33CC66'>"1900-01-01 00:00:00"/1900-01-01 00:00:00</td> > <td>NO</td> > <td> </td> > <td>the date that a user's permissions were last derived, goes along with last_changed in groups table</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%'> > <tr> > <th>NAME</th> > <td colspan="5">profiles_activity</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">This table is for recording changes to the profiles table. Currently it only records changes to group membership made with editusers.cgi. This allows the administrator to track group inflation. There is currently no code to inspect this table; only to add to it.</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr> > <td>userid</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td>MUL</td> > <td>The profile which has changed (foreign key profiles.userid)</td> > </tr> > <tr> > <td>who</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td>MUL</td> > <td>The user who changed it (foreign key profiles.userid)</td> > </tr> > <tr> > <td>profiles_when</td> > <td>DATETIME</td> > <td> </td> > <td>NO</td> > <td>MUL</td> > <td>When it was changed</td> > </tr> > <tr> > <td>fieldid</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td>MUL</td> > <td>The ID of the changed field (foreign key fielddefs.id)</td> > </tr> > <tr> > <td>oldvalue</td> > <td>VARCHAR</td> > <td> </td> > <td>YES</td> > <td> </td> > <td>The old value</td> > </tr> > <tr> > <td>newvalue</td> > <td>VARCHAR</td> > <td> </td> > <td>YES</td> > <td> </td> > <td>The new value.</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%'> > <tr> > <th>NAME</th> > <td colspan="5">quips</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">Bugzilla supports quips: small text messages, often humorous, which appear along with search results. The quips are selected at random from a set</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr> > <td>quipid</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td>PRI</td> > <td>A unique ID.</td> > </tr> > <tr> > <td>userid</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>The user who added this quip (foreign key profiles.userid)</td> > </tr> > <tr> > <td>quip</td> > <td bgcolor='#33CC66'>text/MEDIUMTEXT</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>The quip itself.</td> > </tr> > <tr> > <td>approved</td> > <td>TINYINT</td> > <td>1</td> > <td>NO</td> > <td> </td> > <td>1 if this quip has been approved for display</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%'> > <tr> > <th>NAME</th> > <td colspan="5">rep_platform</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">the possible values of the platform field of a bug</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr> > <td>id</td> > <td bgcolor='#33CC66'>tinyint(4)/SMALLINT</td> > <td> </td> > <td>NO</td> > <td>PRI</td> > <td>a unique ID.</td> > </tr> > <tr> > <td>value</td> > <td>VARCHAR</td> > <td> </td> > <td>NO</td> > <td>UNI</td> > <td>A possible value of the field</td> > </tr> > <tr bgcolor='#FFFF66'> > <td>sortkey</td> > <td>SMALLINT</td> > <td> </td> > <td>YES</td> > <td>MUL</td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > <tr bgcolor='#FFFF66'> > <td>isactive</td> > <td>TINYINT</td> > <td>1</td> > <td>YES</td> > <td> </td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%'> > <tr> > <th>NAME</th> > <td colspan="5">resolution</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">the possible values of the resolution field of a bug</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr> > <td>id</td> > <td bgcolor='#33CC66'>tinyint(4)/SMALLINT</td> > <td> </td> > <td>NO</td> > <td>PRI</td> > <td>a unique ID.</td> > </tr> > <tr> > <td>value</td> > <td>VARCHAR</td> > <td> </td> > <td>NO</td> > <td>UNI</td> > <td>A possible value of the field</td> > </tr> > <tr bgcolor='#FFFF66'> > <td>sortkey</td> > <td>SMALLINT</td> > <td> </td> > <td>YES</td> > <td>MUL</td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > <tr bgcolor='#FFFF66'> > <td>isactive</td> > <td>TINYINT</td> > <td>1</td> > <td>YES</td> > <td> </td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%'> > <tr> > <th>NAME</th> > <td colspan="5">series</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">Properties of the time-series datasets available (e.g. for plotting charts).</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr> > <td>series_id</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td>PRI</td> > <td>A unique ID.</td> > </tr> > <tr> > <td>creator</td> > <td>MEDIUMINT</td> > <td> </td> > <td bgcolor='#33CC66'>NO/YES</td> > <td>MUL</td> > <td>The user who created this series (foreign key profiles.userid).NULL if this series is created by checksetup when first installing Bugzilla.</td> > </tr> > <tr> > <td>category</td> > <td>SMALLINT</td> > <td> </td> > <td>NO</td> > <td>MUL</td> > <td>The series category. (foreign key series_categories.id)</td> > </tr> > <tr> > <td>subcategory</td> > <td>SMALLINT</td> > <td> </td> > <td>NO</td> > <td>MUL</td> > <td>The series subcategory. (foreign key series_categories.id)</td> > </tr> > <tr> > <td>name</td> > <td>VARCHAR</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>The series name.</td> > </tr> > <tr> > <td>frequency</td> > <td>SMALLINT</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>The period between data samples for this series</td> > </tr> > <tr> > <td>last_viewed</td> > <td>DATETIME</td> > <td> </td> > <td>YES</td> > <td> </td> > <td>The time at which this dataset was last viewed.</td> > </tr> > <tr> > <td>query</td> > <td>MEDIUMTEXT</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>a snippet of CGI which specifies a subset of bugs</td> > </tr> > <tr bgcolor='#FFFF66'> > <td>is_public</td> > <td>TINYINT</td> > <td> </td> > <td>YES</td> > <td> </td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > <tr bgcolor='#9966FF'> > <td>public</td> > <td>tinyint(1)</td> > <td>0</td> > <td>NO</td> > <td></td> > <td>!! field in bugzilla_2.18 but not in bugzilla_3 !!</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%'> > <tr> > <th>NAME</th> > <td colspan="5">series_categories</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">categories of the time-series datasets available</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr> > <td>id</td> > <td>SMALLINT</td> > <td> </td> > <td>NO</td> > <td>PRI</td> > <td>A unique ID.</td> > </tr> > <tr> > <td>name</td> > <td>VARCHAR</td> > <td> </td> > <td>NO</td> > <td>UNI</td> > <td>The category name.</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%'> > <tr> > <th>NAME</th> > <td colspan="5">series_data</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">Data for plotting time-series charts. </td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr> > <td>series_id</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td>PRI</td> > <td>The series ID. (foreign key series.series_id)</td> > </tr> > <tr> > <td>series_date</td> > <td>DATETIME</td> > <td> </td> > <td>NO</td> > <td>PRI</td> > <td>The time point at which this datum was collected.</td> > </tr> > <tr> > <td>series_value</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>The number of bugs in the dataset at this time point.</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%' bgcolor='#FFFF66'> > <tr> > <th>NAME</th> > <td colspan="5">setting</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">!! table found in bugzilla_3 but not in bugzilla_2_18 !!</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr bgcolor='#FFFF66'> > <td>name</td> > <td>VARCHAR</td> > <td> </td> > <td bgcolor='#FF0033'><b>NO</b></td> > <td>PRI</td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > <tr bgcolor='#FFFF66'> > <td>default_value</td> > <td>VARCHAR</td> > <td> </td> > <td bgcolor='#FF0033'><b>NO</b></td> > <td> </td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > <tr bgcolor='#FFFF66'> > <td>is_enabled</td> > <td>TINYINT</td> > <td>1</td> > <td bgcolor='#FF0033'><b>NO</b></td> > <td> </td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > <tr bgcolor='#FFFF66'> > <td>subclass</td> > <td>VARCHAR</td> > <td> </td> > <td>YES</td> > <td> </td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%' bgcolor='#FFFF66'> > <tr> > <th>NAME</th> > <td colspan="5">setting_value</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">!! table found in bugzilla_3 but not in bugzilla_2_18 !!</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr bgcolor='#FFFF66'> > <td>name</td> > <td>VARCHAR</td> > <td> </td> > <td bgcolor='#FF0033'><b>NO</b></td> > <td>PRI</td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > <tr bgcolor='#FFFF66'> > <td>value</td> > <td>VARCHAR</td> > <td> </td> > <td bgcolor='#FF0033'><b>NO</b></td> > <td>PRI</td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > <tr bgcolor='#FFFF66'> > <td>sortindex</td> > <td>SMALLINT</td> > <td> </td> > <td bgcolor='#FF0033'><b>NO</b></td> > <td> </td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%' bgcolor='#FFFF66'> > <tr> > <th>NAME</th> > <td colspan="5">status_workflow</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">!! table found in bugzilla_3 but not in bugzilla_2_18 !!</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr bgcolor='#FFFF66'> > <td>old_status</td> > <td>SMALLINT</td> > <td> </td> > <td>YES</td> > <td>MUL</td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > <tr bgcolor='#FFFF66'> > <td>new_status</td> > <td>SMALLINT</td> > <td> </td> > <td bgcolor='#FF0033'><b>NO</b></td> > <td> </td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > <tr bgcolor='#FFFF66'> > <td>require_comment</td> > <td>TINYINT</td> > <td> </td> > <td bgcolor='#FF0033'><b>NO</b></td> > <td> </td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%'> > <tr> > <th>NAME</th> > <td colspan="5">tokens</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">Tokens are sent to users to track activities such as creating new accounts and changing email addresses or passwords. They are also sent to browsers and used to track workflow, to prevent security problems (e.g. so that one can only delete groups from a session last seen on a group management page).</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr> > <td>userid</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td>MUL</td> > <td>The user to whom the token was issued. (foreign key profiles.userid)</td> > </tr> > <tr> > <td>issuedate</td> > <td>DATETIME</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>The date at which the token was issued</td> > </tr> > <tr> > <td>token</td> > <td>VARCHAR</td> > <td> </td> > <td>NO</td> > <td>PRI</td> > <td>The token itself.</td> > </tr> > <tr> > <td>tokentype</td> > <td>VARCHAR</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>The type of the token. Possible values: 'account' when creating a new user account</td> > </tr> > <tr> > <td>eventdata</td> > <td>TINYTEXT</td> > <td> </td> > <td>YES</td> > <td> </td> > <td>The expected event</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%'> > <tr> > <th>NAME</th> > <td colspan="5">user_group_map</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">This table records which users are members of each group, or can "bless" each group.</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr> > <td>user_id</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td>PRI</td> > <td>The user. (foreign key profiles.userid)</td> > </tr> > <tr> > <td>group_id</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td>PRI</td> > <td>The group. (foreign key groups.id)</td> > </tr> > <tr> > <td>isbless</td> > <td>TINYINT</td> > <td> </td> > <td>NO</td> > <td>PRI</td> > <td>0 if this row records group membership; 1 if this row records group bless privilege.</td> > </tr> > <tr> > <td>grant_type</td> > <td>TINYINT</td> > <td> </td> > <td>NO</td> > <td>PRI</td> > <td>0 if this membership or privilege is explicit. 1 if it is derived from a group hierarchy (see the group_group_map table). 2 if it results from matching a regular expression (see groups.userregexp).</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%'> > <tr> > <th>NAME</th> > <td colspan="5">versions</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">Product versions</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr bgcolor='#FFFF66'> > <td>id</td> > <td>MEDIUMINT</td> > <td> </td> > <td bgcolor='#FF0033'><b>NO</b></td> > <td>PRI</td> > <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> > </tr> > <tr> > <td>value</td> > <td>VARCHAR</td> > <td> </td> > <td bgcolor='#33CC66'>YES/NO</td> > <td> </td> > <td>The name of the version</td> > </tr> > <tr> > <td>product_id</td> > <td>SMALLINT</td> > <td> </td> > <td>NO</td> > <td>MUL</td> > <td>The product (foreign key products.id)</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%'> > <tr> > <th>NAME</th> > <td colspan="5">votes</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">Users may vote for bugs which they think are important. A user can vote for a bug more than once</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr> > <td>who</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td>MUL</td> > <td>The user (foreign key profiles.userid)</td> > </tr> > <tr> > <td>bug_id</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td>MUL</td> > <td>The bug (foreign key bugs.bug_id)</td> > </tr> > <tr> > <td>vote_count</td> > <td>SMALLINT</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>How many votes.</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%'> > <tr> > <th>NAME</th> > <td colspan="5">watch</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">Bugzilla lets users watch each other receiving each other Bugzilla email</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr> > <td>watcher</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td>PRI</td> > <td>The watching user (foreign key profiles.userid)</td> > </tr> > <tr> > <td>watched</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td>PRI</td> > <td>The watched user (foreign key profiles.userid)</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%'> > <tr> > <th>NAME</th> > <td colspan="5">whine_events</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">describes an email message: subject line and some body text to precede query results</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr> > <td>id</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td>PRI</td> > <td>The whine event ID</td> > </tr> > <tr> > <td>owner_userid</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td>MUL</td> > <td>The user ID of the whine owner (foreign key profiles.userid). Must match namedqueries.userid for the queries associated with this event (whine_queries.query_name).</td> > </tr> > <tr> > <td>subject</td> > <td>VARCHAR</td> > <td> </td> > <td>YES</td> > <td> </td> > <td>The Subject of the whine emails.</td> > </tr> > <tr> > <td>body</td> > <td>TEXT</td> > <td> </td> > <td>YES</td> > <td> </td> > <td>Text to appear in the body of the whine emails before the bugs table.</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%'> > <tr> > <th>NAME</th> > <td colspan="5">whine_queries</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">stores named queries, to which a title is given for use in email messages</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr> > <td>id</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td>PRI</td> > <td>A unique ID for this query.</td> > </tr> > <tr> > <td>eventid</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td>MUL</td> > <td>The whine event ID (foreign key whine_events.id).</td> > </tr> > <tr> > <td>query_name</td> > <td>VARCHAR</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>The query name (foreign key namedqueries.name).</td> > </tr> > <tr> > <td>sortkey</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>A key to order the queries for a given event ID.</td> > </tr> > <tr> > <td>onemailperbug</td> > <td>TINYINT</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>1 if a separate email message should be sent for each bug matching the query;0 if a single email should be sent covering all the bugs.</td> > </tr> > <tr> > <td>title</td> > <td>VARCHAR</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>The title displayed for this query in the message.</td> > </tr> > </table> > <br/><br/> > <table border='1' width='75%'> > <tr> > <th>NAME</th> > <td colspan="5">whine_schedules</td> > </tr> > <tr> > <th>TYPE</th> > <td colspan="5">TABLE</td> > </tr> > <tr> > <th>DESCRIPTION</th> > <td colspan="5">specifies the frequency with which an email should be sent to a particular user</td> > </tr> > <tr> > <th>FIELD</th> > <th>TYPE</th> > <th>DEFAULT</th> > <th>NUL</th> > <th>KEY</th> > <th>REMARK</th> > </tr> > <tr> > <td>id</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td>PRI</td> > <td>a unique ID for this whine schedule.</td> > </tr> > <tr> > <td>eventid</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td>MUL</td> > <td>The whine event ID (foreign key whine_events.id).</td> > </tr> > <tr> > <td>run_day</td> > <td>VARCHAR</td> > <td> </td> > <td>YES</td> > <td> </td> > <td>The day on which this whine should run. 'All' means every day. 'MF' means Monday to Friday inclusive. A three letter weekday abbreviation (e.g. Mon)</td> > </tr> > <tr> > <td>run_time</td> > <td>VARCHAR</td> > <td> </td> > <td>YES</td> > <td> </td> > <td>The time and date at which the whine should next be run. NULL if the whine has been changed and not rescheduled yet.</td> > </tr> > <tr> > <td>run_next</td> > <td>DATETIME</td> > <td> </td> > <td>YES</td> > <td bgcolor='#33CC66'>/MUL</td> > <td>the date when the whine schedule will run next</td> > </tr> > <tr> > <td>mailto</td> > <td>MEDIUMINT</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>Either a user ID (foreign key profiles.userid) or group ID (foreign key groups.id) identifying the user or users to whom to send whine messages.</td> > </tr> > <tr> > <td>mailto_type</td> > <td bgcolor='#33CC66'>tinyint(4)/SMALLINT</td> > <td> </td> > <td>NO</td> > <td> </td> > <td>0 if the mailto field is a user ID</td> > </tr> > </table> > <br/><br/> ></body> ></html>
<html> <body> <table border='1'> <tr> <td bgcolor='#FFFF66'>Table/Field exists in bugzilla_3 but not in bugzilla_2_18</td> </tr> <tr> <td bgcolor='#9966FF'>Table/Field exists in bugzilla_2_18 but not in bugzilla_3</td> </tr> <tr> <td bgcolor='#FF0033'>New Field in bugzilla_3 that is set to NOT NULL</td> </tr> <tr> <td bgcolor='#33CC66'>Format 2.18/3 => Similar Fields Between Bugzilla_2_18 and Bugzilla_3 but have different attributes</td> </tr> </table> <br/><br/><br/> <table border='1' width='75%' bgcolor='#FFFF66'> <tr> <th>NAME</th> <td colspan="5">attach_data</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">!! table found in bugzilla_3 but not in bugzilla_2_18 !!</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr bgcolor='#FFFF66'> <td>id</td> <td>MEDIUMINT</td> <td> </td> <td bgcolor='#FF0033'><b>NO</b></td> <td>PRI</td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> <tr bgcolor='#FFFF66'> <td>thedata</td> <td>LONGBLOB</td> <td> </td> <td bgcolor='#FF0033'><b>NO</b></td> <td> </td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> </table> <br/><br/> <table border='1' width='75%'> <tr> <th>NAME</th> <td colspan="5">attachments</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">Users can upload attachments to bugs. An attachment can be marked as a patch. Attachments are stored in the attachments table</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr> <td>attach_id</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td>PRI</td> <td>a unique ID</td> </tr> <tr> <td>bug_id</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td>MUL</td> <td>the bug to which this is attached (foreign key bugs.bug_id)</td> </tr> <tr> <td>creation_ts</td> <td>DATETIME</td> <td> </td> <td>NO</td> <td>MUL</td> <td>the creation time</td> </tr> <tr bgcolor='#FFFF66'> <td>modification_time</td> <td>DATETIME</td> <td> </td> <td>YES</td> <td>MUL</td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> <tr> <td>description</td> <td>MEDIUMTEXT</td> <td> </td> <td>NO</td> <td> </td> <td>a description of the attachment</td> </tr> <tr> <td>mimetype</td> <td>MEDIUMTEXT</td> <td> </td> <td>NO</td> <td> </td> <td>the MIME type of the attachment</td> </tr> <tr> <td>ispatch</td> <td>TINYINT</td> <td> </td> <td>YES</td> <td> </td> <td>non-zero if this attachment is a patch file</td> </tr> <tr> <td>filename</td> <td>VARCHAR</td> <td> </td> <td>NO</td> <td> </td> <td>the filename of the attachment</td> </tr> <tr> <td>submitter_id</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td>MUL</td> <td>the userid of the attachment (foreign key profiles.userid)</td> </tr> <tr> <td>isobsolete</td> <td>TINYINT</td> <td> </td> <td>NO</td> <td> </td> <td>Non-zero if this attachment is marked as</td> </tr> <tr> <td>isprivate</td> <td>TINYINT</td> <td> </td> <td>NO</td> <td> </td> <td>Non-zero if this attachment is private</td> </tr> <tr bgcolor='#FFFF66'> <td>isurl</td> <td>TINYINT</td> <td> </td> <td>YES</td> <td> </td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> <tr> <td>it_id</td> <td>TINYINT</td> <td> </td> <td>YES</td> <td> </td> <td>the id of an attachment in IssueTracker which is a separate system, it allows a bug report to show Bugzillla attachments and IssueTracker attachments in the same list</td> </tr> <tr bgcolor='#9966FF'> <td>thedata</td> <td>longblob</td> <td></td> <td>NO</td> <td></td> <td>!! field in bugzilla_2.18 but not in bugzilla_3 !!</td> </tr> </table> <br/><br/> <table border='1' width='75%'> <tr> <th>NAME</th> <td colspan="5">bug_group_map</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">Which bugs are in which groups.</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr> <td>bug_id</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td>PRI</td> <td>The id of a bug that belongs to some group (foreign key bugs.bug_id)</td> </tr> <tr> <td>group_id</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td>PRI</td> <td>The group id (foreign key groups.id)</td> </tr> </table> <br/><br/> <table border='1' width='75%'> <tr> <th>NAME</th> <td colspan="5">bug_severity</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">The severity values of bugs</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr> <td>id</td> <td>SMALLINT</td> <td> </td> <td>NO</td> <td>PRI</td> <td>a unique ID</td> </tr> <tr> <td>value</td> <td>VARCHAR</td> <td> </td> <td>NO</td> <td>UNI</td> <td>A possible value of the field</td> </tr> <tr bgcolor='#FFFF66'> <td>sortkey</td> <td>SMALLINT</td> <td> </td> <td>YES</td> <td>MUL</td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> <tr bgcolor='#FFFF66'> <td>isactive</td> <td>TINYINT</td> <td>1</td> <td>YES</td> <td> </td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> </table> <br/><br/> <table border='1' width='75%'> <tr> <th>NAME</th> <td colspan="5">bug_status</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">The status values of bugs</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr> <td>id</td> <td>SMALLINT</td> <td> </td> <td>NO</td> <td>PRI</td> <td>a unique ID</td> </tr> <tr> <td>value</td> <td>VARCHAR</td> <td> </td> <td>NO</td> <td>UNI</td> <td>A possible value of the field</td> </tr> <tr> <td>sortkey</td> <td>SMALLINT</td> <td> </td> <td>NO</td> <td bgcolor='#33CC66'>/MUL</td> <td>A number used to determine the order in which values are shown</td> </tr> <tr> <td>isactive</td> <td>TINYINT</td> <td>1</td> <td>NO</td> <td> </td> <td>1 if this value is available in the user interface 0 otherwise</td> </tr> <tr> <td>is_open</td> <td>TINYINT</td> <td>1</td> <td>NO</td> <td> </td> <td>if the bug status is an open state</td> </tr> <tr> <td>description</td> <td>MEDIUMTEXT</td> <td> </td> <td>NO</td> <td> </td> <td>bug status description</td> </tr> </table> <br/><br/> <table border='1' width='75%'> <tr> <th>NAME</th> <td colspan="5">bugs</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">The bugs themselves.</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr> <td>bug_id</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td>PRI</td> <td>bug ID</td> </tr> <tr> <td>assigned_to</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td>MUL</td> <td>The current owner of the bug (foreign key profiles.userid)</td> </tr> <tr> <td>bug_file_loc</td> <td bgcolor='#33CC66'>text/MEDIUMTEXT</td> <td> </td> <td>YES</td> <td> </td> <td>A URL which points to more information about the bug</td> </tr> <tr> <td>bug_severity</td> <td>VARCHAR</td> <td> </td> <td>NO</td> <td>MUL</td> <td>the severity value of a bug. foreign key bug_severity.value</td> </tr> <tr> <td>bug_status</td> <td>VARCHAR</td> <td> </td> <td>NO</td> <td>MUL</td> <td>The workflow status of the bug. foreign key</td> </tr> <tr> <td>creation_ts</td> <td>DATETIME</td> <td> </td> <td>NO</td> <td>MUL</td> <td>The times of the bug creation</td> </tr> <tr> <td>delta_ts</td> <td bgcolor='#33CC66'>timestamp/DATETIME</td> <td> </td> <td>NO</td> <td>MUL</td> <td>The timestamp of the last update. This includes updates to some related tables</td> </tr> <tr> <td>short_desc</td> <td>MEDIUMTEXT</td> <td> </td> <td>NO</td> <td> </td> <td>A short description of the bug</td> </tr> <tr> <td>op_sys</td> <td>VARCHAR</td> <td> </td> <td>NO</td> <td>MUL</td> <td>The operating system on which the bug was observed. foreign key op_sys.value</td> </tr> <tr> <td>priority</td> <td>VARCHAR</td> <td> </td> <td>NO</td> <td>MUL</td> <td>The priority of the bug. foreign key priority.value</td> </tr> <tr> <td>product_id</td> <td>SMALLINT</td> <td> </td> <td>NO</td> <td>MUL</td> <td>The product (foreign key products.id)</td> </tr> <tr> <td>rep_platform</td> <td>VARCHAR</td> <td> </td> <td>NO</td> <td> </td> <td>The platform on which the bug was reported. foreign key rep_platform.value</td> </tr> <tr> <td>reporter</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td>MUL</td> <td>The user who reported this (foreign key profiles.userid)</td> </tr> <tr> <td>version</td> <td>VARCHAR</td> <td> </td> <td>NO</td> <td>MUL</td> <td>The product version (foreign key versions.value)</td> </tr> <tr> <td>component_id</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td>MUL</td> <td>The product component (foreign key components.id)</td> </tr> <tr> <td>resolution</td> <td>VARCHAR</td> <td> </td> <td>YES</td> <td>MUL</td> <td>The bug resolution foreign key resolution.value</td> </tr> <tr> <td>target_milestone</td> <td>VARCHAR</td> <td>---</td> <td>NO</td> <td>MUL</td> <td>The milestone by which this bug should be resolved. (foreign key milestones.value)</td> </tr> <tr> <td>qa_contact</td> <td>MEDIUMINT</td> <td> </td> <td>YES</td> <td>MUL</td> <td>The QA contact (foreign key profiles.userid)</td> </tr> <tr> <td>status_whiteboard</td> <td>MEDIUMTEXT</td> <td> </td> <td bgcolor='#33CC66'>YES/NO</td> <td> </td> <td>This seems to be just a small whiteboard field</td> </tr> <tr> <td>votes</td> <td>MEDIUMINT</td> <td> </td> <td>YES</td> <td>MUL</td> <td>The number of votes</td> </tr> <tr> <td>keywords</td> <td>MEDIUMTEXT</td> <td> </td> <td>YES</td> <td> </td> <td>A set of keywords. Note that this duplicates information in the keywords table.(foreign key keyworddefs.name)</td> </tr> <tr> <td>lastdiffed</td> <td>DATETIME</td> <td> </td> <td>YES</td> <td> </td> <td>The time at which information about this bug changing was last emailed to the cc list</td> </tr> <tr> <td>everconfirmed</td> <td>TINYINT</td> <td> </td> <td>NO</td> <td> </td> <td>1 if this bug has ever been confirmed. This is used for validation of some sort</td> </tr> <tr> <td>reporter_accessible</td> <td>TINYINT</td> <td>1</td> <td>NO</td> <td> </td> <td>1 if the reporter can see this bug (even if in the wrong group) 0 otherwise</td> </tr> <tr> <td>cclist_accessible</td> <td>TINYINT</td> <td>1</td> <td>NO</td> <td> </td> <td>1 if people on the CC list can see this bug (even if in the wrong group);0 otherwise</td> </tr> <tr> <td>estimated_time</td> <td>DECIMAL</td> <td bgcolor='#33CC66'>/0.00</td> <td bgcolor='#33CC66'>2)"/NO</td> <td> </td> <td>The original estimate of the total effort required to fix this bug (in hours)</td> </tr> <tr> <td>remaining_time</td> <td>DECIMAL</td> <td bgcolor='#33CC66'>/0.00</td> <td bgcolor='#33CC66'>2)"/NO</td> <td> </td> <td>The current estimate of the remaining effort required to fix this bug (in hours)</td> </tr> <tr bgcolor='#FFFF66'> <td>deadline</td> <td>DATETIME</td> <td> </td> <td>YES</td> <td> </td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> <tr> <td>alias</td> <td>VARCHAR</td> <td> </td> <td>YES</td> <td bgcolor='#33CC66'>/UNI</td> <td>An alias for the bug which can be used instead of the bug number.</td> </tr> <tr> <td>cust_facing</td> <td>VARCHAR</td> <td> </td> <td>YES</td> <td> </td> <td>used to mark extra status information in bug reports and is used by certain groups</td> </tr> <tr> <td>devel_whiteboard</td> <td>VARCHAR</td> <td> </td> <td>YES</td> <td> </td> <td>used to mark extra status information in bug reports and used by devel group</td> </tr> <tr> <td>fixed_in</td> <td>VARCHAR</td> <td> </td> <td>YES</td> <td> </td> <td> it is a text field to enter version that a bug has been fixed in, it is not strictly enforced, (examples: rpm package version, a release version)</td> </tr> <tr> <td>internal_whiteboard</td> <td>VARCHAR</td> <td> </td> <td>YES</td> <td> </td> <td>used to mark extra status information in bug reports and used by bz group</td> </tr> <tr> <td>qa_whiteboard</td> <td>VARCHAR</td> <td> </td> <td>YES</td> <td> </td> <td>used to mark extra status information in bug reports and used by qa group</td> </tr> </table> <br/><br/> <table border='1' width='75%'> <tr> <th>NAME</th> <td colspan="5">bugs_activity</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">Activity on the bugs table.</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr> <td>bug_id</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td>MUL</td> <td>Which bug (foreign key bugs.bug_id)</td> </tr> <tr> <td>attach_id</td> <td>MEDIUMINT</td> <td> </td> <td>YES</td> <td>MUL</td> <td>If the change was to an attachment (foreign key attachments.attach_id)</td> </tr> <tr> <td>who</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td>MUL</td> <td>Which user (foreign key profiles.userid)</td> </tr> <tr> <td>bug_when</td> <td>DATETIME</td> <td> </td> <td>NO</td> <td>MUL</td> <td>When was the change made?</td> </tr> <tr> <td>fieldid</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td>MUL</td> <td>What was the fieldid? (foreign key fielddefs.id)</td> </tr> <tr> <td>added</td> <td>VARCHAR</td> <td> </td> <td>YES</td> <td> </td> <td>The new value of this field</td> </tr> <tr> <td>removed</td> <td>VARCHAR</td> <td> </td> <td>YES</td> <td> </td> <td>The old value of this field</td> </tr> </table> <br/><br/> <table border='1' width='75%'> <tr> <th>NAME</th> <td colspan="5">bz_it_map</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">Mapping bugzilla bug ids with issue tracker ids.</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr> <td>bz_id</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td bgcolor='#33CC66'>PRI/MUL</td> <td>Bugzilla bug id (foreign key bugs.bug_id)</td> </tr> <tr> <td>it_id</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td> </td> <td>Issue tracker id</td> </tr> <tr> <td>it_score</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td> </td> <td>Issue tracker score</td> </tr> </table> <br/><br/> <table border='1' width='75%' bgcolor='#FFFF66'> <tr> <th>NAME</th> <td colspan="5">bz_schema</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">!! table found in bugzilla_3 but not in bugzilla_2_18 !!</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr bgcolor='#FFFF66'> <td>schema_data</td> <td>LONGBLOB</td> <td> </td> <td bgcolor='#FF0033'><b>NO</b></td> <td> </td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> <tr bgcolor='#FFFF66'> <td>version</td> <td>DECIMAL</td> <td> </td> <td bgcolor='#FF0033'><b>NO</b></td> <td> </td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> </table> <br/><br/> <table border='1' width='75%'> <tr> <th>NAME</th> <td colspan="5">category_group_map</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">Which groups does a user have to be in to view chart data in a given category.</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr> <td>category_id</td> <td>SMALLINT</td> <td> </td> <td>NO</td> <td>PRI</td> <td>The series category (foreign key series_categories.id)</td> </tr> <tr> <td>group_id</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td>PRI</td> <td>Users who have asked to receive email when a bug changes (foreign key groups.id)</td> </tr> </table> <br/><br/> <table border='1' width='75%'> <tr> <th>NAME</th> <td colspan="5">cc</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">Users who have asked to receive email when a bug changes.</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr> <td>bug_id</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td>PRI</td> <td>The bug (foreign key bugs.bug_id)</td> </tr> <tr> <td>who</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td>PRI</td> <td>The user (foreign key profiles.userid)</td> </tr> </table> <br/><br/> <table border='1' width='75%' bgcolor='#FFFF66'> <tr> <th>NAME</th> <td colspan="5">classifications</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">!! table found in bugzilla_3 but not in bugzilla_2_18 !!</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr bgcolor='#FFFF66'> <td>id</td> <td>SMALLINT</td> <td> </td> <td bgcolor='#FF0033'><b>NO</b></td> <td>PRI</td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> <tr bgcolor='#FFFF66'> <td>name</td> <td>VARCHAR</td> <td> </td> <td bgcolor='#FF0033'><b>NO</b></td> <td>UNI</td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> <tr bgcolor='#FFFF66'> <td>description</td> <td>MEDIUMTEXT</td> <td> </td> <td>YES</td> <td> </td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> <tr bgcolor='#FFFF66'> <td>sortkey</td> <td>SMALLINT</td> <td> </td> <td bgcolor='#FF0033'><b>NO</b></td> <td> </td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> </table> <br/><br/> <table border='1' width='75%'> <tr> <th>NAME</th> <td colspan="5">component_cc</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">Maps every component to its users in the cclist, one user per record</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr> <td>user_id</td> <td>MEDIUMINT</td> <td> </td> <td bgcolor='#33CC66'>YES/NO</td> <td bgcolor='#33CC66'>MUL/PRI</td> <td>The user id (foreign key profiles.userid)</td> </tr> <tr> <td>component_id</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td bgcolor='#33CC66'>MUL/PRI</td> <td>The component id (foreign key components.id)</td> </tr> </table> <br/><br/> <table border='1' width='75%'> <tr> <th>NAME</th> <td colspan="5">components</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">the work for each product is divided into the components of that product, each component is represented by a row in the componenets table</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr> <td>id</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td>PRI</td> <td>The component id.</td> </tr> <tr> <td>name</td> <td>VARCHAR</td> <td> </td> <td>NO</td> <td>MUL</td> <td>The component name</td> </tr> <tr> <td>product_id</td> <td>SMALLINT</td> <td> </td> <td>NO</td> <td>MUL</td> <td>The product (foreign key products.id)</td> </tr> <tr> <td>initialowner</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td>MUL</td> <td>The default initial owner of bugs in this component. On component creation (foreign key profiles.userid)</td> </tr> <tr> <td>initialqacontact</td> <td>MEDIUMINT</td> <td> </td> <td>YES</td> <td>MUL</td> <td>The initial qa_contact field for bugs of this component. Note that the use of the qa_contact field is optional (foreign key profiles.userid) </td> </tr> <tr> <td>description</td> <td>MEDIUMTEXT</td> <td> </td> <td>NO</td> <td> </td> <td>A description of the component.</td> </tr> <tr> <td>initialcclist</td> <td>MEDIUMTEXT</td> <td> </td> <td>YES</td> <td> </td> <td>is a string data type with a ':' separated list of bugzilla user id's to allow multiple people to automatically get cc'ed when bugs were created for a componet</td> </tr> </table> <br/><br/> <table border='1' width='75%'> <tr> <th>NAME</th> <td colspan="5">dependencies</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">Which bugs depend on other bugs.</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr> <td>blocked</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td>MUL</td> <td>Which bug is blocked (foreign key bugs.bug_id)</td> </tr> <tr> <td>dependson</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td>MUL</td> <td>Which bug does it depend on (foreign key bugs.bug_id)</td> </tr> </table> <br/><br/> <table border='1' width='75%'> <tr> <th>NAME</th> <td colspan="5">duplicates</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">Which bugs are duplicates of which other bugs.</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr> <td>dupe_of</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td>MUL</td> <td>The bug which is duplicated (foreign key bugs.bug_id)</td> </tr> <tr> <td>dupe</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td>PRI</td> <td>The duplicate bug (foreign key bugs.bug_id)</td> </tr> </table> <br/><br/> <table border='1' width='75%' bgcolor='#FFFF66'> <tr> <th>NAME</th> <td colspan="5">email_setting</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">!! table found in bugzilla_3 but not in bugzilla_2_18 !!</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr bgcolor='#FFFF66'> <td>user_id</td> <td>MEDIUMINT</td> <td> </td> <td bgcolor='#FF0033'><b>NO</b></td> <td>PRI</td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> <tr bgcolor='#FFFF66'> <td>relationship</td> <td>TINYINT</td> <td> </td> <td bgcolor='#FF0033'><b>NO</b></td> <td>PRI</td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> <tr bgcolor='#FFFF66'> <td>event</td> <td>TINYINT</td> <td> </td> <td bgcolor='#FF0033'><b>NO</b></td> <td>PRI</td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> </table> <br/><br/> <table border='1' width='75%'> <tr> <th>NAME</th> <td colspan="5">ext_bz_bug_map</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">has the links of our bug ids to external bug ids to that allow bugzilla ids to have references to external bugs in outside bug trackers</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr> <td>bug_id</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td bgcolor='#33CC66'>PRI/MUL</td> <td>bugzilla bug id (foreign key bugs.bug_id)</td> </tr> <tr> <td>ext_bz_id</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td bgcolor='#33CC66'>PRI/MUL</td> <td>id for external bugzilla (foreign key external_bugzilla.id)</td> </tr> <tr> <td>ext_bz_bug_id</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td> </td> <td>external bugzilla bug id</td> </tr> </table> <br/><br/> <table border='1' width='75%'> <tr> <th>NAME</th> <td colspan="5">external_bugzilla</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">lists the trackers we know about</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr> <td>id</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td>PRI</td> <td>the tracker id</td> </tr> <tr> <td>url</td> <td>VARCHAR</td> <td> </td> <td>NO</td> <td> </td> <td>the url of the tracker</td> </tr> <tr> <td>description</td> <td>VARCHAR</td> <td> </td> <td>NO</td> <td> </td> <td>description of the tracker</td> </tr> <tr> <td>full_url</td> <td>VARCHAR</td> <td> </td> <td>YES</td> <td> </td> <td>the full url of the tracker</td> </tr> <tr> <td>is_bz</td> <td>TINYINT</td> <td> </td> <td>YES</td> <td> </td> <td>is it a bugzilla tracker</td> </tr> </table> <br/><br/> <table border='1' width='75%'> <tr> <th>NAME</th> <td colspan="5">fielddefs</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">The fields of a bug.</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr bgcolor='#FFFF66'> <td>id</td> <td>MEDIUMINT</td> <td> </td> <td bgcolor='#FF0033'><b>NO</b></td> <td>PRI</td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> <tr> <td>name</td> <td>VARCHAR</td> <td> </td> <td>NO</td> <td>UNI</td> <td>field name or definition (some fields are names of other tables or of fields in other tables)</td> </tr> <tr bgcolor='#FFFF66'> <td>type</td> <td>SMALLINT</td> <td> </td> <td>YES</td> <td> </td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> <tr bgcolor='#FFFF66'> <td>custom</td> <td>TINYINT</td> <td> </td> <td>YES</td> <td> </td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> <tr> <td>description</td> <td bgcolor='#33CC66'>mediumtext/TINYTEXT</td> <td> </td> <td>NO</td> <td> </td> <td>long description</td> </tr> <tr> <td>mailhead</td> <td>TINYINT</td> <td> </td> <td>NO</td> <td> </td> <td>whether or not to send the field description in mail notifications.</td> </tr> <tr> <td>sortkey</td> <td>SMALLINT</td> <td> </td> <td>NO</td> <td>MUL</td> <td>the order of fields in mail notifications.</td> </tr> <tr bgcolor='#FFFF66'> <td>obsolete</td> <td>TINYINT</td> <td> </td> <td>YES</td> <td> </td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> <tr bgcolor='#FFFF66'> <td>enter_bug</td> <td>TINYINT</td> <td> </td> <td>YES</td> <td> </td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> <tr bgcolor='#9966FF'> <td>fieldid</td> <td>mediumint(9)</td> <td></td> <td>NO</td> <td>PRI</td> <td>!! field in bugzilla_2.18 but not in bugzilla_3 !!</td> </tr> </table> <br/><br/> <table border='1' width='75%'> <tr> <th>NAME</th> <td colspan="5">flagexclusions</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">It may be forbidden to set a given flag on an item (bug or attachment) if that item is in a given product or component. This table records such exclusions.</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr> <td>type_id</td> <td>SMALLINT</td> <td> </td> <td>NO</td> <td>MUL</td> <td>The flag type. (foreign key flagtypes.id)</td> </tr> <tr> <td>product_id</td> <td>SMALLINT</td> <td> </td> <td>YES</td> <td>MUL</td> <td>The product (foreign key products.id)</td> </tr> <tr> <td>component_id</td> <td>MEDIUMINT</td> <td> </td> <td>YES</td> <td>MUL</td> <td>The component (foreign key components.id)</td> </tr> </table> <br/><br/> <table border='1' width='75%'> <tr> <th>NAME</th> <td colspan="5">flaginclusions</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">An item (bug or attachment) may be required to be in a given product or component for a flag to be set. This table records such requirements.</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr> <td>type_id</td> <td>SMALLINT</td> <td> </td> <td>NO</td> <td>MUL</td> <td>The flag type. (foreign key flagtypes.id)</td> </tr> <tr> <td>product_id</td> <td>SMALLINT</td> <td> </td> <td>YES</td> <td>MUL</td> <td>The product (foreign key products.id)</td> </tr> <tr> <td>component_id</td> <td>MEDIUMINT</td> <td> </td> <td>YES</td> <td>MUL</td> <td>The component (foreign key components.id)</td> </tr> </table> <br/><br/> <table border='1' width='75%'> <tr> <th>NAME</th> <td colspan="5">flags</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">This table records the flags set on bugs or attachments.</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr> <td>id</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td>PRI</td> <td>A unique ID.</td> </tr> <tr> <td>type_id</td> <td>SMALLINT</td> <td> </td> <td>NO</td> <td>MUL</td> <td>The flag type. (foreign key flagtypes.id)</td> </tr> <tr> <td>status</td> <td>CHAR</td> <td> </td> <td>NO</td> <td> </td> <td>+ (granted)</td> </tr> <tr> <td>bug_id</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td>MUL</td> <td>bug. (foreign key bugs.bug_id)</td> </tr> <tr> <td>attach_id</td> <td>MEDIUMINT</td> <td> </td> <td>YES</td> <td>MUL</td> <td>The attachment (foreign key attachments.attach_id)</td> </tr> <tr> <td>creation_date</td> <td>DATETIME</td> <td> </td> <td>NO</td> <td> </td> <td>The date the flag was created.</td> </tr> <tr> <td>modification_date</td> <td>DATETIME</td> <td> </td> <td>YES</td> <td> </td> <td>The date the flag was most recently modified or created</td> </tr> <tr> <td>setter_id</td> <td>MEDIUMINT</td> <td> </td> <td>YES</td> <td>MUL</td> <td>The ID of the user who created (foreign key profiles.userid)</td> </tr> <tr> <td>requestee_id</td> <td>MEDIUMINT</td> <td> </td> <td>YES</td> <td>MUL</td> <td>The ID of the user to whom this request flag is addressed (foreign key profiles.userid)</td> </tr> <tr> <td>is_active</td> <td>TINYINT</td> <td>1</td> <td>NO</td> <td> </td> <td> when a flag is created for the first time on a bug report is_active is set to 1 when the flag is deleted, the row is not really deleted, the is_active value is set to 0,if a flag is then reinstated later for a bug, it just gets is_active reset to 1 again</td> </tr> </table> <br/><br/> <table border='1' width='75%'> <tr> <th>NAME</th> <td colspan="5">flagtypes</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">The types of flags available for bugs and attachments. See the notes on flags.</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr> <td>id</td> <td>SMALLINT</td> <td> </td> <td>NO</td> <td>PRI</td> <td>The flag type ID</td> </tr> <tr> <td>name</td> <td>VARCHAR</td> <td> </td> <td>NO</td> <td> </td> <td>The short flag name</td> </tr> <tr> <td>description</td> <td bgcolor='#33CC66'>text/MEDIUMTEXT</td> <td> </td> <td bgcolor='#33CC66'>YES/NO</td> <td> </td> <td>The description of the flag</td> </tr> <tr> <td>cc_list</td> <td>VARCHAR</td> <td> </td> <td>YES</td> <td> </td> <td>A string containing email addresses to which notification of requests for this flag should be sent. This is filtered using the groups system before messages are actually sent</td> </tr> <tr> <td>target_type</td> <td>CHAR</td> <td>b</td> <td>NO</td> <td> </td> <td>type for attachment flags</td> </tr> <tr> <td>is_active</td> <td>TINYINT</td> <td>1</td> <td>NO</td> <td> </td> <td>1 if the flag appears in the UI and can be set; 0 otherwise.</td> </tr> <tr> <td>is_requestable</td> <td>TINYINT</td> <td> </td> <td>NO</td> <td> </td> <td>1 if the flag may be requested; 0 otherwise.</td> </tr> <tr> <td>is_requesteeble</td> <td>TINYINT</td> <td> </td> <td>NO</td> <td> </td> <td>1 if a request for this flag may be aimed at a particular user; 0 otherwise</td> </tr> <tr> <td>is_multiplicable</td> <td>TINYINT</td> <td> </td> <td>NO</td> <td> </td> <td>1 if multiple instances of this flag may be set on the same item; 0 otherwise.</td> </tr> <tr> <td>sortkey</td> <td>SMALLINT</td> <td> </td> <td>NO</td> <td> </td> <td>An integer used for sorting flags for display.</td> </tr> <tr> <td>grant_group_id</td> <td>MEDIUMINT</td> <td> </td> <td>YES</td> <td>MUL</td> <td>Group membership required to grant this flag. (foreign key groups.id)</td> </tr> <tr> <td>request_group_id</td> <td>MEDIUMINT</td> <td> </td> <td>YES</td> <td> </td> <td>Group membership required to request this flag. (foreign key groups.id)</td> </tr> <tr> <td>view_group_id</td> <td>MEDIUMINT</td> <td> </td> <td>YES</td> <td>MUL</td> <td>corresponds to the groups table id designating which group a person needs to be in to see that flag choice in a bug report (foreign key groups.id)</td> </tr> </table> <br/><br/> <table border='1' width='75%'> <tr> <th>NAME</th> <td colspan="5">group_control_map</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">This table describes the relationship of groups to products (whether membership in a given group is required for entering or editing a bug in a given product).</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr> <td>group_id</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td>PRI</td> <td>The group. (foreign key groups.id)</td> </tr> <tr> <td>product_id</td> <td>SMALLINT</td> <td> </td> <td>NO</td> <td>PRI</td> <td>The product. (foreign key products.id)</td> </tr> <tr> <td>entry</td> <td>TINYINT</td> <td> </td> <td>NO</td> <td> </td> <td>1 if membership of this group is required to enter a bug in this product; 0 otherwise.</td> </tr> <tr> <td>membercontrol</td> <td>TINYINT</td> <td> </td> <td>NO</td> <td> </td> <td>Determines what control members of this group have over whether a bug for this product is placed in this group</td> </tr> <tr> <td>othercontrol</td> <td>TINYINT</td> <td> </td> <td>NO</td> <td> </td> <td>Determines what control non-group-members have over whether a new bug for this product is placed in this group.</td> </tr> <tr> <td>canedit</td> <td>TINYINT</td> <td> </td> <td>NO</td> <td> </td> <td>1 if membership of this group is required to edit a bug in this product; 0 otherwise.</td> </tr> <tr bgcolor='#FFFF66'> <td>editcomponents</td> <td>TINYINT</td> <td> </td> <td>YES</td> <td> </td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> <tr bgcolor='#FFFF66'> <td>editbugs</td> <td>TINYINT</td> <td> </td> <td>YES</td> <td> </td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> <tr bgcolor='#FFFF66'> <td>canconfirm</td> <td>TINYINT</td> <td> </td> <td>YES</td> <td> </td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> </table> <br/><br/> <table border='1' width='75%'> <tr> <th>NAME</th> <td colspan="5">group_group_map</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">Groups can be configured such that membership of one group automatically confers rights over some other groups. This table records that configuration</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr> <td>member_id</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td bgcolor='#33CC66'>PRI/MUL</td> <td>The group whose membership grants membership or bless privilege for another group (foreign key groups.id)</td> </tr> <tr> <td>grantor_id</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td bgcolor='#33CC66'>PRI/MUL</td> <td>The group whose membership or bless privilege is automatically granted.(foreign key groups.id)</td> </tr> <tr bgcolor='#FFFF66'> <td>grant_type</td> <td>TINYINT</td> <td> </td> <td>YES</td> <td> </td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> <tr> <td>isbless</td> <td>TINYINT</td> <td> </td> <td>NO</td> <td> </td> <td> is set to 1 or 0 based on whether people belonging to that group can bless others into that group gives them admin rights to put people in that group</td> </tr> </table> <br/><br/> <table border='1' width='75%'> <tr> <th>NAME</th> <td colspan="5">groups</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">This table describes a number of user groups. Each group allows its members to perform a restricted activity. </td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr> <td>id</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td>PRI</td> <td>The group id.</td> </tr> <tr> <td>name</td> <td>VARCHAR</td> <td> </td> <td>NO</td> <td>UNI</td> <td>A short name for the group.</td> </tr> <tr> <td>description</td> <td bgcolor='#33CC66'>text/MEDIUMTEXT</td> <td> </td> <td>NO</td> <td> </td> <td>A long description of the group.</td> </tr> <tr> <td>isbuggroup</td> <td>TINYINT</td> <td> </td> <td>NO</td> <td> </td> <td>1 if this is a group controlling access to a set of bugs.</td> </tr> <tr> <td>userregexp</td> <td>VARCHAR</td> <td> </td> <td>YES</td> <td> </td> <td>a regexp used to determine membership of new users.</td> </tr> <tr> <td>isactive</td> <td>TINYINT</td> <td>1</td> <td>NO</td> <td> </td> <td>1 if bugs can be added to this group; 0 otherwise.</td> </tr> <tr bgcolor='#FFFF66'> <td>icon_url</td> <td>TINYTEXT</td> <td> </td> <td>YES</td> <td> </td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> <tr> <td>contract</td> <td>TINYINT</td> <td> </td> <td>YES</td> <td> </td> <td>remnants of an old RH feature where a group was designated</td> </tr> <tr> <td>last_changed</td> <td>DATETIME</td> <td> </td> <td>NO</td> <td> </td> <td>the date when a group had its attributes changed last, BZ uses the date to determine whether a persons groups permissions needs to be re-assessed or re-derived as Bugzilla considers it</td> </tr> </table> <br/><br/> <table border='1' width='75%'> <tr> <th>NAME</th> <td colspan="5">keyworddefs</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">Names and definitions of the keywords.</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr> <td>id</td> <td>SMALLINT</td> <td> </td> <td>NO</td> <td>PRI</td> <td>A unique number identifying this keyword.</td> </tr> <tr> <td>name</td> <td>VARCHAR</td> <td> </td> <td>NO</td> <td>UNI</td> <td>The keyword itself.</td> </tr> <tr> <td>description</td> <td>MEDIUMTEXT</td> <td> </td> <td>YES</td> <td> </td> <td>The meaning of the keyword.</td> </tr> </table> <br/><br/> <table border='1' width='75%'> <tr> <th>NAME</th> <td colspan="5">keywords</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">Bugs may have keywords. This table defines which bugs have which keywords. The keywords are defined in the keyworddefs table.</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr> <td>bug_id</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td>PRI</td> <td>The bug (foreign key bugs.bug_id)</td> </tr> <tr> <td>keywordid</td> <td>SMALLINT</td> <td> </td> <td>NO</td> <td>PRI</td> <td>The keyword ID (foreign key keyworddefs.id)</td> </tr> </table> <br/><br/> <table border='1' width='75%'> <tr> <th>NAME</th> <td colspan="5">logincookies</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">Bugzilla generates a cookie each time a user logs in, and uses it for subsequent authentication. The cookies generated are stored in this table.</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr> <td>cookie</td> <td>VARCHAR</td> <td> </td> <td>NO</td> <td>PRI</td> <td>The cookie</td> </tr> <tr> <td>userid</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td>MUL</td> <td>The user id; (foreign key profiles.userid)</td> </tr> <tr bgcolor='#FFFF66'> <td>ipaddr</td> <td>VARCHAR</td> <td> </td> <td>YES</td> <td> </td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> <tr> <td>lastused</td> <td bgcolor='#33CC66'>timestamp/DATETIME</td> <td> </td> <td>NO</td> <td>MUL</td> <td>The timestamp of this login.</td> </tr> <tr> <td>session</td> <td>VARCHAR</td> <td> </td> <td>NO</td> <td> </td> <td>series of user login cookies</td> </tr> </table> <br/><br/> <table border='1' width='75%'> <tr> <th>NAME</th> <td colspan="5">longdescs</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">Each bug has a number of comments associated with it. These are stored individually in this table.</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr bgcolor='#FFFF66'> <td>comment_id</td> <td>MEDIUMINT</td> <td> </td> <td bgcolor='#FF0033'><b>NO</b></td> <td>PRI</td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> <tr> <td>bug_id</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td>MUL</td> <td>bug (foreign key bugs.bug_id)</td> </tr> <tr> <td>who</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td>MUL</td> <td>the user who added this text (foreign key profiles.userid)</td> </tr> <tr> <td>bug_when</td> <td>DATETIME</td> <td> </td> <td>NO</td> <td>MUL</td> <td>when the text was added</td> </tr> <tr> <td>work_time</td> <td>DECIMAL</td> <td bgcolor='#33CC66'>/0.00</td> <td bgcolor='#33CC66'>2)"/NO</td> <td> </td> <td>Number of hours worked on this bug (for time tracking purposes).</td> </tr> <tr> <td>thetext</td> <td>MEDIUMTEXT</td> <td> </td> <td bgcolor='#33CC66'>YES/NO</td> <td bgcolor='#33CC66'>/MUL</td> <td>the text itself.</td> </tr> <tr> <td>isprivate</td> <td>TINYINT</td> <td> </td> <td>NO</td> <td> </td> <td>Non-zero if this comment is private</td> </tr> <tr bgcolor='#FFFF66'> <td>already_wrapped</td> <td>TINYINT</td> <td> </td> <td>YES</td> <td> </td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> <tr bgcolor='#FFFF66'> <td>type</td> <td>SMALLINT</td> <td> </td> <td>YES</td> <td> </td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> <tr bgcolor='#FFFF66'> <td>extra_data</td> <td>VARCHAR</td> <td> </td> <td>YES</td> <td> </td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> <tr> <td>public_in_it</td> <td>TINYINT</td> <td> </td> <td>YES</td> <td> </td> <td>when a bug has an IssueTracker ID attached to it, Bugzilla will send any comments to each IssueTracker as well using XMLRPC so a person can check a box on BZ that says whether that comment should be public or private in the IssueTracker report and that value is also stored in the longdescs table</td> </tr> </table> <br/><br/> <table border='1' width='75%'> <tr> <th>NAME</th> <td colspan="5">milestones</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">Products may have milestones defined. The intention is that a milestone should be a point in a project at which a set of bugs has been resolved</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr bgcolor='#FFFF66'> <td>id</td> <td>MEDIUMINT</td> <td> </td> <td bgcolor='#FF0033'><b>NO</b></td> <td>PRI</td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> <tr> <td>product_id</td> <td>SMALLINT</td> <td> </td> <td>NO</td> <td bgcolor='#33CC66'>PRI/MUL</td> <td>The product (foreign key products.id)</td> </tr> <tr> <td>value</td> <td>VARCHAR</td> <td> </td> <td>NO</td> <td> </td> <td>The name of the milestone (e.g. 3.1 RTM)</td> </tr> <tr> <td>sortkey</td> <td>SMALLINT</td> <td> </td> <td>NO</td> <td> </td> <td>A number used for sorting milestones for a given product.</td> </tr> </table> <br/><br/> <table border='1' width='75%'> <tr> <th>NAME</th> <td colspan="5">namedqueries</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">Users can name queries. Links to named query pages appear in a navigation footer bar on most Bugzilla pages. A query named (Default query) is a user default query</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr bgcolor='#FFFF66'> <td>id</td> <td>MEDIUMINT</td> <td> </td> <td bgcolor='#FF0033'><b>NO</b></td> <td>PRI</td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> <tr> <td>userid</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td bgcolor='#33CC66'>PRI/MUL</td> <td>The user whose query this is (foreign key profiles.userid)</td> </tr> <tr> <td>name</td> <td>VARCHAR</td> <td> </td> <td>NO</td> <td> </td> <td>The name of the query.</td> </tr> <tr> <td>query</td> <td>MEDIUMTEXT</td> <td> </td> <td>NO</td> <td> </td> <td>The query (text to append to the query page URL).</td> </tr> <tr bgcolor='#FFFF66'> <td>query_type</td> <td>TINYINT</td> <td> </td> <td>YES</td> <td> </td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> <tr> <td>public</td> <td>TINYINT</td> <td> </td> <td>NO</td> <td> </td> <td>public is whether the query can be shared with others if others know the right query name</td> </tr> <tr bgcolor='#9966FF'> <td>linkinfooter</td> <td>tinyint(4)</td> <td></td> <td>NO</td> <td></td> <td>!! field in bugzilla_2.18 but not in bugzilla_3 !!</td> </tr> </table> <br/><br/> <table border='1' width='75%' bgcolor='#FFFF66'> <tr> <th>NAME</th> <td colspan="5">namedqueries_link_in_footer</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">!! table found in bugzilla_3 but not in bugzilla_2_18 !!</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr bgcolor='#FFFF66'> <td>namedquery_id</td> <td>MEDIUMINT</td> <td> </td> <td bgcolor='#FF0033'><b>NO</b></td> <td>PRI</td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> <tr bgcolor='#FFFF66'> <td>user_id</td> <td>MEDIUMINT</td> <td> </td> <td bgcolor='#FF0033'><b>NO</b></td> <td>PRI</td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> </table> <br/><br/> <table border='1' width='75%' bgcolor='#FFFF66'> <tr> <th>NAME</th> <td colspan="5">namedquery_group_map</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">!! table found in bugzilla_3 but not in bugzilla_2_18 !!</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr bgcolor='#FFFF66'> <td>namedquery_id</td> <td>MEDIUMINT</td> <td> </td> <td bgcolor='#FF0033'><b>NO</b></td> <td>PRI</td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> <tr bgcolor='#FFFF66'> <td>group_id</td> <td>MEDIUMINT</td> <td> </td> <td bgcolor='#FF0033'><b>NO</b></td> <td>MUL</td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> </table> <br/><br/> <table border='1' width='75%'> <tr> <th>NAME</th> <td colspan="5">op_sys</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">the possible values of the operating system field of a bug</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr> <td>id</td> <td bgcolor='#33CC66'>tinyint(4)/SMALLINT</td> <td> </td> <td>NO</td> <td>PRI</td> <td>a unique ID.</td> </tr> <tr> <td>value</td> <td>VARCHAR</td> <td> </td> <td>NO</td> <td>UNI</td> <td>A possible value of the field</td> </tr> <tr bgcolor='#FFFF66'> <td>sortkey</td> <td>SMALLINT</td> <td> </td> <td>YES</td> <td>MUL</td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> <tr bgcolor='#FFFF66'> <td>isactive</td> <td>TINYINT</td> <td>1</td> <td>YES</td> <td> </td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> </table> <br/><br/> <table border='1' width='75%'> <tr> <th>NAME</th> <td colspan="5">priority</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">the possible values of the priority field of a bug</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr> <td>id</td> <td bgcolor='#33CC66'>tinyint(4)/SMALLINT</td> <td> </td> <td>NO</td> <td>PRI</td> <td>a unique ID.</td> </tr> <tr> <td>value</td> <td>VARCHAR</td> <td> </td> <td>NO</td> <td>UNI</td> <td>A possible value of the field</td> </tr> <tr bgcolor='#FFFF66'> <td>sortkey</td> <td>SMALLINT</td> <td> </td> <td>YES</td> <td>MUL</td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> <tr bgcolor='#FFFF66'> <td>isactive</td> <td>TINYINT</td> <td>1</td> <td>YES</td> <td> </td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> </table> <br/><br/> <table border='1' width='75%'> <tr> <th>NAME</th> <td colspan="5">products</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">The work managed by Bugzilla is divided into products</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr> <td>id</td> <td>SMALLINT</td> <td> </td> <td>NO</td> <td>PRI</td> <td>The product ID.</td> </tr> <tr> <td>name</td> <td>VARCHAR</td> <td> </td> <td>NO</td> <td>UNI</td> <td>The product name.</td> </tr> <tr bgcolor='#FFFF66'> <td>classification_id</td> <td>SMALLINT</td> <td>1</td> <td>YES</td> <td> </td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> <tr> <td>description</td> <td>MEDIUMTEXT</td> <td> </td> <td>YES</td> <td> </td> <td>The description of the product</td> </tr> <tr> <td>milestoneurl</td> <td bgcolor='#33CC66'>varchar(2000)/TINYTEXT</td> <td> </td> <td bgcolor='#33CC66'>YES/NO</td> <td> </td> <td>The URL of a document describing the product milestones.</td> </tr> <tr> <td>disallownew</td> <td>TINYINT</td> <td> </td> <td>NO</td> <td> </td> <td>New bugs can only be created for this product if this is 0.</td> </tr> <tr> <td>votesperuser</td> <td>SMALLINT</td> <td> </td> <td>NO</td> <td> </td> <td>Total votes which a single user has for bugs of this product.</td> </tr> <tr> <td>maxvotesperbug</td> <td>SMALLINT</td> <td>10000</td> <td>NO</td> <td> </td> <td>Maximum number of votes which a bug may have.</td> </tr> <tr> <td>votestoconfirm</td> <td>SMALLINT</td> <td> </td> <td>NO</td> <td> </td> <td>How many votes are required for this bug to become NEW.</td> </tr> <tr> <td>defaultmilestone</td> <td>VARCHAR</td> <td>---</td> <td>NO</td> <td> </td> <td>The default milestone for a new bug.</td> </tr> <tr> <td>depends</td> <td>TINYINT</td> <td> </td> <td>YES</td> <td> </td> <td>remnant of old interaction with another tool</td> </tr> </table> <br/><br/> <table border='1' width='75%' bgcolor='#FFFF66'> <tr> <th>NAME</th> <td colspan="5">profile_setting</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">!! table found in bugzilla_3 but not in bugzilla_2_18 !!</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr bgcolor='#FFFF66'> <td>user_id</td> <td>MEDIUMINT</td> <td> </td> <td bgcolor='#FF0033'><b>NO</b></td> <td>PRI</td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> <tr bgcolor='#FFFF66'> <td>setting_name</td> <td>VARCHAR</td> <td> </td> <td bgcolor='#FF0033'><b>NO</b></td> <td>PRI</td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> <tr bgcolor='#FFFF66'> <td>setting_value</td> <td>VARCHAR</td> <td> </td> <td bgcolor='#FF0033'><b>NO</b></td> <td> </td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> </table> <br/><br/> <table border='1' width='75%'> <tr> <th>NAME</th> <td colspan="5">profiles</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">Bugzilla has users. Each user is represented by one row in the profiles table. Each user is referred by a number (profiles.userid) and an email address (profiles.login_name).</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr> <td>userid</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td>PRI</td> <td>user id</td> </tr> <tr> <td>login_name</td> <td>VARCHAR</td> <td> </td> <td>NO</td> <td>UNI</td> <td>The user's email address. Used when logging in or providing mailto: links.</td> </tr> <tr> <td>cryptpassword</td> <td>VARCHAR</td> <td> </td> <td>YES</td> <td> </td> <td>The user's password. The Perl function crypt is used.</td> </tr> <tr> <td>realname</td> <td>VARCHAR</td> <td> </td> <td bgcolor='#33CC66'>YES/NO</td> <td> </td> <td>The user's real name.</td> </tr> <tr> <td>disabledtext</td> <td>MEDIUMTEXT</td> <td> </td> <td>YES</td> <td> </td> <td>If non-empty</td> </tr> <tr bgcolor='#FFFF66'> <td>disable_mail</td> <td>TINYINT</td> <td> </td> <td>YES</td> <td> </td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> <tr> <td>mybugslink</td> <td>TINYINT</td> <td>1</td> <td>NO</td> <td> </td> <td>indicates whether a 'My Bugs' link should appear at the bottom of each page.</td> </tr> <tr bgcolor='#FFFF66'> <td>extern_id</td> <td>VARCHAR</td> <td> </td> <td>YES</td> <td> </td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> <tr> <td>emailflags</td> <td>MEDIUMTEXT</td> <td> </td> <td>YES</td> <td> </td> <td> a string that contains a user's email preferences for receiving bugzilla notifications</td> </tr> <tr> <td>refreshed_when</td> <td>DATETIME</td> <td bgcolor='#33CC66'>"1900-01-01 00:00:00"/1900-01-01 00:00:00</td> <td>NO</td> <td> </td> <td>the date that a user's permissions were last derived, goes along with last_changed in groups table</td> </tr> </table> <br/><br/> <table border='1' width='75%'> <tr> <th>NAME</th> <td colspan="5">profiles_activity</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">This table is for recording changes to the profiles table. Currently it only records changes to group membership made with editusers.cgi. This allows the administrator to track group inflation. There is currently no code to inspect this table; only to add to it.</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr> <td>userid</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td>MUL</td> <td>The profile which has changed (foreign key profiles.userid)</td> </tr> <tr> <td>who</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td>MUL</td> <td>The user who changed it (foreign key profiles.userid)</td> </tr> <tr> <td>profiles_when</td> <td>DATETIME</td> <td> </td> <td>NO</td> <td>MUL</td> <td>When it was changed</td> </tr> <tr> <td>fieldid</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td>MUL</td> <td>The ID of the changed field (foreign key fielddefs.id)</td> </tr> <tr> <td>oldvalue</td> <td>VARCHAR</td> <td> </td> <td>YES</td> <td> </td> <td>The old value</td> </tr> <tr> <td>newvalue</td> <td>VARCHAR</td> <td> </td> <td>YES</td> <td> </td> <td>The new value.</td> </tr> </table> <br/><br/> <table border='1' width='75%'> <tr> <th>NAME</th> <td colspan="5">quips</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">Bugzilla supports quips: small text messages, often humorous, which appear along with search results. The quips are selected at random from a set</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr> <td>quipid</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td>PRI</td> <td>A unique ID.</td> </tr> <tr> <td>userid</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td> </td> <td>The user who added this quip (foreign key profiles.userid)</td> </tr> <tr> <td>quip</td> <td bgcolor='#33CC66'>text/MEDIUMTEXT</td> <td> </td> <td>NO</td> <td> </td> <td>The quip itself.</td> </tr> <tr> <td>approved</td> <td>TINYINT</td> <td>1</td> <td>NO</td> <td> </td> <td>1 if this quip has been approved for display</td> </tr> </table> <br/><br/> <table border='1' width='75%'> <tr> <th>NAME</th> <td colspan="5">rep_platform</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">the possible values of the platform field of a bug</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr> <td>id</td> <td bgcolor='#33CC66'>tinyint(4)/SMALLINT</td> <td> </td> <td>NO</td> <td>PRI</td> <td>a unique ID.</td> </tr> <tr> <td>value</td> <td>VARCHAR</td> <td> </td> <td>NO</td> <td>UNI</td> <td>A possible value of the field</td> </tr> <tr bgcolor='#FFFF66'> <td>sortkey</td> <td>SMALLINT</td> <td> </td> <td>YES</td> <td>MUL</td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> <tr bgcolor='#FFFF66'> <td>isactive</td> <td>TINYINT</td> <td>1</td> <td>YES</td> <td> </td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> </table> <br/><br/> <table border='1' width='75%'> <tr> <th>NAME</th> <td colspan="5">resolution</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">the possible values of the resolution field of a bug</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr> <td>id</td> <td bgcolor='#33CC66'>tinyint(4)/SMALLINT</td> <td> </td> <td>NO</td> <td>PRI</td> <td>a unique ID.</td> </tr> <tr> <td>value</td> <td>VARCHAR</td> <td> </td> <td>NO</td> <td>UNI</td> <td>A possible value of the field</td> </tr> <tr bgcolor='#FFFF66'> <td>sortkey</td> <td>SMALLINT</td> <td> </td> <td>YES</td> <td>MUL</td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> <tr bgcolor='#FFFF66'> <td>isactive</td> <td>TINYINT</td> <td>1</td> <td>YES</td> <td> </td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> </table> <br/><br/> <table border='1' width='75%'> <tr> <th>NAME</th> <td colspan="5">series</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">Properties of the time-series datasets available (e.g. for plotting charts).</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr> <td>series_id</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td>PRI</td> <td>A unique ID.</td> </tr> <tr> <td>creator</td> <td>MEDIUMINT</td> <td> </td> <td bgcolor='#33CC66'>NO/YES</td> <td>MUL</td> <td>The user who created this series (foreign key profiles.userid).NULL if this series is created by checksetup when first installing Bugzilla.</td> </tr> <tr> <td>category</td> <td>SMALLINT</td> <td> </td> <td>NO</td> <td>MUL</td> <td>The series category. (foreign key series_categories.id)</td> </tr> <tr> <td>subcategory</td> <td>SMALLINT</td> <td> </td> <td>NO</td> <td>MUL</td> <td>The series subcategory. (foreign key series_categories.id)</td> </tr> <tr> <td>name</td> <td>VARCHAR</td> <td> </td> <td>NO</td> <td> </td> <td>The series name.</td> </tr> <tr> <td>frequency</td> <td>SMALLINT</td> <td> </td> <td>NO</td> <td> </td> <td>The period between data samples for this series</td> </tr> <tr> <td>last_viewed</td> <td>DATETIME</td> <td> </td> <td>YES</td> <td> </td> <td>The time at which this dataset was last viewed.</td> </tr> <tr> <td>query</td> <td>MEDIUMTEXT</td> <td> </td> <td>NO</td> <td> </td> <td>a snippet of CGI which specifies a subset of bugs</td> </tr> <tr bgcolor='#FFFF66'> <td>is_public</td> <td>TINYINT</td> <td> </td> <td>YES</td> <td> </td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> <tr bgcolor='#9966FF'> <td>public</td> <td>tinyint(1)</td> <td>0</td> <td>NO</td> <td></td> <td>!! field in bugzilla_2.18 but not in bugzilla_3 !!</td> </tr> </table> <br/><br/> <table border='1' width='75%'> <tr> <th>NAME</th> <td colspan="5">series_categories</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">categories of the time-series datasets available</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr> <td>id</td> <td>SMALLINT</td> <td> </td> <td>NO</td> <td>PRI</td> <td>A unique ID.</td> </tr> <tr> <td>name</td> <td>VARCHAR</td> <td> </td> <td>NO</td> <td>UNI</td> <td>The category name.</td> </tr> </table> <br/><br/> <table border='1' width='75%'> <tr> <th>NAME</th> <td colspan="5">series_data</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">Data for plotting time-series charts. </td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr> <td>series_id</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td>PRI</td> <td>The series ID. (foreign key series.series_id)</td> </tr> <tr> <td>series_date</td> <td>DATETIME</td> <td> </td> <td>NO</td> <td>PRI</td> <td>The time point at which this datum was collected.</td> </tr> <tr> <td>series_value</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td> </td> <td>The number of bugs in the dataset at this time point.</td> </tr> </table> <br/><br/> <table border='1' width='75%' bgcolor='#FFFF66'> <tr> <th>NAME</th> <td colspan="5">setting</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">!! table found in bugzilla_3 but not in bugzilla_2_18 !!</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr bgcolor='#FFFF66'> <td>name</td> <td>VARCHAR</td> <td> </td> <td bgcolor='#FF0033'><b>NO</b></td> <td>PRI</td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> <tr bgcolor='#FFFF66'> <td>default_value</td> <td>VARCHAR</td> <td> </td> <td bgcolor='#FF0033'><b>NO</b></td> <td> </td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> <tr bgcolor='#FFFF66'> <td>is_enabled</td> <td>TINYINT</td> <td>1</td> <td bgcolor='#FF0033'><b>NO</b></td> <td> </td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> <tr bgcolor='#FFFF66'> <td>subclass</td> <td>VARCHAR</td> <td> </td> <td>YES</td> <td> </td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> </table> <br/><br/> <table border='1' width='75%' bgcolor='#FFFF66'> <tr> <th>NAME</th> <td colspan="5">setting_value</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">!! table found in bugzilla_3 but not in bugzilla_2_18 !!</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr bgcolor='#FFFF66'> <td>name</td> <td>VARCHAR</td> <td> </td> <td bgcolor='#FF0033'><b>NO</b></td> <td>PRI</td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> <tr bgcolor='#FFFF66'> <td>value</td> <td>VARCHAR</td> <td> </td> <td bgcolor='#FF0033'><b>NO</b></td> <td>PRI</td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> <tr bgcolor='#FFFF66'> <td>sortindex</td> <td>SMALLINT</td> <td> </td> <td bgcolor='#FF0033'><b>NO</b></td> <td> </td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> </table> <br/><br/> <table border='1' width='75%' bgcolor='#FFFF66'> <tr> <th>NAME</th> <td colspan="5">status_workflow</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">!! table found in bugzilla_3 but not in bugzilla_2_18 !!</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr bgcolor='#FFFF66'> <td>old_status</td> <td>SMALLINT</td> <td> </td> <td>YES</td> <td>MUL</td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> <tr bgcolor='#FFFF66'> <td>new_status</td> <td>SMALLINT</td> <td> </td> <td bgcolor='#FF0033'><b>NO</b></td> <td> </td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> <tr bgcolor='#FFFF66'> <td>require_comment</td> <td>TINYINT</td> <td> </td> <td bgcolor='#FF0033'><b>NO</b></td> <td> </td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> </table> <br/><br/> <table border='1' width='75%'> <tr> <th>NAME</th> <td colspan="5">tokens</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">Tokens are sent to users to track activities such as creating new accounts and changing email addresses or passwords. They are also sent to browsers and used to track workflow, to prevent security problems (e.g. so that one can only delete groups from a session last seen on a group management page).</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr> <td>userid</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td>MUL</td> <td>The user to whom the token was issued. (foreign key profiles.userid)</td> </tr> <tr> <td>issuedate</td> <td>DATETIME</td> <td> </td> <td>NO</td> <td> </td> <td>The date at which the token was issued</td> </tr> <tr> <td>token</td> <td>VARCHAR</td> <td> </td> <td>NO</td> <td>PRI</td> <td>The token itself.</td> </tr> <tr> <td>tokentype</td> <td>VARCHAR</td> <td> </td> <td>NO</td> <td> </td> <td>The type of the token. Possible values: 'account' when creating a new user account</td> </tr> <tr> <td>eventdata</td> <td>TINYTEXT</td> <td> </td> <td>YES</td> <td> </td> <td>The expected event</td> </tr> </table> <br/><br/> <table border='1' width='75%'> <tr> <th>NAME</th> <td colspan="5">user_group_map</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">This table records which users are members of each group, or can "bless" each group.</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr> <td>user_id</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td>PRI</td> <td>The user. (foreign key profiles.userid)</td> </tr> <tr> <td>group_id</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td>PRI</td> <td>The group. (foreign key groups.id)</td> </tr> <tr> <td>isbless</td> <td>TINYINT</td> <td> </td> <td>NO</td> <td>PRI</td> <td>0 if this row records group membership; 1 if this row records group bless privilege.</td> </tr> <tr> <td>grant_type</td> <td>TINYINT</td> <td> </td> <td>NO</td> <td>PRI</td> <td>0 if this membership or privilege is explicit. 1 if it is derived from a group hierarchy (see the group_group_map table). 2 if it results from matching a regular expression (see groups.userregexp).</td> </tr> </table> <br/><br/> <table border='1' width='75%'> <tr> <th>NAME</th> <td colspan="5">versions</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">Product versions</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr bgcolor='#FFFF66'> <td>id</td> <td>MEDIUMINT</td> <td> </td> <td bgcolor='#FF0033'><b>NO</b></td> <td>PRI</td> <td>!! field in bugzilla_3 and not in bugzilla_2.18 !!</td> </tr> <tr> <td>value</td> <td>VARCHAR</td> <td> </td> <td bgcolor='#33CC66'>YES/NO</td> <td> </td> <td>The name of the version</td> </tr> <tr> <td>product_id</td> <td>SMALLINT</td> <td> </td> <td>NO</td> <td>MUL</td> <td>The product (foreign key products.id)</td> </tr> </table> <br/><br/> <table border='1' width='75%'> <tr> <th>NAME</th> <td colspan="5">votes</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">Users may vote for bugs which they think are important. A user can vote for a bug more than once</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr> <td>who</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td>MUL</td> <td>The user (foreign key profiles.userid)</td> </tr> <tr> <td>bug_id</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td>MUL</td> <td>The bug (foreign key bugs.bug_id)</td> </tr> <tr> <td>vote_count</td> <td>SMALLINT</td> <td> </td> <td>NO</td> <td> </td> <td>How many votes.</td> </tr> </table> <br/><br/> <table border='1' width='75%'> <tr> <th>NAME</th> <td colspan="5">watch</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">Bugzilla lets users watch each other receiving each other Bugzilla email</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr> <td>watcher</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td>PRI</td> <td>The watching user (foreign key profiles.userid)</td> </tr> <tr> <td>watched</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td>PRI</td> <td>The watched user (foreign key profiles.userid)</td> </tr> </table> <br/><br/> <table border='1' width='75%'> <tr> <th>NAME</th> <td colspan="5">whine_events</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">describes an email message: subject line and some body text to precede query results</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr> <td>id</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td>PRI</td> <td>The whine event ID</td> </tr> <tr> <td>owner_userid</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td>MUL</td> <td>The user ID of the whine owner (foreign key profiles.userid). Must match namedqueries.userid for the queries associated with this event (whine_queries.query_name).</td> </tr> <tr> <td>subject</td> <td>VARCHAR</td> <td> </td> <td>YES</td> <td> </td> <td>The Subject of the whine emails.</td> </tr> <tr> <td>body</td> <td>TEXT</td> <td> </td> <td>YES</td> <td> </td> <td>Text to appear in the body of the whine emails before the bugs table.</td> </tr> </table> <br/><br/> <table border='1' width='75%'> <tr> <th>NAME</th> <td colspan="5">whine_queries</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">stores named queries, to which a title is given for use in email messages</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr> <td>id</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td>PRI</td> <td>A unique ID for this query.</td> </tr> <tr> <td>eventid</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td>MUL</td> <td>The whine event ID (foreign key whine_events.id).</td> </tr> <tr> <td>query_name</td> <td>VARCHAR</td> <td> </td> <td>NO</td> <td> </td> <td>The query name (foreign key namedqueries.name).</td> </tr> <tr> <td>sortkey</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td> </td> <td>A key to order the queries for a given event ID.</td> </tr> <tr> <td>onemailperbug</td> <td>TINYINT</td> <td> </td> <td>NO</td> <td> </td> <td>1 if a separate email message should be sent for each bug matching the query;0 if a single email should be sent covering all the bugs.</td> </tr> <tr> <td>title</td> <td>VARCHAR</td> <td> </td> <td>NO</td> <td> </td> <td>The title displayed for this query in the message.</td> </tr> </table> <br/><br/> <table border='1' width='75%'> <tr> <th>NAME</th> <td colspan="5">whine_schedules</td> </tr> <tr> <th>TYPE</th> <td colspan="5">TABLE</td> </tr> <tr> <th>DESCRIPTION</th> <td colspan="5">specifies the frequency with which an email should be sent to a particular user</td> </tr> <tr> <th>FIELD</th> <th>TYPE</th> <th>DEFAULT</th> <th>NUL</th> <th>KEY</th> <th>REMARK</th> </tr> <tr> <td>id</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td>PRI</td> <td>a unique ID for this whine schedule.</td> </tr> <tr> <td>eventid</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td>MUL</td> <td>The whine event ID (foreign key whine_events.id).</td> </tr> <tr> <td>run_day</td> <td>VARCHAR</td> <td> </td> <td>YES</td> <td> </td> <td>The day on which this whine should run. 'All' means every day. 'MF' means Monday to Friday inclusive. A three letter weekday abbreviation (e.g. Mon)</td> </tr> <tr> <td>run_time</td> <td>VARCHAR</td> <td> </td> <td>YES</td> <td> </td> <td>The time and date at which the whine should next be run. NULL if the whine has been changed and not rescheduled yet.</td> </tr> <tr> <td>run_next</td> <td>DATETIME</td> <td> </td> <td>YES</td> <td bgcolor='#33CC66'>/MUL</td> <td>the date when the whine schedule will run next</td> </tr> <tr> <td>mailto</td> <td>MEDIUMINT</td> <td> </td> <td>NO</td> <td> </td> <td>Either a user ID (foreign key profiles.userid) or group ID (foreign key groups.id) identifying the user or users to whom to send whine messages.</td> </tr> <tr> <td>mailto_type</td> <td bgcolor='#33CC66'>tinyint(4)/SMALLINT</td> <td> </td> <td>NO</td> <td> </td> <td>0 if the mailto field is a user ID</td> </tr> </table> <br/><br/> </body> </html>
View Attachment As Raw
Actions:
View
Attachments on
bug 420611
:
284681
|
285731
|
285741
|
291816
|
291817
|
291818
|
292118
|
292119
|
292335
|
292336
|
292464
|
292465
|
293354
|
293546
|
293608