Confirmed users
194
edits
ReleaseEngineering/Buildbot Database Schemas: Difference between revisions
ReleaseEngineering/Buildbot Database Schemas (view source)
Revision as of 01:29, 25 July 2013
, 25 July 2013no edit summary
No edit summary |
|||
| Line 1: | Line 1: | ||
All data featured here is accurate as of Wednesday, July 17th, 2013. | |||
== Statusdb == | == Statusdb == | ||
=== Overview === | === Overview === | ||
Here is a list of all the tables represented in Statusdb. | |||
=== Columns of every Table === | === Columns of every Table === | ||
These are the schemas for each table in Statusdb. | |||
<center><table style="border:1px solid black; border-collapse:collapse; width: 500px;"><tr bgcolor="#4A86E8"><td style="border:1px solid black;"><center><strong>Field</strong></center></td><td style="border:1px solid black;"><center><strong>Type</strong></center></td><td style="border:1px solid black;"><center><strong>Null</strong></center></td><td style="border:1px solid black;"><center><strong>Key</strong></center></td><td style="border:1px solid black;"><center><strong>Default</strong></center></td><td style="border:1px solid black;"><center><strong>Extra</strong></center></td></tr> | <center><table style="border:1px solid black; border-collapse:collapse; width: 500px;"><tr bgcolor="#4A86E8"><td style="border:1px solid black;"><center><strong>Field</strong></center></td><td style="border:1px solid black;"><center><strong>Type</strong></center></td><td style="border:1px solid black;"><center><strong>Null</strong></center></td><td style="border:1px solid black;"><center><strong>Key</strong></center></td><td style="border:1px solid black;"><center><strong>Default</strong></center></td><td style="border:1px solid black;"><center><strong>Extra</strong></center></td></tr> | ||
<tr bgcolor="#C9DAF8"><td style="border:1px solid black;" colspan="6"><center><strong>BUILD_PROPERTIES</strong></center></td></tr> | <tr bgcolor="#C9DAF8"><td style="border:1px solid black;" colspan="6"><center><strong>BUILD_PROPERTIES</strong></center></td></tr> | ||
| Line 105: | Line 109: | ||
== Schedulerdb == | == Schedulerdb == | ||
=== Overview === | === Overview === | ||
Here is a list of all the tables represented in Schedulerdb. | |||
<table><tr><td><center>buildrequests</center></td></tr> | |||
<tr><td><center>builds</center></td></tr> | |||
<tr><td><center>buildset_properties</center></td></tr> | |||
<tr><td><center>buildsets</center></td></tr> | |||
<tr><td><center>change_files</center></td></tr> | |||
<tr><td><center>change_links</center></td></tr> | |||
<tr><td><center>change_properties</center></td></tr> | |||
<tr><td><center>changes</center></td></tr> | |||
<tr><td><center>patches</center></td></tr> | |||
<tr><td><center>scheduler_changes</center></td></tr> | |||
<tr><td><center>scheduler_upstream_buildsets</center></td></tr> | |||
<tr><td><center>schedulers</center></td></tr> | |||
<tr><td><center>sourcestamp_changes</center></td></tr> | |||
<tr><td><center>sourcestamps</center></td></tr> | |||
<tr><td><center>version<center></td></tr></table> | |||
=== Columns of every Table === | === Columns of every Table === | ||
These are the schemas for each table in Schedulerdb. | |||
<center><table style="border:1px solid black; border-collapse:collapse; width: 500px;"><tr bgcolor="#4A86E8"><td style="border:1px solid black;"><center><strong>Field</strong></center></td><td style="border:1px solid black;"><center><strong>Type</strong></center></td><td style="border:1px solid black;"><center><strong>Null</strong></center></td><td style="border:1px solid black;"><center><strong>Key</strong></center></td><td style="border:1px solid black;"><center><strong>Default</strong></center></td><td style="border:1px solid black;"><center><strong>Extra</strong></center></td></tr> | <center><table style="border:1px solid black; border-collapse:collapse; width: 500px;"><tr bgcolor="#4A86E8"><td style="border:1px solid black;"><center><strong>Field</strong></center></td><td style="border:1px solid black;"><center><strong>Type</strong></center></td><td style="border:1px solid black;"><center><strong>Null</strong></center></td><td style="border:1px solid black;"><center><strong>Key</strong></center></td><td style="border:1px solid black;"><center><strong>Default</strong></center></td><td style="border:1px solid black;"><center><strong>Extra</strong></center></td></tr> | ||
<tr bgcolor="#C9DAF8"><td style="border:1px solid black;" colspan="6"><center><strong>BUILDREQUESTS</strong></center></td></tr> | <tr bgcolor="#C9DAF8"><td style="border:1px solid black;" colspan="6"><center><strong>BUILDREQUESTS</strong></center></td></tr> | ||