ReleaseEngineering/Buildbot Database Schemas: Difference between revisions

no 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>
Confirmed users
194

edits