ReleaseEngineering/Buildbot Database Schemas: Difference between revisions

From MozillaWiki
Jump to navigation Jump to search
Line 119: Line 119:
<tr><td style="border:1px solid black;">submitted_at</td><td style="border:1px solid black;">int(11)</td><td style="border:1px solid black;">NO</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;">submitted_at</td><td style="border:1px solid black;">int(11)</td><td style="border:1px solid black;">NO</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;">complete_at</td><td style="border:1px solid black;">int(11)</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;">complete_at</td><td style="border:1px solid black;">int(11)</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 bgcolor="#C9DAF8"><td style="border:1px solid black;" colspan="6"><center><strong>BUILDS</td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></strong></center></td></tr>
<tr bgcolor="#C9DAF8"><td style="border:1px solid black;" colspan="6"><center><strong>BUILDS</td><td style="border:1px solid black;"></strong></center></td></tr>
<tr><td style="border:1px solid black;">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;">PRI</td><td style="border:1px solid black;">NULL</td><td style="border:1px solid black;">auto_increment</td></tr>
<tr><td style="border:1px solid black;">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;">PRI</td><td style="border:1px solid black;">NULL</td><td style="border:1px solid black;">auto_increment</td></tr>
<tr><td style="border:1px solid black;">number</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;">number</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 125: Line 125:
<tr><td style="border:1px solid black;">start_time</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;">start_time</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;">finish_time</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>
<tr><td style="border:1px solid black;">finish_time</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>
<tr bgcolor="#C9DAF8"><td style="border:1px solid black;" colspan="6"><center><strong>BUILDSET_PROPERTIES</td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></strong></center></td></tr>
<tr bgcolor="#C9DAF8"><td style="border:1px solid black;" colspan="6"><center><strong>BUILDSET_PROPERTIES</td><td style="border:1px solid black;"></strong></center></td></tr>
<tr><td style="border:1px solid black;">buildsetid</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;">buildsetid</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_name</td><td style="border:1px solid black;">varchar(256)</td><td style="border:1px solid black;">NO</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;">property_name</td><td style="border:1px solid black;">varchar(256)</td><td style="border:1px solid black;">NO</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;">property_value</td><td style="border:1px solid black;">varchar(1024)</td><td style="border:1px solid black;">NO</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;">property_value</td><td style="border:1px solid black;">varchar(1024)</td><td style="border:1px solid black;">NO</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 bgcolor="#C9DAF8"><td style="border:1px solid black;" colspan="6"><center><strong>BUILDSETS</td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></strong></center></td></tr>
<tr bgcolor="#C9DAF8"><td style="border:1px solid black;" colspan="6"><center><strong>BUILDSETS</td><td style="border:1px solid black;"></strong></center></td></tr>
<tr><td style="border:1px solid black;">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;">PRI</td><td style="border:1px solid black;">NULL</td><td style="border:1px solid black;">auto_increment</td></tr>
<tr><td style="border:1px solid black;">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;">PRI</td><td style="border:1px solid black;">NULL</td><td style="border:1px solid black;">auto_increment</td></tr>
<tr><td style="border:1px solid black;">external_idstring</td><td style="border:1px solid black;">varchar(256)</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;">external_idstring</td><td style="border:1px solid black;">varchar(256)</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>
Line 138: Line 138:
<tr><td style="border:1px solid black;">complete_at</td><td style="border:1px solid black;">int(11)</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;">complete_at</td><td style="border:1px solid black;">int(11)</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;">results</td><td style="border:1px solid black;">smallint(6)</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;">results</td><td style="border:1px solid black;">smallint(6)</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 bgcolor="#C9DAF8"><td style="border:1px solid black;" colspan="6"><center><strong>CHANGE_FILES</td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></strong></center></td></tr>
<tr bgcolor="#C9DAF8"><td style="border:1px solid black;" colspan="6"><center><strong>CHANGE_FILES</td><td style="border:1px solid black;"></strong></center></td></tr>
<tr><td style="border:1px solid black;">changeid</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;">changeid</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;">filename</td><td style="border:1px solid black;">varchar(1024)</td><td style="border:1px solid black;">NO</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;">filename</td><td style="border:1px solid black;">varchar(1024)</td><td style="border:1px solid black;">NO</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 bgcolor="#C9DAF8"><td style="border:1px solid black;" colspan="6"><center><strong>CHANGE_LINKS</td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></strong></center></td></tr>
<tr bgcolor="#C9DAF8"><td style="border:1px solid black;" colspan="6"><center><strong>CHANGE_LINKS</td><td style="border:1px solid black;"></strong></center></td></tr>
<tr><td style="border:1px solid black;">changeid</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;">changeid</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;">link</td><td style="border:1px solid black;">varchar(1024)</td><td style="border:1px solid black;">NO</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;">link</td><td style="border:1px solid black;">varchar(1024)</td><td style="border:1px solid black;">NO</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 bgcolor="#C9DAF8"><td style="border:1px solid black;" colspan="6"><center><strong>CHANGE_PROPERTIES</td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></strong></center></td></tr>
<tr bgcolor="#C9DAF8"><td style="border:1px solid black;" colspan="6"><center><strong>CHANGE_PROPERTIES</td><td style="border:1px solid black;"></strong></center></td></tr>
<tr><td style="border:1px solid black;">changeid</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;">changeid</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_name</td><td style="border:1px solid black;">varchar(256)</td><td style="border:1px solid black;">NO</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;">property_name</td><td style="border:1px solid black;">varchar(256)</td><td style="border:1px solid black;">NO</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;">property_value</td><td style="border:1px solid black;">varchar(1024)</td><td style="border:1px solid black;">NO</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;">property_value</td><td style="border:1px solid black;">varchar(1024)</td><td style="border:1px solid black;">NO</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 bgcolor="#C9DAF8"><td style="border:1px solid black;" colspan="6"><center><strong>CHANGES</td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></strong></center></td></tr>
<tr bgcolor="#C9DAF8"><td style="border:1px solid black;" colspan="6"><center><strong>CHANGES</td><td style="border:1px solid black;"></strong></center></td></tr>
<tr><td style="border:1px solid black;">changeid</td><td style="border:1px solid black;">int(11)</td><td style="border:1px solid black;">NO</td><td style="border:1px solid black;">PRI</td><td style="border:1px solid black;">NULL</td><td style="border:1px solid black;">auto_increment</td></tr>
<tr><td style="border:1px solid black;">changeid</td><td style="border:1px solid black;">int(11)</td><td style="border:1px solid black;">NO</td><td style="border:1px solid black;">PRI</td><td style="border:1px solid black;">NULL</td><td style="border:1px solid black;">auto_increment</td></tr>
<tr><td style="border:1px solid black;">author</td><td style="border:1px solid black;">varchar(1024)</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;">author</td><td style="border:1px solid black;">varchar(1024)</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 160: Line 160:
<tr><td style="border:1px solid black;">repository</td><td style="border:1px solid black;">text</td><td style="border:1px solid black;">NO</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;">repository</td><td style="border:1px solid black;">text</td><td style="border:1px solid black;">NO</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;">project</td><td style="border:1px solid black;">text</td><td style="border:1px solid black;">NO</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;">project</td><td style="border:1px solid black;">text</td><td style="border:1px solid black;">NO</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 bgcolor="#C9DAF8"><td style="border:1px solid black;" colspan="6"><center><strong>PATCHES</td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></strong></center></td></tr>
<tr bgcolor="#C9DAF8"><td style="border:1px solid black;" colspan="6"><center><strong>PATCHES</td><td style="border:1px solid black;"></strong></center></td></tr>
<tr><td style="border:1px solid black;">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;">PRI</td><td style="border:1px solid black;">NULL</td><td style="border:1px solid black;">auto_increment</td></tr>
<tr><td style="border:1px solid black;">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;">PRI</td><td style="border:1px solid black;">NULL</td><td style="border:1px solid black;">auto_increment</td></tr>
<tr><td style="border:1px solid black;">patchlevel</td><td style="border:1px solid black;">int(11)</td><td style="border:1px solid black;">NO</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;">patchlevel</td><td style="border:1px solid black;">int(11)</td><td style="border:1px solid black;">NO</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;">patch_base64</td><td style="border:1px solid black;">text</td><td style="border:1px solid black;">NO</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;">patch_base64</td><td style="border:1px solid black;">text</td><td style="border:1px solid black;">NO</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;">subdir</td><td style="border:1px solid black;">text</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;">subdir</td><td style="border:1px solid black;">text</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 bgcolor="#C9DAF8"><td style="border:1px solid black;" colspan="6"><center><strong>SCHEDULER_CHANGES</td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></strong></center></td></tr>
<tr bgcolor="#C9DAF8"><td style="border:1px solid black;" colspan="6"><center><strong>SCHEDULER_CHANGES</td><td style="border:1px solid black;"></strong></center></td></tr>
<tr><td style="border:1px solid black;">schedulerid</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>
<tr><td style="border:1px solid black;">schedulerid</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>
<tr><td style="border:1px solid black;">changeid</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>
<tr><td style="border:1px solid black;">changeid</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>
<tr><td style="border:1px solid black;">important</td><td style="border:1px solid black;">smallint(6)</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;">important</td><td style="border:1px solid black;">smallint(6)</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 bgcolor="#C9DAF8"><td style="border:1px solid black;" colspan="6"><center><strong>SCHEDULER_UPSTREAM_BUILDSETS</td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></strong></center></td></tr>
<tr bgcolor="#C9DAF8"><td style="border:1px solid black;" colspan="6"><center><strong>SCHEDULER_UPSTREAM_BUILDSETS</td><td style="border:1px solid black;"></strong></center></td></tr>
<tr><td style="border:1px solid black;">buildsetid</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>
<tr><td style="border:1px solid black;">buildsetid</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>
<tr><td style="border:1px solid black;">schedulerid</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>
<tr><td style="border:1px solid black;">schedulerid</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>
<tr><td style="border:1px solid black;">active</td><td style="border:1px solid black;">smallint(6)</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>
<tr><td style="border:1px solid black;">active</td><td style="border:1px solid black;">smallint(6)</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>
<tr bgcolor="#C9DAF8"><td style="border:1px solid black;" colspan="6"><center><strong>SCHEDULERS</td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></strong></center></td></tr>
<tr bgcolor="#C9DAF8"><td style="border:1px solid black;" colspan="6"><center><strong>SCHEDULERS</td><td style="border:1px solid black;"></strong></center></td></tr>
<tr><td style="border:1px solid black;">schedulerid</td><td style="border:1px solid black;">int(11)</td><td style="border:1px solid black;">NO</td><td style="border:1px solid black;">PRI</td><td style="border:1px solid black;">NULL</td><td style="border:1px solid black;">auto_increment</td></tr>
<tr><td style="border:1px solid black;">schedulerid</td><td style="border:1px solid black;">int(11)</td><td style="border:1px solid black;">NO</td><td style="border:1px solid black;">PRI</td><td style="border:1px solid black;">NULL</td><td style="border:1px solid black;">auto_increment</td></tr>
<tr><td style="border:1px solid black;">name</td><td style="border:1px solid black;">varchar(100)</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;">name</td><td style="border:1px solid black;">varchar(100)</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;">class_name</td><td style="border:1px solid black;">varchar(100)</td><td style="border:1px solid black;">NO</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;">class_name</td><td style="border:1px solid black;">varchar(100)</td><td style="border:1px solid black;">NO</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;">state</td><td style="border:1px solid black;">text</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;">state</td><td style="border:1px solid black;">text</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 bgcolor="#C9DAF8"><td style="border:1px solid black;" colspan="6"><center><strong>SOURCESTAMP_CHANGES</td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></strong></center></td></tr>
<tr bgcolor="#C9DAF8"><td style="border:1px solid black;" colspan="6"><center><strong>SOURCESTAMP_CHANGES</td><td style="border:1px solid black;"></strong></center></td></tr>
<tr><td style="border:1px solid black;">sourcestampid</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;">sourcestampid</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;">changeid</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;">changeid</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 bgcolor="#C9DAF8"><td style="border:1px solid black;" colspan="6"><center><strong>SOURCESTAMPS</td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></strong></center></td></tr>
<tr bgcolor="#C9DAF8"><td style="border:1px solid black;" colspan="6"><center><strong>SOURCESTAMPS</td><td style="border:1px solid black;"></strong></center></td></tr>
<tr><td style="border:1px solid black;">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;">PRI</td><td style="border:1px solid black;">NULL</td><td style="border:1px solid black;">auto_increment</td></tr>
<tr><td style="border:1px solid black;">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;">PRI</td><td style="border:1px solid black;">NULL</td><td style="border:1px solid black;">auto_increment</td></tr>
<tr><td style="border:1px solid black;">branch</td><td style="border:1px solid black;">varchar(256)</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>
<tr><td style="border:1px solid black;">branch</td><td style="border:1px solid black;">varchar(256)</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>
Line 188: Line 188:
<tr><td style="border:1px solid black;">repository</td><td style="border:1px solid black;">text</td><td style="border:1px solid black;">NO</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;">repository</td><td style="border:1px solid black;">text</td><td style="border:1px solid black;">NO</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;">project</td><td style="border:1px solid black;">text</td><td style="border:1px solid black;">NO</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;">project</td><td style="border:1px solid black;">text</td><td style="border:1px solid black;">NO</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 bgcolor="#C9DAF8"><td style="border:1px solid black;" colspan="6"><center><strong>VERSION</td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></td><td style="border:1px solid black;"></strong></center></td></tr>
<tr bgcolor="#C9DAF8"><td style="border:1px solid black;" colspan="6"><center><strong>VERSION</td><td style="border:1px solid black;"></strong></center></td></tr>
<tr><td style="border:1px solid black;">version</td><td style="border:1px solid black;">int(11)</td><td style="border:1px solid black;">NO</td><td style="border:1px solid black;"></td><td style="border:1px solid black;">NULL</td><td style="border:1px solid black;"></td></tr></table></center>
<tr><td style="border:1px solid black;">version</td><td style="border:1px solid black;">int(11)</td><td style="border:1px solid black;">NO</td><td style="border:1px solid black;"></td><td style="border:1px solid black;">NULL</td><td style="border:1px solid black;"></td></tr></table></center>

