ReleaseEngineering/Buildbot Database Schemas: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
Line 1: | Line 1: | ||
== Statusdb == | == Statusdb == | ||
=== Overview === | === Overview === | ||
=== | === Columns of every Table === | ||
<center><table style="border:1px solid black; border-collapse:collapse; width: 500px;"><tr><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><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><td style="border:1px solid black;" colspan="6"><center><strong> | <tr><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> | ||
<tr><td style="border:1px solid black;">build_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;">build_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: | ||
== Schedulerdb == | == Schedulerdb == | ||
=== Overview === | === Overview === | ||
=== | === Columns of every Table === | ||
<table style="border:1px solid black; border-collapse:collapse; width: 500px;"><tr><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 | <tr bgcolor="#C9DAF8"><td style="border:1px solid black;" colspan="6"><center><strong>BUILDREQUESTS</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;"> | <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;"> | <tr><td style="border:1px solid black;">buildername</td><td style="border:1px solid black;">varchar(256)</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;"> | <tr><td style="border:1px solid black;">priority</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;">0</td><td style="border:1px solid black;"></td></tr> | ||
<tr><td style="border:1px solid black; | <tr><td style="border:1px solid black;">claimed_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;">MUL</td><td style="border:1px solid black;">0</td><td style="border:1px solid black;"></td></tr> | ||
<tr><td style="border:1px solid black;">claimed_by_name</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;"> | <tr><td style="border:1px solid black;">claimed_by_incarnation</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;" | <tr><td style="border:1px solid black;">complete</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;">0</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;">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 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><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;"> | <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;" colspan="6"><center><strong> | <tr><td style="border:1px solid black;">brid</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;"> | <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;"> | <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;"> | <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><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_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><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;" colspan="6"><center><strong> | <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;">reason</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;">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;">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;">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;">complete</td><td style="border:1px solid black;">smallint(6)</td><td style="border:1px solid black;">NO</td><td style="border:1px solid black;">MUL</td><td style="border:1px solid black;">0</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 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><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 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><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 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><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_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><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;">comments</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;">is_dir</td><td style="border:1px solid black;">smallint(6)</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;">branch</td><td style="border:1px solid black;">varchar(1024)</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;">revision</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;">revlink</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;">when_timestamp</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;">category</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;">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 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><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;"> | <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;"> | <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;"> | <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;" colspan="6"><center><strong> | <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><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;">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><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;">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><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;">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 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><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 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><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;"> | <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;"> | <tr><td style="border:1px solid black;">revision</td><td style="border:1px solid black;">vrachar(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;"> | <tr><td style="border:1px solid black;">patchid</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;"> | <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;"> | <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;"> | <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><td style="border:1px solid black;"> | <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:16, 25 July 2013
Statusdb
Overview
Columns of every Table
property_id | int(11) | NO | MUL | NULL | |
build_id | int(11) | NO | MUL | NULL | |
build_id | int(11) | NO | MUL | NULL | |
request_id | int(11) | NO | MUL | NULL | |
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 | |
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 | |
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 | ||
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_id | int(11) | NO | MUL | NULL | |
change_id | int(11) | NO | MUL | NULL | |
id | int(11) | NO | PRI | NULL | auto_increment |
path | varchar(400) | NO | MUL | NULL | |
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 | |
id | int(11) | NO | PRI | NULL | auto_increment |
url | varchar(100) | YES | UNI | NULL | |
name | varchar(100) | YES | NULL | ||
id | int(11) | NO | PRI | NULL | auto_increment |
patch | text | YES | NULL | ||
patchlevel | int(11) | YES | NULL | ||
id | int(11) | NO | PRI | NULL | auto_increment |
name | varchar(40) | YES | MUL | NULL | |
source | varchar(40) | YES | MUL | NULL | |
value | text | YES | NULL | ||
property_id | int(11) | NO | MUL | NULL | |
request_id | int(11) | NO | MUL | NULL | |
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 | |
status_build_id | int(11) | NO | MUL | NULL | |
scheduler_request_id | int(11) | NO | MUL | NULL | |
scheduler_build_id | int(11) | NO | MUL | NULL | |
id | int(11) | NO | PRI | NULL | auto_increment |
name | varchar(50) | NO | MUL | NULL | |
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 |
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 | |
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
Columns of every Table
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 | |||||||
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 | ||||||
buildsetid | int(11) | NO | MUL | NULL | ||||||
property_name | varchar(256) | NO | NULL | |||||||
property_value | varchar(1024) | NO | NULL | |||||||
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 | |||||||
changeid | int(11) | NO | MUL | NULL | ||||||
filename | varchar(1024) | NO | NULL | |||||||
changeid | int(11) | NO | MUL | NULL | ||||||
link | varchar(1024) | NO | NULL | |||||||
changeid | int(11) | NO | MUL | NULL | ||||||
property_name | varchar(256) | NO | NULL | |||||||
property_value | varchar(1024) | NO | NULL | |||||||
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 | |||||||
id | int(11) | NO | PRI | NULL | auto_increment | |||||
patchlevel | int(11) | NO | NULL | |||||||
patch_base64 | text | NO | NULL | |||||||
subdir | text | YES | NULL | |||||||
schedulerid | int(11) | YES | MUL | NULL | ||||||
changeid | int(11) | YES | MUL | NULL | ||||||
important | smallint(6) | YES | NULL | |||||||
buildsetid | int(11) | YES | MUL | NULL | ||||||
schedulerid | int(11) | YES | MUL | NULL | ||||||
active | smallint(6) | YES | MUL | NULL | ||||||
schedulerid | int(11) | NO | PRI | NULL | auto_increment | |||||
name | varchar(100) | NO | MUL | NULL | ||||||
class_name | varchar(100) | NO | NULL | |||||||
state | text | YES | NULL | |||||||
sourcestampid | int(11) | NO | MUL | NULL | ||||||
changeid | int(11) | NO | MUL | NULL | ||||||
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 | int(11) | NO | NULL |