ReleaseEngineering/Buildbot Database Schemas
Jump to navigation
Jump to search
Statusdb
Overview
Schema of every Table
| 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
Overview
Schema of every Table
| 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 | |