Revision as of 01:20, 25 July 2013

Statusdb

Overview

Columns of every Table

Field
Type
Null
Key
Default
Extra
BUILD_PROPERTIES
property_idint(11)NOMULNULL
build_idint(11)NOMULNULL
BUILD_REQUESTS
build_idint(11)NOMULNULL
request_idint(11)NOMULNULL
BUILDER_SLAVES
idint(11)NOPRINULLauto_increment
builder_idint(11)NOMULNULL
slave_idint(11)NOMULNULL
addeddatetimeNOMULNULL
removeddatetimeYESMULNULL
BUILDERS
idint(11)NOPRINULLauto_increment
namevarchar(200)NOMULNULL
master_idint(11)NOMULNULL
categoryvarchar(30)YESMULNULL
BUILDS
idint(11)NOPRINULLauto_increment
buildnumberint(11)NOMULNULL
builder_idint(11)NOMULNULL
slave_idint(11)NOMULNULL
master_idint(11)NOMULNULL
starttimedatetimeYESMULNULL
endtimedatetimeYESMULNULL
resultint(11)YESMULNULL
reasonvarchar(500)YESNULL
source_idint(11)YESMULNULL
losttinyint(1)NONULL
CHANGES
idint(11)NOPRINULLauto_increment
numberint(11)NONULL
branchvarchar(50)YESNULL
revisionvarchar(50)YESMUL
whovarchar(200)YESMULMUL
commentstextYESNULL
whendatetimeYESNULL
FILE_CHANGES
file_idint(11)NOMULNULL
change_idint(11)NOMULNULL
FILES
idint(11)NOPRINULLauto_increment
pathvarchar(400)NOMULNULL
MASTER_SLAVES
idint(11)NOPRINULLauto_increment
slave_idint(11)NOMULNULL
master_idint(11)NOMULNULL
connecteddatetimeNOMULNULL
disconnecteddatetimeYESMULNULL
MASTERS
idint(11)NOPRINULLauto_increment
urlvarchar(100)YESUNINULL
namevarchar(100)YESNULL
PATCHES
idint(11)NOPRINULLauto_increment
patchtextYESNULL
patchlevelint(11)YESNULL
PROPERTIES
idint(11)NOPRINULLauto_increment
namevarchar(40)YESMULNULL
sourcevarchar(40)YESMULNULL
valuetextYESNULL
REQUEST_PROPERTIES
property_idint(11)NOMULNULL
request_idint(11)NOMULNULL
REQUESTS
idint(11)NOPRINULLauto_increment
submittimedatetimeYESMULNULL
builder_idint(11)YESMULNULL
startcountint(11)NOMULNULL
source_idint(11)YESMULNULL
losttinyint(1)NOMULNULL
cancelledtinyint(1)NOMULNULL
SCHEDULERDB_REQUESTS
status_build_idint(11)NOMULNULL
scheduler_request_idint(11)NOMULNULL
scheduler_build_idint(11)NOMULNULL
SLAVES
idint(11)NOPRINULLauto_increment
namevarchar(50)NOMULNULL
SOURCE_CHANGES
source_idint(11)NOMULNULL
change_idint(11)NOMULNULL
orderint(11)NONULL
idint(11)NOPRINULLauto_increment
SOURCESTAMPS
idint(11)NOPRINULLauto_increment
branchvarchar(50)YESNULL
revisionvarchar(50)YESMULNULL
patch_idint(11)YESMULNULL
STEPS
idint(11)NOPRINULLauto_increment
namevarchar(256)NOMULNULL
descriptiontextYESNULL
build_idint(11)NOMULNULL
orderint(11)NONULL
starttimedatetimeYESNULL
endtimedatetimeYESNULL
statusint(11)YESMULNULL

