<HTML ><HEAD ><TITLE >Database Schema</TITLE ><META NAME="GENERATOR" CONTENT="Modular DocBook HTML Stylesheet Version 1.76b+ "><LINK REL="HOME" TITLE="phpBugTracker" HREF="index.html"><LINK REL="UP" TITLE="Developer's Guide" HREF="devguide.html"><LINK REL="PREVIOUS" TITLE="Development Standards" HREF="devstandards.html"><LINK REL="STYLESHEET" TYPE="text/css" HREF="docs.css"></HEAD ><BODY CLASS="SECT1" BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#0000FF" VLINK="#800080" ALINK="#FF0000" ><DIV CLASS="NAVHEADER" ><TABLE SUMMARY="Header navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TH COLSPAN="3" ALIGN="center" >phpBugTracker</TH ></TR ><TR ><TD WIDTH="10%" ALIGN="left" VALIGN="bottom" ><A HREF="devstandards.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="80%" ALIGN="center" VALIGN="bottom" >Chapter 3. Developer's Guide</TD ><TD WIDTH="10%" ALIGN="right" VALIGN="bottom" > </TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><DIV CLASS="SECT1" ><H1 CLASS="SECT1" ><A NAME="SCHEMA">3.3. Database Schema</H1 ><DIV CLASS="TABLE" ><A NAME="AEN420"><P ><B >Table 3-1. Schema for table attachment</B ></P ><TABLE BORDER="1" CLASS="CALSTABLE" ><THEAD ><TR ><TH ALIGN="LEFT" VALIGN="TOP" >Field</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Type</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Key</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Description</TH ></TR ></THEAD ><TBODY ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >attachment_id</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" >Primary</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >bug_id</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" >Foreign</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >file_name</TD ><TD ALIGN="LEFT" VALIGN="TOP" >char(255)</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" >The name of the file supplied by the user and the name as it is stored on disk.</TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >description</TD ><TD ALIGN="LEFT" VALIGN="TOP" >char(255)</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" >The description of the file as entered by the user.</TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >file_size</TD ><TD ALIGN="LEFT" VALIGN="TOP" >bigint(20) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >mime_type</TD ><TD ALIGN="LEFT" VALIGN="TOP" >char(30)</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" >The MIME type as obtained by PHP when the file was uploaded</TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >created_by</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >created_date</TD ><TD ALIGN="LEFT" VALIGN="TOP" >bigint(20) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ></TBODY ></TABLE ></DIV ><DIV CLASS="TABLE" ><A NAME="AEN470"><P ><B >Table 3-2. Schema for table auth_group</B ></P ><TABLE BORDER="1" CLASS="CALSTABLE" ><THEAD ><TR ><TH ALIGN="LEFT" VALIGN="TOP" >Field</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Type</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Key</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Description</TH ></TR ></THEAD ><TBODY ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >group_id</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" >Primary</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >group_name</TD ><TD ALIGN="LEFT" VALIGN="TOP" >varchar(80)</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >locked</TD ><TD ALIGN="LEFT" VALIGN="TOP" >tinyint(1)</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" >Accepts values 1 or 0 for whether or not a group can be edited from the admin tools.</TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >created_by</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >created_date</TD ><TD ALIGN="LEFT" VALIGN="TOP" >bigint(20) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >last_modified_by</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >last_modified_date</TD ><TD ALIGN="LEFT" VALIGN="TOP" >bigint(20) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ></TBODY ></TABLE ></DIV ><P >This table defines the various groups to which a user may belong. The initial groups are Admin, User, and Developer.</P ><DIV CLASS="TABLE" ><A NAME="AEN516"><P ><B >Table 3-3. Schema for table auth_perm</B ></P ><TABLE BORDER="1" CLASS="CALSTABLE" ><THEAD ><TR ><TH ALIGN="LEFT" VALIGN="TOP" >Field</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Type</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Key</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Description</TH ></TR ></THEAD ><TBODY ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >perm_id</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" >Primary</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >perm_name</TD ><TD ALIGN="LEFT" VALIGN="TOP" >varchar(80)</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >created_by</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >created_date</TD ><TD ALIGN="LEFT" VALIGN="TOP" >bigint(20) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >last_modified_by</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >last_modified_date</TD ><TD ALIGN="LEFT" VALIGN="TOP" >bigint(20) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ></TBODY ></TABLE ></DIV ><P ><SPAN CLASS="DATABASE" >auth_perm</SPAN > stores the various permissions that can be assigned to users.</P ><DIV CLASS="TABLE" ><A NAME="AEN558"><P ><B >Table 3-4. Schema for table auth_user</B ></P ><TABLE BORDER="1" CLASS="CALSTABLE" ><THEAD ><TR ><TH ALIGN="LEFT" VALIGN="TOP" >Field</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Type</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Key</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Description</TH ></TR ></THEAD ><TBODY ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >user_id</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" >Primary</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >login</TD ><TD ALIGN="LEFT" VALIGN="TOP" >char(40)</TD ><TD ALIGN="LEFT" VALIGN="TOP" >Unique</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >first_name</TD ><TD ALIGN="LEFT" VALIGN="TOP" >char(40)</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >last_name</TD ><TD ALIGN="LEFT" VALIGN="TOP" >char(40)</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >email</TD ><TD ALIGN="LEFT" VALIGN="TOP" >char(60)</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >password</TD ><TD ALIGN="LEFT" VALIGN="TOP" >char(40)</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >active</TD ><TD ALIGN="LEFT" VALIGN="TOP" >tinyint(3) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >bug_list_fields</TD ><TD ALIGN="LEFT" VALIGN="TOP" >char(255)</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" >This contains a serialized array of the fields the user has selected to see in the bug list. If this field is empty the default fields will be shown.</TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >created_by</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >created_date</TD ><TD ALIGN="LEFT" VALIGN="TOP" >bigint(20) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >last_modified_by</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >last_modified_date</TD ><TD ALIGN="LEFT" VALIGN="TOP" >bigint(20) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ></TBODY ></TABLE ></DIV ><DIV CLASS="TABLE" ><A NAME="AEN628"><P ><B >Table 3-5. Schema for table bug</B ></P ><TABLE BORDER="1" CLASS="CALSTABLE" ><THEAD ><TR ><TH ALIGN="LEFT" VALIGN="TOP" >Field</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Type</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Key</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Description</TH ></TR ></THEAD ><TBODY ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >bug_id</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" >Primary</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >title</TD ><TD ALIGN="LEFT" VALIGN="TOP" >varchar(100)</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" >The short summary.</TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >description</TD ><TD ALIGN="LEFT" VALIGN="TOP" >text</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" >The longer, more detailed description of a bug.</TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >url</TD ><TD ALIGN="LEFT" VALIGN="TOP" >varchar(255)</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >severity_id</TD ><TD ALIGN="LEFT" VALIGN="TOP" >tinyint(3) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" >Foreign</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >priority</TD ><TD ALIGN="LEFT" VALIGN="TOP" >tinyint(3) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >status_id</TD ><TD ALIGN="LEFT" VALIGN="TOP" >tinyint(3) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" >Foreign</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >resolution_id</TD ><TD ALIGN="LEFT" VALIGN="TOP" >tinyint(3) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" >Foreign</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >assigned_to</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" >The <SPAN CLASS="DATABASE" >user_id</SPAN > of the user to whom the bug is assigned.</TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >created_by</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" >The <SPAN CLASS="DATABASE" >user_id</SPAN > of the user who reported the bug.</TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >created_date</TD ><TD ALIGN="LEFT" VALIGN="TOP" >bigint(20) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >last_modified_by</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >last_modified_date</TD ><TD ALIGN="LEFT" VALIGN="TOP" >bigint(20) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >project_id</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" >Foreign</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >version_id</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" >Foreign</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >component_id</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" >Foreign</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >os_id</TD ><TD ALIGN="LEFT" VALIGN="TOP" >tinyint(3) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" >Foreign</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >browser_string</TD ><TD ALIGN="LEFT" VALIGN="TOP" >varchar(255)</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" >The value obtained from <TT CLASS="VARNAME" >$HTTP_USER_AGENT</TT >.</TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >close_date</TD ><TD ALIGN="LEFT" VALIGN="TOP" >bigint(20) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ></TBODY ></TABLE ></DIV ><DIV CLASS="TABLE" ><A NAME="AEN736"><P ><B >Table 3-6. Schema for table bug_cc</B ></P ><TABLE BORDER="1" CLASS="CALSTABLE" ><THEAD ><TR ><TH ALIGN="LEFT" VALIGN="TOP" >Field</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Type</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Key</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Description</TH ></TR ></THEAD ><TBODY ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >bug_id</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" >Foreign</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >user_id</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" >Foreign</TD ><TD ALIGN="LEFT" VALIGN="TOP" >The user to whom to send carbon copies of the emails sent due to changes in the bug status.</TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >created_by</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >created_date</TD ><TD ALIGN="LEFT" VALIGN="TOP" >bigint(20) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ></TBODY ></TABLE ></DIV ><DIV CLASS="TABLE" ><A NAME="AEN766"><P ><B >Table 3-7. Schema for table bug_dependency</B ></P ><TABLE BORDER="1" CLASS="CALSTABLE" ><THEAD ><TR ><TH ALIGN="LEFT" VALIGN="TOP" >Field</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Type</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Key</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Description</TH ></TR ></THEAD ><TBODY ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >bug_id</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" >Primary</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >depends_on</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" >Primary</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ></TBODY ></TABLE ></DIV ><DIV CLASS="TABLE" ><A NAME="AEN786"><P ><B >Table 3-8. Schema for table bug_group</B ></P ><TABLE BORDER="1" CLASS="CALSTABLE" ><THEAD ><TR ><TH ALIGN="LEFT" VALIGN="TOP" >Field</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Type</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Key</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Description</TH ></TR ></THEAD ><TBODY ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >bug_id</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" >Primary</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >group_id</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" >Primary</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ></TBODY ></TABLE ></DIV ><P >This table isn't currently used.</P ><DIV CLASS="TABLE" ><A NAME="AEN807"><P ><B >Table 3-9. Schema for table bug_vote</B ></P ><TABLE BORDER="1" CLASS="CALSTABLE" ><THEAD ><TR ><TH ALIGN="LEFT" VALIGN="TOP" >Field</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Type</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Key</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Description</TH ></TR ></THEAD ><TBODY ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >user_id</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" >Primary</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >bug_id</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" >Primary</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >created_date</TD ><TD ALIGN="LEFT" VALIGN="TOP" >bigint(20) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ></TBODY ></TABLE ></DIV ><DIV CLASS="TABLE" ><A NAME="AEN832"><P ><B >Table 3-10. Schema for table bug_history</B ></P ><TABLE BORDER="1" CLASS="CALSTABLE" ><THEAD ><TR ><TH ALIGN="LEFT" VALIGN="TOP" >Field</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Type</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Key</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Description</TH ></TR ></THEAD ><TBODY ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >bug_id</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" >Foreign</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >changed_field</TD ><TD ALIGN="LEFT" VALIGN="TOP" >char(20)</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" >The field, such as version, component, etc., that changed.</TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >old_value</TD ><TD ALIGN="LEFT" VALIGN="TOP" >char(255)</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >new_value</TD ><TD ALIGN="LEFT" VALIGN="TOP" >char(255)</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >created_by</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >created_date</TD ><TD ALIGN="LEFT" VALIGN="TOP" >bigint(20) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ></TBODY ></TABLE ></DIV ><DIV CLASS="TABLE" ><A NAME="AEN872"><P ><B >Table 3-11. Schema for table comment</B ></P ><TABLE BORDER="1" CLASS="CALSTABLE" ><THEAD ><TR ><TH ALIGN="LEFT" VALIGN="TOP" >Field</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Type</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Key</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Description</TH ></TR ></THEAD ><TBODY ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >comment_id</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" >Primary</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >bug_id</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" >Foreign</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >comment_text</TD ><TD ALIGN="LEFT" VALIGN="TOP" >text</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >created_by</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >created_date</TD ><TD ALIGN="LEFT" VALIGN="TOP" >bigint(20) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ></TBODY ></TABLE ></DIV ><DIV CLASS="TABLE" ><A NAME="AEN907"><P ><B >Table 3-12. Schema for table component</B ></P ><TABLE BORDER="1" CLASS="CALSTABLE" ><THEAD ><TR ><TH ALIGN="LEFT" VALIGN="TOP" >Field</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Type</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Key</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Description</TH ></TR ></THEAD ><TBODY ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >component_id</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" >Primary</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >project_id</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" >Foreign</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >component_name</TD ><TD ALIGN="LEFT" VALIGN="TOP" >varchar(30)</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >component_desc</TD ><TD ALIGN="LEFT" VALIGN="TOP" >text</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >owner</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" >This is the <SPAN CLASS="DATABASE" >user_id</SPAN > of the developer who should receive initial email notifications of bugs created for this component.</TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >active</TD ><TD ALIGN="LEFT" VALIGN="TOP" >tinyint(1)</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >created_by</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >created_date</TD ><TD ALIGN="LEFT" VALIGN="TOP" >bigint(20) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >last_modified_by</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >last_modified_date</TD ><TD ALIGN="LEFT" VALIGN="TOP" >bigint(20) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ></TBODY ></TABLE ></DIV ><DIV CLASS="TABLE" ><A NAME="AEN968"><P ><B >Table 3-13. Schema for table configuration</B ></P ><TABLE BORDER="1" CLASS="CALSTABLE" ><THEAD ><TR ><TH ALIGN="LEFT" VALIGN="TOP" >Field</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Type</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Key</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Description</TH ></TR ></THEAD ><TBODY ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >varname</TD ><TD ALIGN="LEFT" VALIGN="TOP" >char(40)</TD ><TD ALIGN="LEFT" VALIGN="TOP" >Primary</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >varvalue</TD ><TD ALIGN="LEFT" VALIGN="TOP" >char(255)</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >description</TD ><TD ALIGN="LEFT" VALIGN="TOP" >char(255)</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >vartype</TD ><TD ALIGN="LEFT" VALIGN="TOP" >char(20)</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ></TBODY ></TABLE ></DIV ><P >This table stores the configuration for phpBugTracker</P ><DIV CLASS="TABLE" ><A NAME="AEN999"><P ><B >Table 3-14. Schema for table group_perm</B ></P ><TABLE BORDER="1" CLASS="CALSTABLE" ><THEAD ><TR ><TH ALIGN="LEFT" VALIGN="TOP" >Field</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Type</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Key</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Description</TH ></TR ></THEAD ><TBODY ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >group_id</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" >Primary</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >perm_id</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" >Primary</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ></TBODY ></TABLE ></DIV ><DIV CLASS="TABLE" ><A NAME="AEN1019"><P ><B >Table 3-15. Schema for table os</B ></P ><TABLE BORDER="1" CLASS="CALSTABLE" ><THEAD ><TR ><TH ALIGN="LEFT" VALIGN="TOP" >Field</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Type</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Key</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Description</TH ></TR ></THEAD ><TBODY ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >os_id</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" >Primary</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >os_name</TD ><TD ALIGN="LEFT" VALIGN="TOP" >char(30)</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >sort_order</TD ><TD ALIGN="LEFT" VALIGN="TOP" >tinyint(3) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >regex</TD ><TD ALIGN="LEFT" VALIGN="TOP" >char(40)</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ></TBODY ></TABLE ></DIV ><DIV CLASS="TABLE" ><A NAME="AEN1049"><P ><B >Table 3-16. Schema for table project</B ></P ><TABLE BORDER="1" CLASS="CALSTABLE" ><THEAD ><TR ><TH ALIGN="LEFT" VALIGN="TOP" >Field</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Type</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Key</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Description</TH ></TR ></THEAD ><TBODY ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >project_id</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" >Primary</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >project_name</TD ><TD ALIGN="LEFT" VALIGN="TOP" >varchar(30)</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >project_desc</TD ><TD ALIGN="LEFT" VALIGN="TOP" >text</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >active</TD ><TD ALIGN="LEFT" VALIGN="TOP" >tinyint(1)</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >created_by</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >created_date</TD ><TD ALIGN="LEFT" VALIGN="TOP" >bigint(20) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >last_modified_by</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >last_modified_date</TD ><TD ALIGN="LEFT" VALIGN="TOP" >bigint(20) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ></TBODY ></TABLE ></DIV ><DIV CLASS="TABLE" ><A NAME="AEN1099"><P ><B >Table 3-17. Schema for table project_group</B ></P ><TABLE BORDER="1" CLASS="CALSTABLE" ><THEAD ><TR ><TH ALIGN="LEFT" VALIGN="TOP" >Field</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Type</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Key</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Description</TH ></TR ></THEAD ><TBODY ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >project_id</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" >Primary</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >group_id</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" >Primary</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >created_by</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >created_date</TD ><TD ALIGN="LEFT" VALIGN="TOP" >bigint(20) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ></TBODY ></TABLE ></DIV ><DIV CLASS="TABLE" ><A NAME="AEN1129"><P ><B >Table 3-18. Schema for table resolution</B ></P ><TABLE BORDER="1" CLASS="CALSTABLE" ><THEAD ><TR ><TH ALIGN="LEFT" VALIGN="TOP" >Field</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Type</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Key</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Description</TH ></TR ></THEAD ><TBODY ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >resolution_id</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" >Primary</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >resolution_name</TD ><TD ALIGN="LEFT" VALIGN="TOP" >varchar(30)</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >resolution_desc</TD ><TD ALIGN="LEFT" VALIGN="TOP" >text</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >sort_order</TD ><TD ALIGN="LEFT" VALIGN="TOP" >tinyint(3) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ></TBODY ></TABLE ></DIV ><DIV CLASS="TABLE" ><A NAME="AEN1159"><P ><B >Table 3-19. Schema for table saved_query</B ></P ><TABLE BORDER="1" CLASS="CALSTABLE" ><THEAD ><TR ><TH ALIGN="LEFT" VALIGN="TOP" >Field</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Type</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Key</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Description</TH ></TR ></THEAD ><TBODY ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >saved_query_id</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" >Primary</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >user_id</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" >Primary</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >saved_query_name</TD ><TD ALIGN="LEFT" VALIGN="TOP" >varchar(40)</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >saved_query_string</TD ><TD ALIGN="LEFT" VALIGN="TOP" >text</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ></TBODY ></TABLE ></DIV ><P >The <SPAN CLASS="DATABASE" >saved_query</SPAN > table stores the queries saved by the users from the query page.</P ><DIV CLASS="TABLE" ><A NAME="AEN1191"><P ><B >Table 3-20. Schema for table severity</B ></P ><TABLE BORDER="1" CLASS="CALSTABLE" ><THEAD ><TR ><TH ALIGN="LEFT" VALIGN="TOP" >Field</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Type</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Key</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Description</TH ></TR ></THEAD ><TBODY ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >severity_id</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" >Primary</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >severity_name</TD ><TD ALIGN="LEFT" VALIGN="TOP" >varchar(30)</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >severity_desc</TD ><TD ALIGN="LEFT" VALIGN="TOP" >text</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >sort_order</TD ><TD ALIGN="LEFT" VALIGN="TOP" >tinyint(3) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >severity_color</TD ><TD ALIGN="LEFT" VALIGN="TOP" >varchar(10)</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" >The background color displayed for a row in the bug list if the <TT CLASS="VARNAME" >USE_SEVERITY_COLOR</TT > configuration option is enabled.</TD ></TR ></TBODY ></TABLE ></DIV ><DIV CLASS="TABLE" ><A NAME="AEN1227"><P ><B >Table 3-21. Schema for table status</B ></P ><TABLE BORDER="1" CLASS="CALSTABLE" ><THEAD ><TR ><TH ALIGN="LEFT" VALIGN="TOP" >Field</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Type</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Key</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Description</TH ></TR ></THEAD ><TBODY ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >status_id</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" >Primary</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >status_name</TD ><TD ALIGN="LEFT" VALIGN="TOP" >varchar(30)</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >status_desc</TD ><TD ALIGN="LEFT" VALIGN="TOP" >text</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >sort_order</TD ><TD ALIGN="LEFT" VALIGN="TOP" >tinyint(3) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ></TBODY ></TABLE ></DIV ><DIV CLASS="TABLE" ><A NAME="AEN1257"><P ><B >Table 3-22. Schema for table user_group</B ></P ><TABLE BORDER="1" CLASS="CALSTABLE" ><THEAD ><TR ><TH ALIGN="LEFT" VALIGN="TOP" >Field</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Type</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Key</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Description</TH ></TR ></THEAD ><TBODY ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >user_id</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" >Primary</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >group_id</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" >Primary</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >created_by</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >created_date</TD ><TD ALIGN="LEFT" VALIGN="TOP" >bigint(20) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ></TBODY ></TABLE ></DIV ><DIV CLASS="TABLE" ><A NAME="AEN1287"><P ><B >Table 3-23. Schema for table user_perm</B ></P ><TABLE BORDER="1" CLASS="CALSTABLE" ><THEAD ><TR ><TH ALIGN="LEFT" VALIGN="TOP" >Field</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Type</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Key</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Description</TH ></TR ></THEAD ><TBODY ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >user_id</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" >Primary</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >perm_id</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" >Primary</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ></TBODY ></TABLE ></DIV ><DIV CLASS="TABLE" ><A NAME="AEN1307"><P ><B >Table 3-24. Schema for table user_pref</B ></P ><TABLE BORDER="1" CLASS="CALSTABLE" ><THEAD ><TR ><TH ALIGN="LEFT" VALIGN="TOP" >Field</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Type</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Key</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Description</TH ></TR ></THEAD ><TBODY ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >user_id</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" >Primary</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >email_notices</TD ><TD ALIGN="LEFT" VALIGN="TOP" >tinyint(1)</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" >Whether the user wants to receive email notices from phpBugTracker. Values are 1 for yes (default) or 0 for no.</TD ></TR ></TBODY ></TABLE ></DIV ><DIV CLASS="TABLE" ><A NAME="AEN1327"><P ><B >Table 3-25. Schema for table version</B ></P ><TABLE BORDER="1" CLASS="CALSTABLE" ><THEAD ><TR ><TH ALIGN="LEFT" VALIGN="TOP" >Field</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Type</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Key</TH ><TH ALIGN="LEFT" VALIGN="TOP" >Description</TH ></TR ></THEAD ><TBODY ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >version_id</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" >Primary</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >project_id</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >version_name</TD ><TD ALIGN="LEFT" VALIGN="TOP" >char(10)</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >active</TD ><TD ALIGN="LEFT" VALIGN="TOP" >tinyint(1)</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >created_by</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >created_date</TD ><TD ALIGN="LEFT" VALIGN="TOP" >bigint(20) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >last_modified_by</TD ><TD ALIGN="LEFT" VALIGN="TOP" >int(10) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" >last_modified_date</TD ><TD ALIGN="LEFT" VALIGN="TOP" >bigint(20) unsigned</TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ><TD ALIGN="LEFT" VALIGN="TOP" > </TD ></TR ></TBODY ></TABLE ></DIV ></DIV ><DIV CLASS="NAVFOOTER" ><HR ALIGN="LEFT" WIDTH="100%"><TABLE SUMMARY="Footer navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" ><A HREF="devstandards.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="index.html" ACCESSKEY="H" >Home</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" > </TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >Development Standards</TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="devguide.html" ACCESSKEY="U" >Up</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" > </TD ></TR ></TABLE ></DIV ></BODY ></HTML >