ReleaseEngineering/Buildbot Database Schemas: Difference between revisions
Jump to navigation
Jump to search
| Line 128: | Line 128: | ||
== Schedulerdb == | == Schedulerdb == | ||
Schedulerdb is where buildbot stores all of the scheduling information for jobs. | Schedulerdb is where buildbot stores all of the scheduling information for jobs. Schedulerdb is defined [http://hg.mozilla.org/build/buildbot/file/08be6859cc34/master/buildbot/db/schema/tables.sql here]. | ||
=== Overview === | === Overview === | ||
Here is a list of all the tables represented in Schedulerdb. | Here is a list of all the tables represented in Schedulerdb. | ||
Revision as of 01:48, 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 here.
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. Schedulerdb is defined here.
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 | ||