.. _db:

Database Schema
===============

The following tables are now obsolete:

-  test\_environment\_\*
-  profiles (replaced by auth\_user), profiles\_activity
-  groups (replaced by auth\_groups).

**Table A.1. TCMS**

+---------------+------------------------------+
|**DATABASE**   | TCMS                         |
+---------------+------------------------------+
|**DRIVER**     | mysql                        |
+---------------+------------------------------+
|**DESCRIPTION**| TCMS database schema         |
+---------------+------------------------------+

**Table A.2. attach\_data**

+---------------+------------------------------+
|**NAME**       | **attach\_data**             |
+---------------+------------------------------+
|**TYPE**       | TABLE                        |
+---------------+------------------------------+
|**DESCRIPTION**| The content of attachments.  |
+---------------+------------------------------+

Table Info:

+-----------+-------------+-----------+-------+-------+-----------------------------------------------------------+
| FIELD     | TYPE        | DEFAULT   | NUL   | KEY   | REMARK                                                    |
+===========+=============+===========+=======+=======+===========================================================+
| id        | MEDIUMINT   |           | NO    | PRI   | The attachment id (foreign key attachments.attach\_id).   |
+-----------+-------------+-----------+-------+-------+-----------------------------------------------------------+
| thedata   | LONGBLOB    |           | NO    |       | The content of the attachment.                            |
+-----------+-------------+-----------+-------+-------+-----------------------------------------------------------+

 

**Table A.3. attachments**

+---------------+-------------------------------------------------------------------------------------------------------------------------------+
|**NAME**       | **attachments**                                                                                                               |
+---------------+-------------------------------------------------------------------------------------------------------------------------------+
|**TYPE**       | TABLE                                                                                                                         |
+---------------+-------------------------------------------------------------------------------------------------------------------------------+
|**DESCRIPTION**| Users can upload attachments to bugs. An attachment can be marked as a patch. Attachments are stored in the attachments table.|
+---------------+-------------------------------------------------------------------------------------------------------------------------------+

Table Info:

+-----------------+--------------+-----------+-------+-------+-----------------------------------------------------------------+
| FIELD           | TYPE         | DEFAULT   | NUL   | KEY   | REMARK                                                          |
+=================+==============+===========+=======+=======+=================================================================+
| attach\_id      | MEDIUMINT    |           | NO    | PRI   | Unique ID.                                                      |
+-----------------+--------------+-----------+-------+-------+-----------------------------------------------------------------+
| bug\_id         | MEDIUMINT    |           | NO    | MUL   | The bug to which this is attached (foreign key bugs.bug\_id).   |
+-----------------+--------------+-----------+-------+-------+-----------------------------------------------------------------+
| creation\_ts    | DATETIME     |           | NO    | MUL   | The creation time.                                              |
+-----------------+--------------+-----------+-------+-------+-----------------------------------------------------------------+
| description     | MEDIUMTEXT   |           | NO    |       | Description of the attachment.                                  |
+-----------------+--------------+-----------+-------+-------+-----------------------------------------------------------------+
| mimetype        | MEDIUMTEXT   |           | NO    |       | MIME type of the attachment.                                    |
+-----------------+--------------+-----------+-------+-------+-----------------------------------------------------------------+
| ispatch         | TINYINT      |           | YES   |       | Non-zero if this attachment is a patch file.                    |
+-----------------+--------------+-----------+-------+-------+-----------------------------------------------------------------+
| filename        | VARCHAR      |           | NO    |       | Filename of the attachment.                                     |
+-----------------+--------------+-----------+-------+-------+-----------------------------------------------------------------+
| submitter\_id   | MEDIUMINT    |           | NO    | MUL   | Userid of the attachment (foreign key auth\_user.id)            |
+-----------------+--------------+-----------+-------+-------+-----------------------------------------------------------------+
| isobsolete      | TINYINT      |           | NO    |       | Non-zero if attachment is obsolete.                             |
+-----------------+--------------+-----------+-------+-------+-----------------------------------------------------------------+
| isprivate       | TINYINT      |           | NO    |       | Non-zero if attachment is private.                              |
+-----------------+--------------+-----------+-------+-------+-----------------------------------------------------------------+
| isurl           | TINYINT      |           | NO    |       | Non-zero if this attachment is actually a URL.                  |
+-----------------+--------------+-----------+-------+-------+-----------------------------------------------------------------+


