Quick links to table definitions:
This document describes the Bugzilla database schema.
This document is generated automatically by a Perl script which constructs and colors the schema tables from a DBIx::Class::Schema object.
The purpose of this document is to act as a reference for developers of Bugzilla and of code which interacts with Bugzilla.
The intended readership is Bugzilla developers and administrators.
This document is not confidential.
Please send any comments and/or problem reports to emmanuel+bzschema@seyman.fr.
Bugzilla is a web-based general-purpose bugtracker and testing tool licensed under the MPL license.
Name | Type | Info |
---|---|---|
id | mediumint | NOT NULL, PRIMARY KEY, FOREIGN KEY |
thedata | longblob | NOT NULL |
Unique Constraints
Name | Columns |
---|---|
primary | id |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
id | foreign.attach_id => self.id |
Name | Type | Info |
---|---|---|
attach_id | mediumint | NOT NULL, PRIMARY KEY, AUTO_INCREMENT |
bug_id | mediumint | NOT NULL, FOREIGN KEY |
creation_ts | datetime | NOT NULL |
modification_time | datetime | NOT NULL |
description | tinytext | NOT NULL |
mimetype | tinytext | NOT NULL |
ispatch | tinyint | NOT NULL, DEFAULT VALUE '''''0''''' |
filename | varchar (255) | NOT NULL |
submitter_id | mediumint | NOT NULL, FOREIGN KEY |
isobsolete | tinyint | NOT NULL, DEFAULT VALUE '''''0''''' |
isprivate | tinyint | NOT NULL, DEFAULT VALUE '''''0''''' |
Unique Constraints
Name | Columns |
---|---|
primary | attach_id |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
bug | foreign.bug_id => self.bug_id | |
submitter | foreign.userid => self.submitter_id |
Name | Foreign Class | Join Condition |
---|---|---|
attach_data | foreign.id => self.attach_id |
Name | Foreign Class | Join Condition |
---|---|---|
bugs_activities | foreign.attach_id => self.attach_id | |
flags | foreign.attach_id => self.attach_id |
Name | Type | Info |
---|---|---|
user_id | mediumint | FOREIGN KEY |
class | varchar (255) | NOT NULL |
object_id | integer | NOT NULL |
field | varchar (64) | NOT NULL |
removed | mediumtext | |
added | mediumtext | |
at_time | datetime | NOT NULL |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
user | foreign.userid => self.user_id |
Name | Type | Info |
---|---|---|
bug_id | mediumint | NOT NULL, PRIMARY KEY, AUTO_INCREMENT |
assigned_to | mediumint | NOT NULL, FOREIGN KEY |
bug_file_loc | mediumtext | NOT NULL, DEFAULT VALUE '''''''''''' |
bug_severity | varchar (64) | NOT NULL |
bug_status | varchar (64) | NOT NULL |
creation_ts | datetime | |
delta_ts | datetime | NOT NULL |
short_desc | varchar (255) | NOT NULL |
op_sys | varchar (64) | NOT NULL |
priority | varchar (64) | NOT NULL |
product_id | smallint | NOT NULL, FOREIGN KEY |
rep_platform | varchar (64) | NOT NULL |
reporter | mediumint | NOT NULL, FOREIGN KEY |
version | varchar (64) | NOT NULL |
component_id | mediumint | NOT NULL, FOREIGN KEY |
resolution | varchar (64) | NOT NULL, DEFAULT VALUE '''''''''' |
target_milestone | varchar (64) | NOT NULL, DEFAULT VALUE '''''---''''' |
qa_contact | mediumint | FOREIGN KEY |
status_whiteboard | mediumtext | NOT NULL, DEFAULT VALUE '''''''''''' |
lastdiffed | datetime | |
everconfirmed | tinyint | NOT NULL |
reporter_accessible | tinyint | NOT NULL, DEFAULT VALUE '''''1''''' |
cclist_accessible | tinyint | NOT NULL, DEFAULT VALUE '''''1''''' |
estimated_time | decimal (7.2) | NOT NULL, DEFAULT VALUE '''''0.00''''' |
remaining_time | decimal (7.2) | NOT NULL, DEFAULT VALUE '''''0.00''''' |
deadline | datetime |
Unique Constraints
Name | Columns |
---|---|
primary | bug_id |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
duplicates_dupe | foreign.dupe => self.bug_id |
Name | Type | Info |
---|---|---|
bug_id | mediumint | NOT NULL, FOREIGN KEY |
group_id | mediumint | NOT NULL, FOREIGN KEY |
Unique Constraints
Name | Columns |
---|---|
bug_group_map_bug_id_idx | bug_id, group_id |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
bug | foreign.bug_id => self.bug_id | |
group | foreign.id => self.group_id |
Name | Type | Info |
---|---|---|
id | mediumint | NOT NULL, PRIMARY KEY, AUTO_INCREMENT |
bug_id | mediumint | NOT NULL, FOREIGN KEY |
value | varchar (255) | NOT NULL |
class | varchar (255) | NOT NULL, DEFAULT VALUE '''''''''' |
Unique Constraints
Name | Columns |
---|---|
primary | id |
bug_see_also_bug_id_idx | bug_id, value |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
bug | foreign.bug_id => self.bug_id |
Name | Type | Info |
---|---|---|
id | smallint | NOT NULL, PRIMARY KEY, AUTO_INCREMENT |
value | varchar (64) | NOT NULL |
sortkey | smallint | NOT NULL, DEFAULT VALUE '''''0''''' |
isactive | tinyint | NOT NULL, DEFAULT VALUE '''''1''''' |
visibility_value_id | smallint |
Unique Constraints
Name | Columns |
---|---|
bug_severity_value_idx | value |
primary | id |
Name | Type | Info |
---|---|---|
id | smallint | NOT NULL, PRIMARY KEY, AUTO_INCREMENT |
value | varchar (64) | NOT NULL |
sortkey | smallint | NOT NULL, DEFAULT VALUE '''''0''''' |
isactive | tinyint | NOT NULL, DEFAULT VALUE '''''1''''' |
visibility_value_id | smallint | |
is_open | tinyint | NOT NULL, DEFAULT VALUE '''''1''''' |
Unique Constraints
Name | Columns |
---|---|
primary | id |
bug_status_value_idx | value |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
status_workflow_new_statuses | foreign.new_status => self.id | |
status_workflow_old_statuses | foreign.old_status => self.id |
Name | Type | Info |
---|---|---|
bug_id | mediumint | NOT NULL, FOREIGN KEY |
tag_id | mediumint | NOT NULL, FOREIGN KEY |
Unique Constraints
Name | Columns |
---|---|
bug_tag_bug_id_idx | bug_id, tag_id |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
bug | foreign.bug_id => self.bug_id | |
tag | foreign.id => self.tag_id |
Name | Type | Info |
---|---|---|
id | integer | NOT NULL, PRIMARY KEY, AUTO_INCREMENT |
user_id | mediumint | NOT NULL, FOREIGN KEY |
bug_id | mediumint | NOT NULL, FOREIGN KEY |
last_visit_ts | datetime | NOT NULL |
Unique Constraints
Name | Columns |
---|---|
bug_user_last_visit_idx | user_id, bug_id |
primary | id |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
bug | foreign.bug_id => self.bug_id | |
user | foreign.userid => self.user_id |
Name | Type | Info |
---|---|---|
id | integer | NOT NULL, PRIMARY KEY, AUTO_INCREMENT |
bug_id | mediumint | NOT NULL, FOREIGN KEY |
attach_id | mediumint | FOREIGN KEY |
who | mediumint | NOT NULL, FOREIGN KEY |
bug_when | datetime | NOT NULL |
fieldid | mediumint | NOT NULL, FOREIGN KEY |
added | varchar (255) | |
removed | varchar (255) | |
comment_id | integer | FOREIGN KEY |
Unique Constraints
Name | Columns |
---|---|
primary | id |
Relationships
Name | Type | Info |
---|---|---|
alias | varchar (40) | NOT NULL |
bug_id | mediumint | FOREIGN KEY |
Unique Constraints
Name | Columns |
---|---|
bugs_aliases_alias_idx | alias |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
bug | foreign.bug_id => self.bug_id |
Name | Type | Info |
---|---|---|
bug_id | mediumint | NOT NULL, PRIMARY KEY |
short_desc | varchar (255) | NOT NULL |
comments | mediumtext | |
comments_noprivate | mediumtext |
Unique Constraints
Name | Columns |
---|---|
primary | bug_id |
Name | Type | Info |
---|---|---|
schema_data | longblob | NOT NULL |
version | decimal (3.2) | NOT NULL |
Name | Type | Info |
---|---|---|
category_id | smallint | NOT NULL, FOREIGN KEY |
group_id | mediumint | NOT NULL, FOREIGN KEY |
Unique Constraints
Name | Columns |
---|---|
category_group_map_category_id_idx | category_id, group_id |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
category | foreign.id => self.category_id | |
group | foreign.id => self.group_id |
Name | Type | Info |
---|---|---|
bug_id | mediumint | NOT NULL, FOREIGN KEY |
who | mediumint | NOT NULL, FOREIGN KEY |
Unique Constraints
Name | Columns |
---|---|
cc_bug_id_idx | bug_id, who |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
bug | foreign.bug_id => self.bug_id | |
who | foreign.userid => self.who |
Name | Type | Info |
---|---|---|
id | smallint | NOT NULL, PRIMARY KEY, AUTO_INCREMENT |
name | varchar (64) | NOT NULL |
description | mediumtext | |
sortkey | smallint | NOT NULL, DEFAULT VALUE '''''0''''' |
Unique Constraints
Name | Columns |
---|---|
classifications_name_idx | name |
primary | id |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
products | foreign.classification_id => self.id |
Name | Type | Info |
---|---|---|
id | mediumint | NOT NULL, PRIMARY KEY, AUTO_INCREMENT |
name | varchar (64) | NOT NULL |
product_id | smallint | NOT NULL, FOREIGN KEY |
initialowner | mediumint | NOT NULL, FOREIGN KEY |
initialqacontact | mediumint | FOREIGN KEY |
description | mediumtext | NOT NULL |
isactive | tinyint | NOT NULL, DEFAULT VALUE '''''1''''' |
Unique Constraints
Name | Columns |
---|---|
primary | id |
components_product_id_idx | product_id, name |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
initialowner | foreign.userid => self.initialowner | |
initialqacontact | foreign.userid => self.initialqacontact | |
product | foreign.id => self.product_id |
Name | Type | Info |
---|---|---|
user_id | mediumint | NOT NULL, FOREIGN KEY |
component_id | mediumint | NOT NULL, FOREIGN KEY |
Unique Constraints
Name | Columns |
---|---|
component_cc_user_id_idx | component_id, user_id |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
component | foreign.id => self.component_id | |
user | foreign.userid => self.user_id |
Name | Type | Info |
---|---|---|
blocked | mediumint | NOT NULL, FOREIGN KEY |
dependson | mediumint | NOT NULL, FOREIGN KEY |
Unique Constraints
Name | Columns |
---|---|
dependencies_blocked_idx | blocked, dependson |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
blocked | foreign.bug_id => self.blocked | |
dependson | foreign.bug_id => self.dependson |
Name | Type | Info |
---|---|---|
dupe_of | mediumint | NOT NULL, FOREIGN KEY |
dupe | mediumint | NOT NULL, PRIMARY KEY, FOREIGN KEY |
Unique Constraints
Name | Columns |
---|---|
primary | dupe |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
dupe | foreign.bug_id => self.dupe | |
dupe_of | foreign.bug_id => self.dupe_of |
Name | Type | Info |
---|---|---|
user_id | mediumint | NOT NULL, FOREIGN KEY |
bug_id | mediumint | NOT NULL, FOREIGN KEY |
Unique Constraints
Name | Columns |
---|---|
email_bug_ignore_user_id_idx | user_id, bug_id |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
bug | foreign.bug_id => self.bug_id | |
user | foreign.userid => self.user_id |
Name | Type | Info |
---|---|---|
user_id | mediumint | NOT NULL, FOREIGN KEY |
relationship | tinyint | NOT NULL |
event | tinyint | NOT NULL |
Unique Constraints
Name | Columns |
---|---|
email_setting_user_id_idx | user_id, relationship, event |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
user | foreign.userid => self.user_id |
Name | Type | Info |
---|---|---|
field_id | mediumint | FOREIGN KEY |
value_id | smallint | NOT NULL |
Unique Constraints
Name | Columns |
---|---|
field_visibility_field_id_idx | field_id, value_id |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
field | foreign.id => self.field_id |
Name | Type | Info |
---|---|---|
id | mediumint | NOT NULL, PRIMARY KEY, AUTO_INCREMENT |
name | varchar (64) | NOT NULL |
type | smallint | NOT NULL, DEFAULT VALUE '''''0''''' |
custom | tinyint | NOT NULL, DEFAULT VALUE '''''0''''' |
description | tinytext | NOT NULL |
long_desc | varchar (255) | NOT NULL, DEFAULT VALUE '''''''''' |
mailhead | tinyint | NOT NULL, DEFAULT VALUE '''''0''''' |
sortkey | smallint | NOT NULL |
obsolete | tinyint | NOT NULL, DEFAULT VALUE '''''0''''' |
enter_bug | tinyint | NOT NULL, DEFAULT VALUE '''''0''''' |
buglist | tinyint | NOT NULL, DEFAULT VALUE '''''0''''' |
visibility_field_id | mediumint | FOREIGN KEY |
value_field_id | mediumint | FOREIGN KEY |
reverse_desc | tinytext | |
is_mandatory | tinyint | NOT NULL, DEFAULT VALUE '''''0''''' |
is_numeric | tinyint | NOT NULL, DEFAULT VALUE '''''0''''' |
Unique Constraints
Name | Columns |
---|---|
primary | id |
fielddefs_name_idx | name |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
value_field | foreign.id => self.value_field_id | |
visibility_field | foreign.id => self.visibility_field_id |
Name | Type | Info |
---|---|---|
id | mediumint | NOT NULL, PRIMARY KEY, AUTO_INCREMENT |
type_id | smallint | NOT NULL, FOREIGN KEY |
status | char (1) | NOT NULL |
bug_id | mediumint | NOT NULL, FOREIGN KEY |
attach_id | mediumint | FOREIGN KEY |
creation_date | datetime | NOT NULL |
modification_date | datetime | |
setter_id | mediumint | NOT NULL, FOREIGN KEY |
requestee_id | mediumint | FOREIGN KEY |
Unique Constraints
Name | Columns |
---|---|
primary | id |
Relationships
Name | Type | Info |
---|---|---|
type_id | smallint | NOT NULL, FOREIGN KEY |
product_id | smallint | FOREIGN KEY |
component_id | mediumint | FOREIGN KEY |
Unique Constraints
Name | Columns |
---|---|
flagexclusions_type_id_idx | type_id, product_id, component_id |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
component | foreign.id => self.component_id | |
product | foreign.id => self.product_id | |
type | foreign.id => self.type_id |
Name | Type | Info |
---|---|---|
type_id | smallint | NOT NULL, FOREIGN KEY |
product_id | smallint | FOREIGN KEY |
component_id | mediumint | FOREIGN KEY |
Unique Constraints
Name | Columns |
---|---|
flaginclusions_type_id_idx | type_id, product_id, component_id |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
component | foreign.id => self.component_id | |
product | foreign.id => self.product_id | |
type | foreign.id => self.type_id |
Name | Type | Info |
---|---|---|
id | smallint | NOT NULL, PRIMARY KEY, AUTO_INCREMENT |
name | varchar (50) | NOT NULL |
description | mediumtext | NOT NULL |
cc_list | varchar (200) | |
target_type | char (1) | NOT NULL, DEFAULT VALUE '''''b''''' |
is_active | tinyint | NOT NULL, DEFAULT VALUE '''''1''''' |
is_requestable | tinyint | NOT NULL, DEFAULT VALUE '''''0''''' |
is_requesteeble | tinyint | NOT NULL, DEFAULT VALUE '''''0''''' |
is_multiplicable | tinyint | NOT NULL, DEFAULT VALUE '''''0''''' |
sortkey | smallint | NOT NULL, DEFAULT VALUE '''''0''''' |
grant_group_id | mediumint | FOREIGN KEY |
request_group_id | mediumint | FOREIGN KEY |
Unique Constraints
Name | Columns |
---|---|
primary | id |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
grant_group | foreign.id => self.grant_group_id | |
request_group | foreign.id => self.request_group_id |
Name | Foreign Class | Join Condition |
---|---|---|
flagexclusions | foreign.type_id => self.id | |
flaginclusions | foreign.type_id => self.id | |
flags | foreign.type_id => self.id |
Name | Type | Info |
---|---|---|
id | mediumint | NOT NULL, PRIMARY KEY, AUTO_INCREMENT |
name | varchar (255) | NOT NULL |
description | mediumtext | NOT NULL |
isbuggroup | tinyint | NOT NULL |
userregexp | tinytext | NOT NULL, DEFAULT VALUE '''''''''''' |
isactive | tinyint | NOT NULL, DEFAULT VALUE '''''1''''' |
icon_url | tinytext |
Unique Constraints
Name | Columns |
---|---|
groups_name_idx | name |
primary | id |
Relationships
Name | Type | Info |
---|---|---|
group_id | mediumint | NOT NULL, FOREIGN KEY |
product_id | smallint | NOT NULL, FOREIGN KEY |
entry | tinyint | NOT NULL, DEFAULT VALUE '''''0''''' |
membercontrol | tinyint | NOT NULL, DEFAULT VALUE '''''0''''' |
othercontrol | tinyint | NOT NULL, DEFAULT VALUE '''''0''''' |
canedit | tinyint | NOT NULL, DEFAULT VALUE '''''0''''' |
editcomponents | tinyint | NOT NULL, DEFAULT VALUE '''''0''''' |
editbugs | tinyint | NOT NULL, DEFAULT VALUE '''''0''''' |
canconfirm | tinyint | NOT NULL, DEFAULT VALUE '''''0''''' |
Unique Constraints
Name | Columns |
---|---|
group_control_map_product_id_idx | product_id, group_id |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
group | foreign.id => self.group_id | |
product | foreign.id => self.product_id |
Name | Type | Info |
---|---|---|
member_id | mediumint | NOT NULL, FOREIGN KEY |
grantor_id | mediumint | NOT NULL, FOREIGN KEY |
grant_type | tinyint | NOT NULL, DEFAULT VALUE '''''0''''' |
Unique Constraints
Name | Columns |
---|---|
group_group_map_member_id_idx | member_id, grantor_id, grant_type |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
grantor | foreign.id => self.grantor_id | |
member | foreign.id => self.member_id |
Name | Type | Info |
---|---|---|
bug_id | mediumint | NOT NULL, FOREIGN KEY |
keywordid | smallint | NOT NULL, FOREIGN KEY |
Unique Constraints
Name | Columns |
---|---|
keywords_bug_id_idx | bug_id, keywordid |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
bug | foreign.bug_id => self.bug_id | |
keywordid | foreign.id => self.keywordid |
Name | Type | Info |
---|---|---|
id | smallint | NOT NULL, PRIMARY KEY, AUTO_INCREMENT |
name | varchar (64) | NOT NULL |
description | mediumtext | NOT NULL |
Unique Constraints
Name | Columns |
---|---|
keyworddefs_name_idx | name |
primary | id |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
keywords | foreign.keywordid => self.id |
Name | Type | Info |
---|---|---|
user_id | mediumint | NOT NULL, FOREIGN KEY |
login_time | datetime | NOT NULL |
ip_addr | varchar (40) | NOT NULL |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
user | foreign.userid => self.user_id |
Name | Type | Info |
---|---|---|
cookie | varchar (16) | NOT NULL, PRIMARY KEY |
userid | mediumint | NOT NULL, FOREIGN KEY |
ipaddr | varchar (40) | |
lastused | datetime | NOT NULL |
Unique Constraints
Name | Columns |
---|---|
primary | cookie |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
userid | foreign.userid => self.userid |
Name | Type | Info |
---|---|---|
comment_id | integer | NOT NULL, PRIMARY KEY, AUTO_INCREMENT |
bug_id | mediumint | NOT NULL, FOREIGN KEY |
who | mediumint | NOT NULL, FOREIGN KEY |
bug_when | datetime | NOT NULL |
work_time | decimal (7.2) | NOT NULL, DEFAULT VALUE '''''0.00''''' |
thetext | mediumtext | NOT NULL |
isprivate | tinyint | NOT NULL, DEFAULT VALUE '''''0''''' |
already_wrapped | tinyint | NOT NULL, DEFAULT VALUE '''''0''''' |
type | smallint | NOT NULL, DEFAULT VALUE '''''0''''' |
extra_data | varchar (255) |
Unique Constraints
Name | Columns |
---|---|
primary | comment_id |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
bug | foreign.bug_id => self.bug_id | |
who | foreign.userid => self.who |
Name | Type | Info |
---|---|---|
id | mediumint | NOT NULL, PRIMARY KEY, AUTO_INCREMENT |
comment_id | integer | FOREIGN KEY |
tag | varchar (24) | NOT NULL |
Unique Constraints
Name | Columns |
---|---|
primary | id |
longdescs_tags_idx | comment_id, tag |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
comment | foreign.comment_id => self.comment_id |
Name | Type | Info |
---|---|---|
id | mediumint | NOT NULL, PRIMARY KEY, AUTO_INCREMENT |
bug_id | mediumint | NOT NULL, FOREIGN KEY |
comment_id | integer | FOREIGN KEY |
who | mediumint | NOT NULL, FOREIGN KEY |
bug_when | datetime | NOT NULL |
added | varchar (24) | |
removed | varchar (24) |
Unique Constraints
Name | Columns |
---|---|
primary | id |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
bug | foreign.bug_id => self.bug_id | |
comment | foreign.comment_id => self.comment_id | |
who | foreign.userid => self.who |
Name | Type | Info |
---|---|---|
id | mediumint | NOT NULL, PRIMARY KEY, AUTO_INCREMENT |
tag | varchar (24) | NOT NULL |
weight | mediumint | NOT NULL |
Unique Constraints
Name | Columns |
---|---|
longdescs_tags_weights_tag_idx | tag |
primary | id |
Name | Type | Info |
---|---|---|
id | integer | NOT NULL, PRIMARY KEY, AUTO_INCREMENT |
message | longblob | NOT NULL |
Unique Constraints
Name | Columns |
---|---|
primary | id |
Name | Type | Info |
---|---|---|
id | mediumint | NOT NULL, PRIMARY KEY, AUTO_INCREMENT |
product_id | smallint | NOT NULL, FOREIGN KEY |
value | varchar (64) | NOT NULL |
sortkey | smallint | NOT NULL, DEFAULT VALUE '''''0''''' |
isactive | tinyint | NOT NULL, DEFAULT VALUE '''''1''''' |
Unique Constraints
Name | Columns |
---|---|
primary | id |
milestones_product_id_idx | product_id, value |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
product | foreign.id => self.product_id |
Name | Type | Info |
---|---|---|
namedquery_id | mediumint | NOT NULL, FOREIGN KEY |
user_id | mediumint | NOT NULL, FOREIGN KEY |
Unique Constraints
Name | Columns |
---|---|
namedqueries_link_in_footer_id_idx | namedquery_id, user_id |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
namedquery | foreign.id => self.namedquery_id | |
user | foreign.userid => self.user_id |
Name | Type | Info |
---|---|---|
id | mediumint | NOT NULL, PRIMARY KEY, AUTO_INCREMENT |
userid | mediumint | NOT NULL, FOREIGN KEY |
name | varchar (64) | NOT NULL |
query | mediumtext | NOT NULL |
Unique Constraints
Name | Columns |
---|---|
namedqueries_userid_idx | userid, name |
primary | id |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
userid | foreign.userid => self.userid |
Name | Foreign Class | Join Condition |
---|---|---|
namedquery_group_map | foreign.namedquery_id => self.id |
Name | Foreign Class | Join Condition |
---|---|---|
namedqueries_links_in_footer | foreign.namedquery_id => self.id |
Name | Type | Info |
---|---|---|
namedquery_id | mediumint | NOT NULL, FOREIGN KEY |
group_id | mediumint | NOT NULL, FOREIGN KEY |
Unique Constraints
Name | Columns |
---|---|
namedquery_group_map_namedquery_id_idx | namedquery_id |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
group | foreign.id => self.group_id | |
namedquery | foreign.id => self.namedquery_id |
Name | Type | Info |
---|---|---|
id | smallint | NOT NULL, PRIMARY KEY, AUTO_INCREMENT |
value | varchar (64) | NOT NULL |
sortkey | smallint | NOT NULL, DEFAULT VALUE '''''0''''' |
isactive | tinyint | NOT NULL, DEFAULT VALUE '''''1''''' |
visibility_value_id | smallint |
Unique Constraints
Name | Columns |
---|---|
op_sys_value_idx | value |
primary | id |
Name | Type | Info |
---|---|---|
id | smallint | NOT NULL, PRIMARY KEY, AUTO_INCREMENT |
value | varchar (64) | NOT NULL |
sortkey | smallint | NOT NULL, DEFAULT VALUE '''''0''''' |
isactive | tinyint | NOT NULL, DEFAULT VALUE '''''1''''' |
visibility_value_id | smallint |
Unique Constraints
Name | Columns |
---|---|
priority_value_idx | value |
primary | id |
Name | Type | Info |
---|---|---|
id | smallint | NOT NULL, PRIMARY KEY, AUTO_INCREMENT |
name | varchar (64) | NOT NULL |
classification_id | smallint | NOT NULL, DEFAULT VALUE '''''1''''', FOREIGN KEY |
description | mediumtext | NOT NULL |
isactive | tinyint | NOT NULL, DEFAULT VALUE '''''1''''' |
defaultmilestone | varchar (64) | NOT NULL, DEFAULT VALUE '''''---''''' |
allows_unconfirmed | tinyint | NOT NULL, DEFAULT VALUE '''''1''''' |
Unique Constraints
Name | Columns |
---|---|
primary | id |
products_name_idx | name |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
classification | foreign.id => self.classification_id |
Name | Type | Info |
---|---|---|
userid | mediumint | NOT NULL, PRIMARY KEY, AUTO_INCREMENT |
login_name | varchar (255) | NOT NULL |
cryptpassword | varchar (128) | |
realname | varchar (255) | NOT NULL, DEFAULT VALUE '''''''''' |
disabledtext | mediumtext | NOT NULL, DEFAULT VALUE '''''''''''' |
disable_mail | tinyint | NOT NULL, DEFAULT VALUE '''''0''''' |
mybugslink | tinyint | NOT NULL, DEFAULT VALUE '''''1''''' |
extern_id | varchar (64) | |
is_enabled | tinyint | NOT NULL, DEFAULT VALUE '''''1''''' |
last_seen_date | datetime |
Unique Constraints
Name | Columns |
---|---|
profiles_extern_id_idx | extern_id |
profiles_login_name_idx | login_name |
primary | userid |
Relationships
Name | Type | Info |
---|---|---|
id | integer | NOT NULL, PRIMARY KEY, AUTO_INCREMENT |
user_id | mediumint | NOT NULL, FOREIGN KEY |
bug_list | mediumtext | NOT NULL |
list_order | mediumtext |
Unique Constraints
Name | Columns |
---|---|
primary | id |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
user | foreign.userid => self.user_id |
Name | Type | Info |
---|---|---|
user_id | mediumint | NOT NULL, FOREIGN KEY |
setting_name | varchar (32) | NOT NULL, FOREIGN KEY |
setting_value | varchar (32) | NOT NULL |
Unique Constraints
Name | Columns |
---|---|
profile_setting_value_unique_idx | user_id, setting_name |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
setting_name | foreign.name => self.setting_name | |
user | foreign.userid => self.user_id |
Name | Type | Info |
---|---|---|
id | mediumint | NOT NULL, PRIMARY KEY, AUTO_INCREMENT |
userid | mediumint | NOT NULL, FOREIGN KEY |
who | mediumint | NOT NULL, FOREIGN KEY |
profiles_when | datetime | NOT NULL |
fieldid | mediumint | NOT NULL, FOREIGN KEY |
oldvalue | tinytext | |
newvalue | tinytext |
Unique Constraints
Name | Columns |
---|---|
primary | id |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
fieldid | foreign.id => self.fieldid | |
userid | foreign.userid => self.userid | |
who | foreign.userid => self.who |
Name | Type | Info |
---|---|---|
quipid | mediumint | NOT NULL, PRIMARY KEY, AUTO_INCREMENT |
userid | mediumint | FOREIGN KEY |
quip | varchar (512) | NOT NULL |
approved | tinyint | NOT NULL, DEFAULT VALUE '''''1''''' |
Unique Constraints
Name | Columns |
---|---|
primary | quipid |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
userid | foreign.userid => self.userid |
Name | Type | Info |
---|---|---|
id | smallint | NOT NULL, PRIMARY KEY, AUTO_INCREMENT |
value | varchar (64) | NOT NULL |
sortkey | smallint | NOT NULL, DEFAULT VALUE '''''0''''' |
isactive | tinyint | NOT NULL, DEFAULT VALUE '''''1''''' |
visibility_value_id | smallint |
Unique Constraints
Name | Columns |
---|---|
rep_platform_value_idx | value |
primary | id |
Name | Type | Info |
---|---|---|
id | mediumint | NOT NULL, PRIMARY KEY, AUTO_INCREMENT |
user_id | mediumint | NOT NULL, FOREIGN KEY |
name | varchar (64) | NOT NULL |
query | mediumtext | NOT NULL |
Unique Constraints
Name | Columns |
---|---|
primary | id |
reports_user_id_idx | user_id, name |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
user | foreign.userid => self.user_id |
Name | Type | Info |
---|---|---|
id | smallint | NOT NULL, PRIMARY KEY, AUTO_INCREMENT |
value | varchar (64) | NOT NULL |
sortkey | smallint | NOT NULL, DEFAULT VALUE '''''0''''' |
isactive | tinyint | NOT NULL, DEFAULT VALUE '''''1''''' |
visibility_value_id | smallint |
Unique Constraints
Name | Columns |
---|---|
primary | id |
resolution_value_idx | value |
Name | Type | Info |
---|---|---|
series_id | mediumint | NOT NULL, PRIMARY KEY, AUTO_INCREMENT |
creator | mediumint | FOREIGN KEY |
category | smallint | NOT NULL, FOREIGN KEY |
subcategory | smallint | NOT NULL, FOREIGN KEY |
name | varchar (64) | NOT NULL |
frequency | smallint | NOT NULL |
query | mediumtext | NOT NULL |
is_public | tinyint | NOT NULL, DEFAULT VALUE '''''0''''' |
Unique Constraints
Name | Columns |
---|---|
primary | series_id |
series_category_idx | category, subcategory, name |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
category | foreign.id => self.category | |
creator | foreign.userid => self.creator | |
subcategory | foreign.id => self.subcategory |
Name | Foreign Class | Join Condition |
---|---|---|
series_datas | foreign.series_id => self.series_id |
Name | Type | Info |
---|---|---|
id | smallint | NOT NULL, PRIMARY KEY, AUTO_INCREMENT |
name | varchar (64) | NOT NULL |
Unique Constraints
Name | Columns |
---|---|
series_categories_name_idx | name |
primary | id |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
category_group_maps | foreign.category_id => self.id | |
series_categories | foreign.category => self.id | |
series_subcategories | foreign.subcategory => self.id |
Name | Type | Info |
---|---|---|
series_id | mediumint | NOT NULL, FOREIGN KEY |
series_date | datetime | NOT NULL |
series_value | mediumint | NOT NULL |
Unique Constraints
Name | Columns |
---|---|
series_data_series_id_idx | series_id, series_date |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
series | foreign.series_id => self.series_id |
Name | Type | Info |
---|---|---|
name | varchar (32) | NOT NULL, PRIMARY KEY |
default_value | varchar (32) | NOT NULL |
is_enabled | tinyint | NOT NULL, DEFAULT VALUE '''''1''''' |
subclass | varchar (32) |
Unique Constraints
Name | Columns |
---|---|
primary | name |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
profile_settings | foreign.setting_name => self.name | |
setting_values | foreign.name => self.name |
Name | Type | Info |
---|---|---|
name | varchar (32) | NOT NULL, FOREIGN KEY |
value | varchar (32) | NOT NULL |
sortindex | smallint | NOT NULL |
Unique Constraints
Name | Columns |
---|---|
setting_value_ns_unique_idx | name, sortindex |
setting_value_nv_unique_idx | name, value |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
name | foreign.name => self.name |
Name | Type | Info |
---|---|---|
old_status | smallint | FOREIGN KEY |
new_status | smallint | NOT NULL, FOREIGN KEY |
require_comment | tinyint | NOT NULL, DEFAULT VALUE '''''0''''' |
Unique Constraints
Name | Columns |
---|---|
status_workflow_idx | old_status, new_status |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
new_status | foreign.id => self.new_status | |
old_status | foreign.id => self.old_status |
Name | Type | Info |
---|---|---|
id | mediumint | NOT NULL, PRIMARY KEY, AUTO_INCREMENT |
name | varchar (64) | NOT NULL |
user_id | mediumint | NOT NULL, FOREIGN KEY |
Unique Constraints
Name | Columns |
---|---|
primary | id |
tag_user_id_idx | user_id, name |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
user | foreign.userid => self.user_id |
Name | Foreign Class | Join Condition |
---|---|---|
bug_tags | foreign.tag_id => self.id |
Name | Type | Info |
---|---|---|
userid | mediumint | FOREIGN KEY |
issuedate | datetime | NOT NULL |
token | varchar (16) | NOT NULL, PRIMARY KEY |
tokentype | varchar (16) | NOT NULL |
eventdata | tinytext |
Unique Constraints
Name | Columns |
---|---|
primary | token |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
userid | foreign.userid => self.userid |
Name | Type | Info |
---|---|---|
error_time | integer | NOT NULL |
jobid | integer | NOT NULL |
message | varchar (255) | NOT NULL |
funcid | integer | NOT NULL, DEFAULT VALUE '''''0''''' |
Name | Type | Info |
---|---|---|
jobid | integer | NOT NULL, PRIMARY KEY, AUTO_INCREMENT |
funcid | integer | NOT NULL, DEFAULT VALUE '''''0''''' |
status | smallint | |
completion_time | integer | |
delete_after | integer |
Unique Constraints
Name | Columns |
---|---|
primary | jobid |
Name | Type | Info |
---|---|---|
funcid | integer | NOT NULL, PRIMARY KEY, AUTO_INCREMENT |
funcname | varchar (255) | NOT NULL |
Unique Constraints
Name | Columns |
---|---|
primary | funcid |
ts_funcmap_funcname_idx | funcname |
Name | Type | Info |
---|---|---|
jobid | integer | NOT NULL, PRIMARY KEY, AUTO_INCREMENT |
funcid | integer | NOT NULL |
arg | longblob | |
uniqkey | varchar (255) | |
insert_time | integer | |
run_after | integer | NOT NULL |
grabbed_until | integer | NOT NULL |
priority | smallint | |
coalesce | varchar (255) |
Unique Constraints
Name | Columns |
---|---|
primary | jobid |
ts_job_funcid_idx | funcid, uniqkey |
Name | Type | Info |
---|---|---|
jobid | integer | NOT NULL |
notekey | varchar (255) | |
value | longblob |
Unique Constraints
Name | Columns |
---|---|
ts_note_jobid_idx | jobid, notekey |
Name | Type | Info |
---|---|---|
id | integer | NOT NULL, PRIMARY KEY, AUTO_INCREMENT |
user_id | mediumint | NOT NULL, FOREIGN KEY |
api_key | varchar (40) | NOT NULL |
description | varchar (255) | |
revoked | tinyint | NOT NULL, DEFAULT VALUE '''''0''''' |
last_used | datetime |
Unique Constraints
Name | Columns |
---|---|
user_api_keys_api_key_idx | api_key |
primary | id |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
user | foreign.userid => self.user_id |
Name | Type | Info |
---|---|---|
user_id | mediumint | NOT NULL, FOREIGN KEY |
group_id | mediumint | NOT NULL, FOREIGN KEY |
isbless | tinyint | NOT NULL, DEFAULT VALUE '''''0''''' |
grant_type | tinyint | NOT NULL, DEFAULT VALUE '''''0''''' |
Unique Constraints
Name | Columns |
---|---|
user_group_map_user_id_idx | user_id, group_id, grant_type, isbless |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
group | foreign.id => self.group_id | |
user | foreign.userid => self.user_id |
Name | Type | Info |
---|---|---|
id | mediumint | NOT NULL, PRIMARY KEY, AUTO_INCREMENT |
value | varchar (64) | NOT NULL |
product_id | smallint | NOT NULL, FOREIGN KEY |
isactive | tinyint | NOT NULL, DEFAULT VALUE '''''1''''' |
Unique Constraints
Name | Columns |
---|---|
primary | id |
versions_product_id_idx | product_id, value |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
product | foreign.id => self.product_id |
Name | Type | Info |
---|---|---|
watcher | mediumint | NOT NULL, FOREIGN KEY |
watched | mediumint | NOT NULL, FOREIGN KEY |
Unique Constraints
Name | Columns |
---|---|
watch_watcher_idx | watcher, watched |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
watched | foreign.userid => self.watched | |
watcher | foreign.userid => self.watcher |
Name | Type | Info |
---|---|---|
id | mediumint | NOT NULL, PRIMARY KEY, AUTO_INCREMENT |
owner_userid | mediumint | NOT NULL, FOREIGN KEY |
subject | varchar (128) | |
body | mediumtext | |
mailifnobugs | tinyint | NOT NULL, DEFAULT VALUE '''''0''''' |
Unique Constraints
Name | Columns |
---|---|
primary | id |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
owner_userid | foreign.userid => self.owner_userid |
Name | Foreign Class | Join Condition |
---|---|---|
whine_queries | foreign.eventid => self.id | |
whine_schedules | foreign.eventid => self.id |
Name | Type | Info |
---|---|---|
id | mediumint | NOT NULL, PRIMARY KEY, AUTO_INCREMENT |
eventid | mediumint | NOT NULL, FOREIGN KEY |
query_name | varchar (64) | NOT NULL, DEFAULT VALUE '''''''''' |
sortkey | smallint | NOT NULL, DEFAULT VALUE '''''0''''' |
onemailperbug | tinyint | NOT NULL, DEFAULT VALUE '''''0''''' |
title | varchar (128) | NOT NULL, DEFAULT VALUE '''''''''' |
Unique Constraints
Name | Columns |
---|---|
primary | id |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
eventid | foreign.id => self.eventid |
Name | Type | Info |
---|---|---|
id | mediumint | NOT NULL, PRIMARY KEY, AUTO_INCREMENT |
eventid | mediumint | NOT NULL, FOREIGN KEY |
run_day | varchar (32) | |
run_time | varchar (32) | |
run_next | datetime | |
mailto | mediumint | NOT NULL |
mailto_type | smallint | NOT NULL, DEFAULT VALUE '''''0''''' |
Unique Constraints
Name | Columns |
---|---|
primary | id |
Relationships
Name | Foreign Class | Join Condition |
---|---|---|
eventid | foreign.id => self.eventid |
A table giving the dates of all the Bugzilla releases will soon be generated.
To select bug number n:
select * from bugs where bug_id = n
To get a complete list of user ids and email addresses:
select userid, login_name from profiles
To get the email address of user n:
select login_name from profiles where userid = n
To get the set of cc addresses of bug n:
select login_name from cc, profiles
where cc.bug_id = n
and profiles.userid = cc.who
To select the long descriptions of bug n, together with the name and email address of the commenters:
select profiles.login_name, profiles.realname,
longdescs.bug_when, longdescs.thetext
from longdescs, profiles
where profiles.userid = longdescs.who
and longdescs.bug_id = n
order by longdescs.bug_when
To find out the groups of user n:
select group_id from user_group_map where userid = n and isbless=0