Confirmed users
194
edits
ReleaseEngineering/Buildbot Database Schemas: Difference between revisions
Jump to navigation
Jump to search
ReleaseEngineering/Buildbot Database Schemas (view source)
Revision as of 01:34, 25 July 2013
, 25 July 2013→Columns of every Table
| Line 4: | Line 4: | ||
Here is a list of all the tables represented in Statusdb. | Here is a list of all the tables represented in Statusdb. | ||
=== | === Schemas for each Table === | ||
These are the schemas for each table in Statusdb. | These are the schemas for each table in Statusdb. | ||
<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> | ||
<tr><td style="border:1px solid black;">property_id</td><td style="border:1px solid black;">int(11)</td><td style="border:1px solid black;">NO</td><td style="border:1px solid black;">MUL</td><td style="border:1px solid black;">NULL</td><td style="border:1px solid black;"></td></tr> | <tr><td style="border:1px solid black;">property_id</td><td style="border:1px solid black;">int(11)</td><td style="border:1px solid black;">NO</td><td style="border:1px solid black;">MUL</td><td style="border:1px solid black;">NULL</td><td style="border:1px solid black;"></td></tr> | ||
| Line 105: | Line 105: | ||
<tr><td style="border:1px solid black;">starttime</td><td style="border:1px solid black;">datetime</td><td style="border:1px solid black;">YES</td><td style="border:1px solid black;"></td><td style="border:1px solid black;">NULL</td><td style="border:1px solid black;"></td></tr> | <tr><td style="border:1px solid black;">starttime</td><td style="border:1px solid black;">datetime</td><td style="border:1px solid black;">YES</td><td style="border:1px solid black;"></td><td style="border:1px solid black;">NULL</td><td style="border:1px solid black;"></td></tr> | ||
<tr><td style="border:1px solid black;">endtime</td><td style="border:1px solid black;">datetime</td><td style="border:1px solid black;">YES</td><td style="border:1px solid black;"></td><td style="border:1px solid black;">NULL</td><td style="border:1px solid black;"></td></tr> | <tr><td style="border:1px solid black;">endtime</td><td style="border:1px solid black;">datetime</td><td style="border:1px solid black;">YES</td><td style="border:1px solid black;"></td><td style="border:1px solid black;">NULL</td><td style="border:1px solid black;"></td></tr> | ||
<tr><td style="border:1px solid black;">status</td><td style="border:1px solid black;">int(11)</td><td style="border:1px solid black;">YES</td><td style="border:1px solid black;">MUL</td><td style="border:1px solid black;">NULL</td><td style="border:1px solid black;"></td></tr></table | <tr><td style="border:1px solid black;">status</td><td style="border:1px solid black;">int(11)</td><td style="border:1px solid black;">YES</td><td style="border:1px solid black;">MUL</td><td style="border:1px solid black;">NULL</td><td style="border:1px solid black;"></td></tr></table> | ||
== Schedulerdb == | == Schedulerdb == | ||