**Table A.4. auth\_group**

+---------------+-------------------------------------------------------------+
|**NAME**       | **auth\_group**                                             |
+---------------+-------------------------------------------------------------+
|**TYPE**       | TABLE                                                       |
+---------------+-------------------------------------------------------------+
|**DESCRIPTION**| Django Groups table. Replaces the Testopia table ``groups``.|
+---------------+-------------------------------------------------------------+

Table Info:

+---------+---------------+-----------+-------+-------+-----------------------------+
| FIELD   | TYPE          | DEFAULT   | NUL   | KEY   | REMARK                      |
+=========+===============+===========+=======+=======+=============================+
| id      | INT(11)       | NULL      | NO    | PRI   | Group ID. Auto increment.   |
+---------+---------------+-----------+-------+-------+-----------------------------+
| name    | VARCHAR(80)   | NULL      | NO    | UNI   | Group name.                 |
+---------+---------------+-----------+-------+-------+-----------------------------+

 

**Table A.5. auth\_group\_permissions**

+---------------+------------------------------+
|**NAME**       | **auth\_group\_permissions** |
+---------------+------------------------------+
|**TYPE**       | TABLE                        |
+---------------+------------------------------+
|**DESCRIPTION**| Permissions for the group.   |
+---------------+------------------------------+

Table Info:

+------------------+-----------+-----------+-------+-------+-----------------------------------+
| FIELD            | TYPE      | DEFAULT   | NUL   | KEY   | REMARK                            |
+==================+===========+===========+=======+=======+===================================+
| id               | INT(11)   | NULL      | NO    | PRI   | Unique ID. Auto increment.        |
+------------------+-----------+-----------+-------+-------+-----------------------------------+
| group\_id        | INT       | NULL      | NO    | MUL   | Foreign key auth\_group.id        |
+------------------+-----------+-----------+-------+-------+-----------------------------------+
| permission\_id   | INT       | NULL      | NO    | MUL   | Foreign key auth\_permission.id   |
+------------------+-----------+-----------+-------+-------+-----------------------------------+

 

**Table A.6. auth\_message**

+---------------+---------------------------------------------------------------+
|**NAME**       | **auth\_message**                                             |
+---------------+---------------------------------------------------------------+
|**TYPE**       | TABLE                                                         |
+---------------+---------------------------------------------------------------+
|**DESCRIPTION**| Django message table. Used to exchange messages between users.|
+---------------+---------------------------------------------------------------+

Table Info:

+------------+------------+-----------+-------+-------+------------------------------+
| FIELD      | TYPE       | DEFAULT   | NUL   | KEY   | REMARK                       |
+============+============+===========+=======+=======+==============================+
| id         | INT(11)    | NULL      | NO    | PRI   | Unique ID. Auto increment.   |
+------------+------------+-----------+-------+-------+------------------------------+
| user\_id   | INT(11)    | NULL      | NO    |       | Foreign key auth\_user.id    |
+------------+------------+-----------+-------+-------+------------------------------+
| message    | LONGTEXT   | NULL      | NO    |       | Authorization message.       |
+------------+------------+-----------+-------+-------+------------------------------+

**Table A.7. auth\_permission**

+---------------+-----------------------------------------------------------------------------------------------------------------------------------------+
|**NAME**       | **auth\_permission**                                                                                                                    |
+---------------+-----------------------------------------------------------------------------------------------------------------------------------------+
|**TYPE**       | TABLE                                                                                                                                   |
+---------------+-----------------------------------------------------------------------------------------------------------------------------------------+
|**DESCRIPTION**| Django permissions. The permissions are based on the app and models.There are three permissions for each model: add, change, and delete.|
+---------------+-----------------------------------------------------------------------------------------------------------------------------------------+

