ReleaseEngineering/Buildbot Database Schemas: Difference between revisions
Jump to navigation
Jump to search
(Created page with "<table><tr> Field </td><td> Type </td><td> Null </td><td> Key </td><td> Default </td><td> Extra </td></tr> <tr><td> BUILD_PROPERTIES </td><td> </td><td> </td><td> </td><td>...") |
No edit summary |
||
Line 1: | Line 1: | ||
<table><tr> Field </td><td> Type </td><td> Null </td><td> Key </td><td> Default </td><td> Extra </td></tr> | <table><tr><td> Field </td><td> Type </td><td> Null </td><td> Key </td><td> Default </td><td> Extra </td></tr> | ||
<tr><td> BUILD_PROPERTIES </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> | <tr><td> BUILD_PROPERTIES </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> | ||
<tr><td> property_id </td><td> int(11) </td><td> NO </td><td> MUL </td><td> NULL </td><td> </td></tr> | <tr><td> property_id </td><td> int(11) </td><td> NO </td><td> MUL </td><td> NULL </td><td> </td></tr> |
Revision as of 00:36, 25 July 2013
Field | Type | Null | Key | Default | Extra |
BUILD_PROPERTIES | |||||
property_id | int(11) | NO | MUL | NULL | |
build_id | int(11) | NO | MUL | NULL | |
BUILD_REQUESTS | |||||
build_id | int(11) | NO | MUL | NULL | |
request_id | int(11) | NO | MUL | NULL | |
BUILDER_SLAVES | |||||
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 | |
BUILDERS | |||||
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 | |
BUILDS | |||||
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 | ||
CHANGES | |||||
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_CHANGES | |||||
file_id | int(11) | NO | MUL | NULL | |
change_id | int(11) | NO | MUL | NULL | |
FILES | |||||
id | int(11) | NO | PRI | NULL | auto_increment |
path | varchar(400) | NO | MUL | NULL | |
MASTER_SLAVES | |||||
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 | |
MASTERS | |||||
id | int(11) | NO | PRI | NULL | auto_increment |
url | varchar(100) | YES | UNI | NULL | |
name | varchar(100) | YES | NULL | ||
PATCHES | |||||
id | int(11) | NO | PRI | NULL | auto_increment |
patch | text | YES | NULL | ||
patchlevel | int(11) | YES | NULL | ||
PROPERTIES | |||||
id | int(11) | NO | PRI | NULL | auto_increment |
name | varchar(40) | YES | MUL | NULL | |
source | varchar(40) | YES | MUL | NULL | |
value | text | YES | NULL | ||
REQUEST_PROPERTIES | |||||
property_id | int(11) | NO | MUL | NULL | |
request_id | int(11) | NO | MUL | NULL | |
REQUESTS | |||||
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 | |
SCHEDULERDB_REQUESTS | |||||
status_build_id | int(11) | NO | MUL | NULL | |
scheduler_request_id | int(11) | NO | MUL | NULL | |
scheduler_build_id | int(11) | NO | MUL | NULL | |
SLAVES | |||||
id | int(11) | NO | PRI | NULL | auto_increment |
name | varchar(50) | NO | MUL | NULL | |
SOURCE_CHANGES | |||||
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 |
SOURCESTAMPS | |||||
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 | |
STEPS | |||||
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 |