ReleaseEngineering/Buildbot Database Schemas

All data featured here is accurate as of Wednesday, July 17th, 2013.

Statusdb

Overview

Here is a list of all the tables represented in Statusdb.

build_properties

build_requests

builder_slaves

builders

builds

changes

file_changes

files

master_slaves

masters

patches

properties

request_properties

requests

schedulerdb_requests

slaves

source_changes

sourcestamps

steps

Schemas for each Table

These are the schemas for each table in Statusdb.

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

Schedulerdb

Overview

Here is a list of all the tables represented in Schedulerdb.

buildrequests

builds

buildset_properties

buildsets

change_files

change_links

change_properties

changes

patches

scheduler_changes

scheduler_upstream_buildsets

schedulers

sourcestamp_changes

sourcestamps

version

Schemas for each Table

These are the schemas for each table in Schedulerdb.

Field	Type	Null	Key	Default	Extra
BUILDREQUESTS
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
BUILDS
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
BUILDSET_PROPERTIES
buildsetid	int(11)	NO	MUL	NULL
property_name	varchar(256)	NO		NULL
property_value	varchar(1024)	NO		NULL
BUILDSETS
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
CHANGE_FILES
changeid	int(11)	NO	MUL	NULL
filename	varchar(1024)	NO		NULL
CHANGE_LINKS
changeid	int(11)	NO	MUL	NULL
link	varchar(1024)	NO		NULL
CHANGE_PROPERTIES
changeid	int(11)	NO	MUL	NULL
property_name	varchar(256)	NO		NULL
property_value	varchar(1024)	NO		NULL
CHANGES
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
PATCHES
id	int(11)	NO	PRI	NULL	auto_increment
patchlevel	int(11)	NO		NULL
patch_base64	text	NO		NULL
subdir	text	YES		NULL
SCHEDULER_CHANGES
schedulerid	int(11)	YES	MUL	NULL
changeid	int(11)	YES	MUL	NULL
important	smallint(6)	YES		NULL
SCHEDULER_UPSTREAM_BUILDSETS
buildsetid	int(11)	YES	MUL	NULL
schedulerid	int(11)	YES	MUL	NULL
active	smallint(6)	YES	MUL	NULL
SCHEDULERS
schedulerid	int(11)	NO	PRI	NULL	auto_increment
name	varchar(100)	NO	MUL	NULL
class_name	varchar(100)	NO		NULL
state	text	YES		NULL
SOURCESTAMP_CHANGES
sourcestampid	int(11)	NO	MUL	NULL
changeid	int(11)	NO	MUL	NULL
SOURCESTAMPS
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
version	int(11)	NO		NULL