Table Info:

+---------------------+----------------+-----------+-------+-------+----------------------------------------+
| FIELD               | TYPE           | DEFAULT   | NUL   | KEY   | REMARK                                 |
+=====================+================+===========+=======+=======+========================================+
| id                  | INT(11)        | NULL      | NO    | PRI   | Unique ID. Auto increment.             |
+---------------------+----------------+-----------+-------+-------+----------------------------------------+
| name                | VARCHAR(50)    | NULL      | NO    |       | Permission name.                       |
+---------------------+----------------+-----------+-------+-------+----------------------------------------+
| content\_type\_id   | INT(11)        | NULL      | NO    | MUL   | Foreign key django\_content\_type.id   |
+---------------------+----------------+-----------+-------+-------+----------------------------------------+
| codename            | VARCHAR(100)   |           | NO    | MUL   | -                                      |
+---------------------+----------------+-----------+-------+-------+----------------------------------------+

 

**Table A.8. auth\_user**

+---------------+-----------------------------------------------------------------------+
|**NAME**       | **auth\_user**                                                        |
+---------------+-----------------------------------------------------------------------+
|**TYPE**       | TABLE                                                                 |
+---------------+-----------------------------------------------------------------------+
|**DESCRIPTION**| Django User/Group/ACL table. Replaces the Testopia table ``profiles``.|
+---------------+-----------------------------------------------------------------------+

Table Info:

+-----------------+----------------+-----------+-------+-------+----------------------------------------------+
| FIELD           | TYPE           | DEFAULT   | NUL   | KEY   | REMARK                                       |
+=================+================+===========+=======+=======+==============================================+
| id              | INT(11)        | NULL      | NO    | PRI   | Unique ID. Auto increment.                   |
+-----------------+----------------+-----------+-------+-------+----------------------------------------------+
| username        | VARCHAR(30)    | NULL      | NO    | UNI   | Unique username. Generally Kerberos uname.   |
+-----------------+----------------+-----------+-------+-------+----------------------------------------------+
| first\_name     | VARCHAR(30)    | NULL      | NO    |       | User's first name.                           |
+-----------------+----------------+-----------+-------+-------+----------------------------------------------+
| last\_name      | VARCHAR(30)    | NULL      | NO    |       | User's last name.                            |
+-----------------+----------------+-----------+-------+-------+----------------------------------------------+
| email           | VARCHAR(75)    | NULL      | NO    |       | User's email.                                |
+-----------------+----------------+-----------+-------+-------+----------------------------------------------+
| password        | VARCHAR(128)   | NULL      | NO    |       | User's password hash.                        |
+-----------------+----------------+-----------+-------+-------+----------------------------------------------+
| is\_staff       | TINYINT(1)     | NULL      | NO    |       | 1 is staff, 0 otherwise.                     |
+-----------------+----------------+-----------+-------+-------+----------------------------------------------+
| is\_active      | TINYINT(1)     | NULL      | NO    |       | 1 is active user, 0 otherwise.               |
+-----------------+----------------+-----------+-------+-------+----------------------------------------------+
| is\_superuser   | TINYINT(1)     | NULL      | NO    |       | 1 is super user, 0 otherwise.                |
+-----------------+----------------+-----------+-------+-------+----------------------------------------------+
| last\_login     | DATETIME       | NULL      | NO    |       | Date of last login.                          |
+-----------------+----------------+-----------+-------+-------+----------------------------------------------+
| date\_joined    | DATETIME       | NULL      | NO    |       | Date user account added to system.           |
+-----------------+----------------+-----------+-------+-------+----------------------------------------------+

 

**Table A.9. auth\_user\_groups**

