ReleaseEngineering/Buildbot Database Schemas: Difference between revisions

From MozillaWiki
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