Schedulerdb

Overview

Columns of every Table

Field
Type
Null
Key
Default
Extra
BUILDREQUESTS
idint(11)NOPRINULLauto_increment
buildsetidint(11)NOMULNULL
buildernamevarchar(256)NOMULNULL
priorityint(11)NO0
claimed_atint(11)YESMUL0
claimed_by_namevarchar(256)YESMULNULL
claimed_by_incarnationvarchar(256)YESNULL
completeint(11)YESMUL0
resultssmallint(6)YESNULL
submitted_atint(11)NONULL
complete_atint(11)YESNULL
BUILDS
idint(11)NOPRINULLauto_increment
numberint(11)NOMULNULL
bridint(11)NOMULNULL
start_timeint(11)NOMULNULL
finish_timeint(11)YESMULNULL
BUILDSET_PROPERTIES
buildsetidint(11)NOMULNULL
property_namevarchar(256)NONULL
property_valuevarchar(1024)NONULL
BUILDSETS
idint(11)NOPRINULLauto_increment
external_idstringvarchar(256)YESNULL
reasonvarchar(256)YESNULL
sourcestampidint(11)NOMULNULL
submitted_atint(11)NOMULNULL
completesmallint(6)NOMUL0
complete_atint(11)YESNULL
resultssmallint(6)YESNULL
CHANGE_FILES
changeidint(11)NOMULNULL
filenamevarchar(1024)NONULL
CHANGE_LINKS
changeidint(11)NOMULNULL
linkvarchar(1024)NONULL
CHANGE_PROPERTIES
changeidint(11)NOMULNULL
property_namevarchar(256)NONULL
property_valuevarchar(1024)NONULL
CHANGES
changeidint(11)NOPRINULLauto_increment
authorvarchar(1024)NOMULNULL
commentsvarchar(1024)NONULL
is_dirsmallint(6)NONULL
branchvarchar(1024)YESMULNULL
revisionvarchar(256)YESMULNULL
revlinkvarchar(256)YESNULL
when_timestampint(11)NOMULNULL
categoryvarchar(256)YESMULNULL
repositorytextNONULL
projecttextNONULL
PATCHES
idint(11)NOPRINULLauto_increment
patchlevelint(11)NONULL
patch_base64textNONULL
subdirtextYESNULL
SCHEDULER_CHANGES
scheduleridint(11)YESMULNULL
changeidint(11)YESMULNULL
importantsmallint(6)YESNULL
SCHEDULER_UPSTREAM_BUILDSETS
buildsetidint(11)YESMULNULL
scheduleridint(11)YESMULNULL
activesmallint(6)YESMULNULL
SCHEDULERS
scheduleridint(11)NOPRINULLauto_increment
namevarchar(100)NOMULNULL
class_namevarchar(100)NONULL
statetextYESNULL
SOURCESTAMP_CHANGES
sourcestampidint(11)NOMULNULL
changeidint(11)NOMULNULL
SOURCESTAMPS
idint(11)NOPRINULLauto_increment
branchvarchar(256)YESMULNULL
revisionvrachar(256)YESMULNULL
patchidint(11)YESNULL
repositorytextNONULL
projecttextNONULL
VERSION
versionint(11)NONULL