+---------------+------------------------------+
|**NAME**       | **auth\_user\_groups**       |
+---------------+------------------------------+
|**TYPE**       | TABLE                        |
+---------------+------------------------------+
|**DESCRIPTION**| Mapping of user to groups. . |
+---------------+------------------------------+

Table Info:

+-------------+-----------+-----------+-------+-------+------------------------------+
| FIELD       | TYPE      | DEFAULT   | NUL   | KEY   | REMARK                       |
+=============+===========+===========+=======+=======+==============================+
| id          | INT(11)   | NULL      | NO    | PRI   | Unique ID. Auto increment.   |
+-------------+-----------+-----------+-------+-------+------------------------------+
| user\_id    | INT       | NULL      | NO    | MUL   | Foreign key auth\_user.id    |
+-------------+-----------+-----------+-------+-------+------------------------------+
| group\_id   | INT       | NULL      | NO    | MUL   | Foreign key auth\_group.id   |
+-------------+-----------+-----------+-------+-------+------------------------------+

 

**Table A.10. auth\_user\_user\_permissions**

+---------------+----------------------------------+
|**NAME**       | **auth\_user\_user\_permissions**|
+---------------+----------------------------------+
|**TYPE**       | TABLE                            |
+---------------+----------------------------------+
|**DESCRIPTION**| Mapping of user to permissions.  |
+---------------+----------------------------------+

Table Info:

+------------------+-----------+-----------+-------+-------+-----------------------------------+
| FIELD            | TYPE      | DEFAULT   | NUL   | KEY   | REMARK                            |
+==================+===========+===========+=======+=======+===================================+
| id               | INT(11)   | NULL      | NO    | PRI   | Unique ID. Auto increment.        |
+------------------+-----------+-----------+-------+-------+-----------------------------------+
| user\_id         | INT(11)   | NULL      | NO    | MUL   | Foreign key auth\_user.id         |
+------------------+-----------+-----------+-------+-------+-----------------------------------+
| permission\_id   | INT(11)   | NULL      | NO    | MUL   | Foreign key auth\_permission.id   |
+------------------+-----------+-----------+-------+-------+-----------------------------------+

**Table A.11. bug\_group\_map**

+---------------+------------------------------+
|**NAME**       | **bug\_group\_map**          |
+---------------+------------------------------+
|**TYPE**       | TABLE                        |
+---------------+------------------------------+
|**DESCRIPTION**| Mapping of bugs to groups.   |
+---------------+------------------------------+

Table Info:

+-------------+-------------+-----------+-------+-------+-----------------------------------------+
| FIELD       | TYPE        | DEFAULT   | NUL   | KEY   | REMARK                                  |
+=============+=============+===========+=======+=======+=========================================+
| bug\_id     | MEDIUMINT   |           | NO    | PRI   | Bug ID (foreign key bugs.bug\_id).      |
+-------------+-------------+-----------+-------+-------+-----------------------------------------+
| group\_id   | MEDIUMINT   |           | NO    | PRI   | The group ID (foreign key groups.id).   |
+-------------+-------------+-----------+-------+-------+-----------------------------------------+

 

**Table A.12. bug\_severity**

+---------------+-------------------------------+
|**NAME**       | **bug\_severity**             |
+---------------+-------------------------------+
|**TYPE**       | TABLE                         |
+---------------+-------------------------------+
|**DESCRIPTION**| The serverity values for bugs.|
+---------------+-------------------------------+

Table Info:

+------------+------------+-----------+-------+-------+---------------------------------------------------+
| FIELD      | TYPE       | DEFAULT   | NUL   | KEY   | REMARK                                            |
+============+============+===========+=======+=======+===================================================+
| id         | SMALLINT   |           | NO    | PRI   | Unique ID.                                        |
+------------+------------+-----------+-------+-------+---------------------------------------------------+
| value      | VARCHAR    |           | NO    | UNI   | Severity value.                                   |
+------------+------------+-----------+-------+-------+---------------------------------------------------+
| sortkey    | SMALLINT   |           | NO    | MUL   | Determines the order in which values are shown.   |
+------------+------------+-----------+-------+-------+---------------------------------------------------+
| isactive   | TINYINT    | 1         | NO    |       | 1 if available in the UI, 0 otherwise.            |
+------------+------------+-----------+-------+-------+---------------------------------------------------+

 

