ReleaseEngineering/Buildbot Database Schemas: Difference between revisions
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
All data featured here is accurate as of Wednesday, July 17th, 2013. | All data featured here is accurate as of Wednesday, July 17th, 2013. | ||
== Statusdb == | == Statusdb == | ||
Statusdb is where buildbot stores all of the status information on jobs. | Statusdb is where buildbot stores all of the status information on jobs. Statusdb is defined [http://hg.mozilla.org/build/buildbotcustom/file/4d263601be8c/status/db/model.py|here] | ||
=== Overview === | === Overview === | ||
Here is a list of all the tables represented in Statusdb. | Here is a list of all the tables represented in Statusdb. | ||
Revision as of 01:46, 25 July 2013
All data featured here is accurate as of Wednesday, July 17th, 2013.
Statusdb
Statusdb is where buildbot stores all of the status information on jobs. Statusdb is defined [1]
Overview
Here is a list of all the tables represented in Statusdb.
Schemas for each Table
These are the schemas for each table in Statusdb.
| property_id | int(11) | NO | MUL | NULL | |
| build_id | int(11) | NO | MUL | NULL | |
| build_id | int(11) | NO | MUL | NULL | |
| request_id | int(11) | NO | MUL | NULL | |
| id | int(11) | NO | PRI | NULL | auto_increment |
| builder_id | int(11) | NO | MUL | NULL | |
| slave_id | int(11) | NO | MUL | NULL | |
| added | datetime | NO | MUL | NULL | |
| removed | datetime | YES | MUL | NULL | |
| id | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(200) | NO | MUL | NULL | |
| master_id | int(11) | NO | MUL | NULL | |
| category | varchar(30) | YES | MUL | NULL | |
| id | int(11) | NO | PRI | NULL | auto_increment |
| buildnumber | int(11) | NO | MUL | NULL | |
| builder_id | int(11) | NO | MUL | NULL | |
| slave_id | int(11) | NO | MUL | NULL | |
| master_id | int(11) | NO | MUL | NULL | |
| starttime | datetime | YES | MUL | NULL | |
| endtime | datetime | YES | MUL | NULL | |
| result | int(11) | YES | MUL | NULL | |
| reason | varchar(500) | YES | NULL | ||
| source_id | int(11) | YES | MUL | NULL | |
| lost | tinyint(1) | NO | NULL | ||
| id | int(11) | NO | PRI | NULL | auto_increment |
| number | int(11) | NO | NULL | ||
| branch | varchar(50) | YES | NULL | ||
| revision | varchar(50) | YES | MUL | ||
| who | varchar(200) | YES | MUL | MUL | |
| comments | text | YES | NULL | ||
| when | datetime | YES | NULL | ||
| file_id | int(11) | NO | MUL | NULL | |
| change_id | int(11) | NO | MUL | NULL | |
| id | int(11) | NO | PRI | NULL | auto_increment |
| path | varchar(400) | NO | MUL | NULL | |
| id | int(11) | NO | PRI | NULL | auto_increment |
| slave_id | int(11) | NO | MUL | NULL | |
| master_id | int(11) | NO | MUL | NULL | |
| connected | datetime | NO | MUL | NULL | |
| disconnected | datetime | YES | MUL | NULL | |
| id | int(11) | NO | PRI | NULL | auto_increment |
| url | varchar(100) | YES | UNI | NULL | |
| name | varchar(100) | YES | NULL | ||
| id | int(11) | NO | PRI | NULL | auto_increment |
| patch | text | YES | NULL | ||
| patchlevel | int(11) | YES | NULL | ||
| id | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(40) | YES | MUL | NULL | |
| source | varchar(40) | YES | MUL | NULL | |
| value | text | YES | NULL | ||
| property_id | int(11) | NO | MUL | NULL | |
| request_id | int(11) | NO | MUL | NULL | |
| id | int(11) | NO | PRI | NULL | auto_increment |
| submittime | datetime | YES | MUL | NULL | |
| builder_id | int(11) | YES | MUL | NULL | |
| startcount | int(11) | NO | MUL | NULL | |
| source_id | int(11) | YES | MUL | NULL | |
| lost | tinyint(1) | NO | MUL | NULL | |
| cancelled | tinyint(1) | NO | MUL | NULL | |
| status_build_id | int(11) | NO | MUL | NULL | |
| scheduler_request_id | int(11) | NO | MUL | NULL | |
| scheduler_build_id | int(11) | NO | MUL | NULL | |
| id | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(50) | NO | MUL | NULL | |
| source_id | int(11) | NO | MUL | NULL | |
| change_id | int(11) | NO | MUL | NULL | |
| order | int(11) | NO | NULL | ||
| id | int(11) | NO | PRI | NULL | auto_increment |
| id | int(11) | NO | PRI | NULL | auto_increment |
| branch | varchar(50) | YES | NULL | ||
| revision | varchar(50) | YES | MUL | NULL | |
| patch_id | int(11) | YES | MUL | NULL | |
| id | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(256) | NO | MUL | NULL | |
| description | text | YES | NULL | ||
| build_id | int(11) | NO | MUL | NULL | |
| order | int(11) | NO | NULL | ||
| starttime | datetime | YES | NULL | ||
| endtime | datetime | YES | NULL | ||
| status | int(11) | YES | MUL | NULL | |
Schedulerdb
Schedulerdb is where buildbot stores all of the scheduling information for jobs.
Overview
Here is a list of all the tables represented in Schedulerdb.
Schemas for each Table
These are the schemas for each table in Schedulerdb.
| id | int(11) | NO | PRI | NULL | auto_increment |
| buildsetid | int(11) | NO | MUL | NULL | |
| buildername | varchar(256) | NO | MUL | NULL | |
| priority | int(11) | NO | 0 | ||
| claimed_at | int(11) | YES | MUL | 0 | |
| claimed_by_name | varchar(256) | YES | MUL | NULL | |
| claimed_by_incarnation | varchar(256) | YES | NULL | ||
| complete | int(11) | YES | MUL | 0 | |
| results | smallint(6) | YES | NULL | ||
| submitted_at | int(11) | NO | NULL | ||
| complete_at | int(11) | YES | NULL | ||
| id | int(11) | NO | PRI | NULL | auto_increment |
| number | int(11) | NO | MUL | NULL | |
| brid | int(11) | NO | MUL | NULL | |
| start_time | int(11) | NO | MUL | NULL | |
| finish_time | int(11) | YES | MUL | NULL | |
| buildsetid | int(11) | NO | MUL | NULL | |
| property_name | varchar(256) | NO | NULL | ||
| property_value | varchar(1024) | NO | NULL | ||
| id | int(11) | NO | PRI | NULL | auto_increment |
| external_idstring | varchar(256) | YES | NULL | ||
| reason | varchar(256) | YES | NULL | ||
| sourcestampid | int(11) | NO | MUL | NULL | |
| submitted_at | int(11) | NO | MUL | NULL | |
| complete | smallint(6) | NO | MUL | 0 | |
| complete_at | int(11) | YES | NULL | ||
| results | smallint(6) | YES | NULL | ||
| changeid | int(11) | NO | MUL | NULL | |
| filename | varchar(1024) | NO | NULL | ||
| changeid | int(11) | NO | MUL | NULL | |
| link | varchar(1024) | NO | NULL | ||
| changeid | int(11) | NO | MUL | NULL | |
| property_name | varchar(256) | NO | NULL | ||
| property_value | varchar(1024) | NO | NULL | ||
| changeid | int(11) | NO | PRI | NULL | auto_increment |
| author | varchar(1024) | NO | MUL | NULL | |
| comments | varchar(1024) | NO | NULL | ||
| is_dir | smallint(6) | NO | NULL | ||
| branch | varchar(1024) | YES | MUL | NULL | |
| revision | varchar(256) | YES | MUL | NULL | |
| revlink | varchar(256) | YES | NULL | ||
| when_timestamp | int(11) | NO | MUL | NULL | |
| category | varchar(256) | YES | MUL | NULL | |
| repository | text | NO | NULL | ||
| project | text | NO | NULL | ||
| id | int(11) | NO | PRI | NULL | auto_increment |
| patchlevel | int(11) | NO | NULL | ||
| patch_base64 | text | NO | NULL | ||
| subdir | text | YES | NULL | ||
| schedulerid | int(11) | YES | MUL | NULL | |
| changeid | int(11) | YES | MUL | NULL | |
| important | smallint(6) | YES | NULL | ||
| buildsetid | int(11) | YES | MUL | NULL | |
| schedulerid | int(11) | YES | MUL | NULL | |
| active | smallint(6) | YES | MUL | NULL | |
| schedulerid | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(100) | NO | MUL | NULL | |
| class_name | varchar(100) | NO | NULL | ||
| state | text | YES | NULL | ||
| sourcestampid | int(11) | NO | MUL | NULL | |
| changeid | int(11) | NO | MUL | NULL | |
| id | int(11) | NO | PRI | NULL | auto_increment |
| branch | varchar(256) | YES | MUL | NULL | |
| revision | vrachar(256) | YES | MUL | NULL | |
| patchid | int(11) | YES | NULL | ||
| repository | text | NO | NULL | ||
| project | text | NO | NULL | ||
| version | int(11) | NO | NULL | ||