**Table A.13. bug\_status**

+---------------+------------------------------+
|**NAME**       | **bug\_status**              |
+---------------+------------------------------+
|**TYPE**       | TABLE                        |
+---------------+------------------------------+
|**DESCRIPTION**| The status values for bugs.  |
+---------------+------------------------------+

Table Info:

+------------+------------+-----------+-------+-------+---------------------------------------------------+
| FIELD      | TYPE       | DEFAULT   | NUL   | KEY   | REMARK                                            |
+============+============+===========+=======+=======+===================================================+
| id         | SMALLINT   |           | NO    | PRI   | Unique ID.                                        |
+------------+------------+-----------+-------+-------+---------------------------------------------------+
| value      | VARCHAR    |           | NO    | UNI   | Status value.                                     |
+------------+------------+-----------+-------+-------+---------------------------------------------------+
| sortkey    | SMALLINT   |           | NO    | MUL   | Determines the order in which values are shown.   |
+------------+------------+-----------+-------+-------+---------------------------------------------------+
| isactive   | TINYINT    | 1         | NO    |       | 1 if available in the UI, 0 otherwise.            |
+------------+------------+-----------+-------+-------+---------------------------------------------------+

 

**Table A.14. bugs**

+---------------+------------------------------+
|**NAME**       | **bugs**                     |
+---------------+------------------------------+
|**TYPE**       | TABLE                        |
+---------------+------------------------------+
|**DESCRIPTION**| The bug details.             |
+---------------+------------------------------+

Table Info:

+------------------------+--------------+-----------+-------+-------+---------------------------------------------------------------------------------------------------------+
| FIELD                  | TYPE         | DEFAULT   | NUL   | KEY   | REMARK                                                                                                  |
+========================+==============+===========+=======+=======+=========================================================================================================+
| bug\_id                | MEDIUMINT    |           | NO    | PRI   | Bug ID.                                                                                                 |
+------------------------+--------------+-----------+-------+-------+---------------------------------------------------------------------------------------------------------+
| assigned\_to           | MEDIUMINT    |           | NO    | MUL   | Current owner of the bug (foreign key auth\_user.id).                                                   |
+------------------------+--------------+-----------+-------+-------+---------------------------------------------------------------------------------------------------------+
| bug\_file\_loc         | TEXT         |           | YES   |       | A URL which points to more information about the bug.                                                   |
+------------------------+--------------+-----------+-------+-------+---------------------------------------------------------------------------------------------------------+
| bug\_severity          | VARCHAR      |           | NO    | MUL   | Severity value of a bug (foreign key bug\_severity.value).                                              |
+------------------------+--------------+-----------+-------+-------+---------------------------------------------------------------------------------------------------------+
| bug\_status            | VARCHAR      |           | NO    | MUL   | Workflow status of the bug (foreign key bug\_status.value).                                             |
+------------------------+--------------+-----------+-------+-------+---------------------------------------------------------------------------------------------------------+
| creation\_ts           | DATETIME     |           | YES   | MUL   | Time of bug creation.                                                                                   |
+------------------------+--------------+-----------+-------+-------+---------------------------------------------------------------------------------------------------------+
| delta\_ts              | DATETIME     |           | NO    | MUL   | The timestamp of the last update. This includes updates to some related tables.                         |
+------------------------+--------------+-----------+-------+-------+---------------------------------------------------------------------------------------------------------+
| short\_desc            | VARCHAR      |           | NO    |       | Short description of the bug.                                                                           |
+------------------------+--------------+-----------+-------+-------+---------------------------------------------------------------------------------------------------------+
| op\_sys                | VARCHAR      |           | NO    | MUL   | Operating system on which the bug was observed (foreign key op\_sys.value).                             |
+------------------------+--------------+-----------+-------+-------+---------------------------------------------------------------------------------------------------------+
| priority               | VARCHAR      |           | NO    | MUL   | The priority of the bug (foreign key priority.value).                                                   |
+------------------------+--------------+-----------+-------+-------+---------------------------------------------------------------------------------------------------------+
| product\_id            | SMALLINT     |           | NO    | MUL   | Product the bug relates to (foreign key products.id).                                                   |
+------------------------+--------------+-----------+-------+-------+---------------------------------------------------------------------------------------------------------+
| rep\_platform          | VARCHAR      |           | NO    |       | Platform on which the bug was reported (foreign key rep\_platform.value).                               |
+------------------------+--------------+-----------+-------+-------+---------------------------------------------------------------------------------------------------------+
| reporter               | MEDIUMINT    |           | NO    | MUL   | User who reported the bug (foreign key auth\_user.id).                                                  |
+------------------------+--------------+-----------+-------+-------+---------------------------------------------------------------------------------------------------------+
| version                | VARCHAR      |           | NO    | MUL   | Product version (foreign key versions.value).                                                           |
+------------------------+--------------+-----------+-------+-------+---------------------------------------------------------------------------------------------------------+
| component\_id          | SMALLINT     |           | NO    | MUL   | Product component (foreign key components.id).                                                          |
+------------------------+--------------+-----------+-------+-------+---------------------------------------------------------------------------------------------------------+
| resolution             | VARCHAR      |           | NO    | MUL   | Bug resolution (foreign key resolution.value).                                                          |
+------------------------+--------------+-----------+-------+-------+---------------------------------------------------------------------------------------------------------+
| target\_milestone      | VARCHAR      |           | NO    | MUL   | Milestone by which this bug should be resolved (foreign key milestones.value).                          |
+------------------------+--------------+-----------+-------+-------+---------------------------------------------------------------------------------------------------------+
| qa\_contact            | MEDIUMINT    |           | NO    | MUL   | The QA contact (foreign key auth\_user.id).                                                             |
+------------------------+--------------+-----------+-------+-------+---------------------------------------------------------------------------------------------------------+
| status\_whiteboard     | MEDIUMTEXT   |           | NO    |       | Small whiteboard field.                                                                                 |
+------------------------+--------------+-----------+-------+-------+---------------------------------------------------------------------------------------------------------+
| votes                  | MEDIUMINT    |           | NO    | MUL   | The number of votes.                                                                                    |
+------------------------+--------------+-----------+-------+-------+---------------------------------------------------------------------------------------------------------+
| keywords               | MEDIUMTEXT   |           | NO    |       | A set of keywords. Note: duplicates information in the keywords table (foreign key keyworddefs.name).   |
+------------------------+--------------+-----------+-------+-------+---------------------------------------------------------------------------------------------------------+
| lastdiffed             | DATETIME     |           | YES   |       | The time at which bug change information was last emailed to the CC list.                               |
+------------------------+--------------+-----------+-------+-------+---------------------------------------------------------------------------------------------------------+
| everconfirmed          | TINYINT      |           | NO    |       | 1 if this bug has ever been confirmed. Used for validation of some sort.                                |
+------------------------+--------------+-----------+-------+-------+---------------------------------------------------------------------------------------------------------+
| reporter\_accessible   | TINYINT      | 1         | NO    |       | 1 if the reporter can see this bug (even if in the wrong group), 0 otherwise.                           |
+------------------------+--------------+-----------+-------+-------+---------------------------------------------------------------------------------------------------------+
| cclist\_accessible     | TINYINT      | 1         | NO    |       | 1 if people on the CC list can see this bug (even if in the wrong group), 0 otherwise.                  |
+------------------------+--------------+-----------+-------+-------+---------------------------------------------------------------------------------------------------------+
| estimated\_time        | DECIMAL      | 0.00      | NO    |       | The original estimate of the total effort required to fix this bug (in hours).                          |
+------------------------+--------------+-----------+-------+-------+---------------------------------------------------------------------------------------------------------+
| remaining\_time        | DECIMAL      | 0.00      | NO    |       | The current estimate of the remaining effort required to fix this bug (in hours).                       |
+------------------------+--------------+-----------+-------+-------+---------------------------------------------------------------------------------------------------------+
| deadline               | DATETIME     |           | YES   |       | Used by hwcert to record the hwcert public cert date.                                                   |
+------------------------+--------------+-----------+-------+-------+---------------------------------------------------------------------------------------------------------+
| alias                  | VARCHAR      |           | YES   | UNI   | An alias for the bug which can be used instead of the bug number.                                       |
+------------------------+--------------+-----------+-------+-------+---------------------------------------------------------------------------------------------------------+

 

**Table A.15. bugs\_activity**

+---------------+------------------------------+
|**NAME**       | **bz\_activity**             |
+---------------+------------------------------+
|**TYPE**       | TABLE                        |
+---------------+------------------------------+
|**DESCRIPTION**| Records activity on the bug. |
+---------------+------------------------------+

Table Info:

+--------------+-------------+-----------+-------+-------+----------------------------------------------------------------------------+
| FIELD        | TYPE        | DEFAULT   | NUL   | KEY   | REMARK                                                                     |
+==============+=============+===========+=======+=======+============================================================================+
| bug\_id      | MEDIUMINT   |           | NO    | MUL   | Bug ID (foreign key bugs.bug\_id).                                         |
+--------------+-------------+-----------+-------+-------+----------------------------------------------------------------------------+
| attach\_id   | MEDIUMINT   |           | YES   |       | If the change was to an attachment (foreign key attachments.attach\_id).   |
+--------------+-------------+-----------+-------+-------+----------------------------------------------------------------------------+
| who          | MEDIUMINT   |           | NO    | MUL   | User (foreign key auth\_user.id).                                          |
+--------------+-------------+-----------+-------+-------+----------------------------------------------------------------------------+
| bug\_when    | DATETIME    |           | NO    | MUL   | Date the change occurred.                                                  |
+--------------+-------------+-----------+-------+-------+----------------------------------------------------------------------------+
| fieldid      | MEDIUMINT   |           | NO    | MUL   | Field ID of the change (foreign key fielddefs.id).                         |
+--------------+-------------+-----------+-------+-------+----------------------------------------------------------------------------+
| added        | TINYTEXT    |           | YES   |       | The new value of this field.                                               |
+--------------+-------------+-----------+-------+-------+----------------------------------------------------------------------------+
| removed      | TINYTEXT    |           | YES   |       | The old value of this field.                                               |
+--------------+-------------+-----------+-------+-------+----------------------------------------------------------------------------+

 

**Table A.16. bz\_schema**

+---------------+------------------------------+
|**NAME**       | **bz\_schema**               |
+---------------+------------------------------+
|**TYPE**       | TABLE                        |
+---------------+------------------------------+
|**DESCRIPTION**| The Bugzilla database schema |
+---------------+------------------------------+

Table Info:

+----------------+------------+-----------+-------+-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| FIELD          | TYPE       | DEFAULT   | NUL   | KEY   | REMARK                                                                                                                                                                 |
+================+============+===========+=======+=======+========================================================================================================================================================================+
| schema\_data   | LONGBLOB   |           | NO    |       | A serialized version of the abstract schema. Format is readable in Perl.                                                                                               |
+----------------+------------+-----------+-------+-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| version        | DECIMAL    |           | NO    |       | The version number of the abstract schema data structures. This is not the schema version, it does not change as tables, columns, and indexes are added and removed.   |
+----------------+------------+-----------+-------+-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

.. note::

  Is there any specific reason why a User Guide contains a database
  schema? Converting 200 tables into Confluence is very laborious and I'm
  not sure will be of benefit. Converting 15 took approximate 5 hours.
