ReleaseEngineering/Buildbot Database Schemas: Difference between revisions

From MozillaWiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 1: Line 1:
<table><tr><td> Field </td><td> Type </td><td> Null </td><td> Key </td><td> Default </td><td> Extra </td></tr>
<table border="1" width="500"><tr><td><center><strong>Field</strong></center></td><td><center><strong>Type</strong></center></td><td><center><strong>Null</strong></center></td><td><center><strong>Key</strong></center></td><td><center><strong>Default</strong></center></td><td><center><strong>Extra</strong></center></td></tr>
<tr><td> BUILD_PROPERTIES </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td><center><strong>BUILD_PROPERTIES</strong></center></td></tr>
<tr><td> property_id </td><td> int(11) </td><td> NO </td><td> MUL </td><td> NULL </td><td> </td></tr>
<tr><td>property_id</td><td>int(11)</td><td>NO</td><td>MUL</td><td>NULL</td><td></td></tr>
<tr><td> build_id </td><td> int(11) </td><td> NO </td><td> MUL </td><td> NULL </td><td> </td></tr>
<tr><td>build_id</td><td>int(11)</td><td>NO</td><td>MUL</td><td>NULL</td><td></td></tr>
<tr><td> BUILD_REQUESTS </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td><center><strong>BUILD_REQUESTS</strong></center></td></tr>
<tr><td> build_id </td><td> int(11) </td><td> NO </td><td> MUL </td><td> NULL </td><td> </td></tr>
<tr><td>build_id</td><td>int(11)</td><td>NO</td><td>MUL</td><td>NULL</td><td></td></tr>
<tr><td> request_id </td><td> int(11) </td><td> NO </td><td> MUL </td><td> NULL </td><td> </td></tr>
<tr><td>request_id</td><td>int(11)</td><td>NO</td><td>MUL</td><td>NULL</td><td></td></tr>
<tr><td> BUILDER_SLAVES </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td><center><strong>BUILDER_SLAVES</strong></center></td></tr>
<tr><td> id </td><td> int(11) </td><td> NO </td><td> PRI </td><td> NULL </td><td> auto_increment </td></tr>
<tr><td>id</td><td>int(11)</td><td>NO</td><td>PRI</td><td>NULL</td><td>auto_increment</td></tr>
<tr><td> builder_id </td><td> int(11) </td><td> NO </td><td> MUL </td><td> NULL </td><td> </td></tr>
<tr><td>builder_id</td><td>int(11)</td><td>NO</td><td>MUL</td><td>NULL</td><td></td></tr>
<tr><td> slave_id </td><td> int(11) </td><td> NO </td><td> MUL </td><td> NULL </td><td> </td></tr>
<tr><td>slave_id</td><td>int(11)</td><td>NO</td><td>MUL</td><td>NULL</td><td></td></tr>
<tr><td> added </td><td> datetime </td><td> NO </td><td> MUL </td><td> NULL </td><td> </td></tr>
<tr><td>added</td><td>datetime</td><td>NO</td><td>MUL</td><td>NULL</td><td></td></tr>
<tr><td> removed </td><td> datetime </td><td> YES </td><td> MUL </td><td> NULL </td><td> </td></tr>
<tr><td>removed</td><td>datetime</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr>
<tr><td> BUILDERS </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td><center><strong>BUILDERS</strong></center></td></tr>
<tr><td> id </td><td> int(11) </td><td> NO </td><td> PRI </td><td> NULL </td><td> auto_increment </td></tr>
<tr><td>id</td><td>int(11)</td><td>NO</td><td>PRI</td><td>NULL</td><td>auto_increment</td></tr>
<tr><td> name </td><td> varchar(200) </td><td> NO </td><td> MUL </td><td> NULL </td><td> </td></tr>
<tr><td>name</td><td>varchar(200)</td><td>NO</td><td>MUL</td><td>NULL</td><td></td></tr>
<tr><td> master_id </td><td> int(11) </td><td> NO </td><td> MUL </td><td> NULL </td><td> </td></tr>
<tr><td>master_id</td><td>int(11)</td><td>NO</td><td>MUL</td><td>NULL</td><td></td></tr>
<tr><td> category </td><td> varchar(30) </td><td> YES </td><td> MUL </td><td> NULL </td><td> </td></tr>
<tr><td>category</td><td>varchar(30)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr>
<tr><td> BUILDS </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td><center><strong>BUILDS</strong></center></td></tr>
<tr><td> id </td><td> int(11) </td><td> NO </td><td> PRI </td><td> NULL </td><td> auto_increment </td></tr>
<tr><td>id</td><td>int(11)</td><td>NO</td><td>PRI</td><td>NULL</td><td>auto_increment</td></tr>
<tr><td> buildnumber </td><td> int(11) </td><td> NO </td><td> MUL </td><td> NULL </td><td> </td></tr>
<tr><td>buildnumber</td><td>int(11)</td><td>NO</td><td>MUL</td><td>NULL</td><td></td></tr>
<tr><td> builder_id </td><td> int(11) </td><td> NO </td><td> MUL </td><td> NULL </td><td> </td></tr>
<tr><td>builder_id</td><td>int(11)</td><td>NO</td><td>MUL</td><td>NULL</td><td></td></tr>
<tr><td> slave_id </td><td> int(11) </td><td> NO </td><td> MUL </td><td> NULL </td><td> </td></tr>
<tr><td>slave_id</td><td>int(11)</td><td>NO</td><td>MUL</td><td>NULL</td><td></td></tr>
<tr><td> master_id </td><td> int(11) </td><td> NO </td><td> MUL </td><td> NULL </td><td> </td></tr>
<tr><td>master_id</td><td>int(11)</td><td>NO</td><td>MUL</td><td>NULL</td><td></td></tr>
<tr><td> starttime </td><td> datetime </td><td> YES </td><td> MUL </td><td> NULL </td><td> </td></tr>
<tr><td>starttime</td><td>datetime</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr>
<tr><td> endtime </td><td> datetime </td><td> YES </td><td> MUL </td><td> NULL </td><td> </td></tr>
<tr><td>endtime</td><td>datetime</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr>
<tr><td> result </td><td> int(11) </td><td> YES </td><td> MUL </td><td> NULL </td><td> </td></tr>
<tr><td>result</td><td>int(11)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr>
<tr><td> reason </td><td> varchar(500) </td><td> YES </td><td> </td><td> NULL </td><td> </td></tr>
<tr><td>reason</td><td>varchar(500)</td><td>YES</td><td></td><td>NULL</td><td></td></tr>
<tr><td> source_id </td><td> int(11) </td><td> YES </td><td> MUL </td><td> NULL </td><td> </td></tr>
<tr><td>source_id</td><td>int(11)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr>
<tr><td> lost </td><td> tinyint(1) </td><td> NO </td><td> </td><td> NULL </td><td> </td></tr>
<tr><td>lost</td><td>tinyint(1)</td><td>NO</td><td></td><td>NULL</td><td></td></tr>
<tr><td> CHANGES </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td><center><strong>CHANGES</strong></center></td></tr>
<tr><td> id </td><td> int(11) </td><td> NO </td><td> PRI </td><td> NULL </td><td> auto_increment </td></tr>
<tr><td>id</td><td>int(11)</td><td>NO</td><td>PRI</td><td>NULL</td><td>auto_increment</td></tr>
<tr><td> number </td><td> int(11) </td><td> NO </td><td> </td><td> NULL </td><td> </td></tr>
<tr><td>number</td><td>int(11)</td><td>NO</td><td></td><td>NULL</td><td></td></tr>
<tr><td> branch </td><td> varchar(50) </td><td> YES </td><td> </td><td> NULL </td><td> </td></tr>
<tr><td>branch</td><td>varchar(50)</td><td>YES</td><td></td><td>NULL</td><td></td></tr>
<tr><td> revision </td><td> varchar(50) </td><td> YES </td><td> </td><td> MUL </td><td> </td></tr>
<tr><td>revision</td><td>varchar(50)</td><td>YES</td><td></td><td>MUL</td><td></td></tr>
<tr><td> who </td><td> varchar(200) </td><td> YES </td><td> MUL </td><td> MUL </td><td> </td></tr>
<tr><td>who</td><td>varchar(200)</td><td>YES</td><td>MUL</td><td>MUL</td><td></td></tr>
<tr><td> comments </td><td> text </td><td> YES </td><td> </td><td> NULL </td><td> </td></tr>
<tr><td>comments</td><td>text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>
<tr><td> when </td><td> datetime </td><td> YES </td><td> </td><td> NULL </td><td> </td></tr>
<tr><td>when</td><td>datetime</td><td>YES</td><td></td><td>NULL</td><td></td></tr>
<tr><td> FILE_CHANGES </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td><center><strong>FILE_CHANGES</strong></center></td></tr>
<tr><td> file_id </td><td> int(11) </td><td> NO </td><td> MUL </td><td> NULL </td><td> </td></tr>
<tr><td>file_id</td><td>int(11)</td><td>NO</td><td>MUL</td><td>NULL</td><td></td></tr>
<tr><td> change_id </td><td> int(11) </td><td> NO </td><td> MUL </td><td> NULL </td><td> </td></tr>
<tr><td>change_id</td><td>int(11)</td><td>NO</td><td>MUL</td><td>NULL</td><td></td></tr>
<tr><td> FILES </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td><center><strong>FILES</strong></center></td></tr>
<tr><td> id </td><td> int(11) </td><td> NO </td><td> PRI </td><td> NULL </td><td> auto_increment </td></tr>
<tr><td>id</td><td>int(11)</td><td>NO</td><td>PRI</td><td>NULL</td><td>auto_increment</td></tr>
<tr><td> path </td><td> varchar(400) </td><td> NO </td><td> MUL </td><td> NULL </td><td> </td></tr>
<tr><td>path</td><td>varchar(400)</td><td>NO</td><td>MUL</td><td>NULL</td><td></td></tr>
<tr><td> MASTER_SLAVES </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td><center><strong>MASTER_SLAVES</strong></center></td></tr>
<tr><td> id </td><td> int(11) </td><td> NO </td><td> PRI </td><td> NULL </td><td> auto_increment </td></tr>
<tr><td>id</td><td>int(11)</td><td>NO</td><td>PRI</td><td>NULL</td><td>auto_increment</td></tr>
<tr><td> slave_id </td><td> int(11) </td><td> NO </td><td> MUL </td><td> NULL </td><td> </td></tr>
<tr><td>slave_id</td><td>int(11)</td><td>NO</td><td>MUL</td><td>NULL</td><td></td></tr>
<tr><td> master_id </td><td> int(11) </td><td> NO </td><td> MUL </td><td> NULL </td><td> </td></tr>
<tr><td>master_id</td><td>int(11)</td><td>NO</td><td>MUL</td><td>NULL</td><td></td></tr>
<tr><td> connected </td><td> datetime </td><td> NO </td><td> MUL </td><td> NULL </td><td> </td></tr>
<tr><td>connected</td><td>datetime</td><td>NO</td><td>MUL</td><td>NULL</td><td></td></tr>
<tr><td> disconnected </td><td> datetime </td><td> YES </td><td> MUL </td><td> NULL </td><td> </td></tr>
<tr><td>disconnected</td><td>datetime</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr>
<tr><td> MASTERS </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td><center><strong>MASTERS</strong></center></td></tr>
<tr><td> id </td><td> int(11) </td><td> NO </td><td> PRI </td><td> NULL </td><td> auto_increment </td></tr>
<tr><td>id</td><td>int(11)</td><td>NO</td><td>PRI</td><td>NULL</td><td>auto_increment</td></tr>
<tr><td> url </td><td> varchar(100) </td><td> YES </td><td> UNI </td><td> NULL </td><td> </td></tr>
<tr><td>url</td><td>varchar(100)</td><td>YES</td><td>UNI</td><td>NULL</td><td></td></tr>
<tr><td> name </td><td> varchar(100) </td><td> YES </td><td> </td><td> NULL </td><td> </td></tr>
<tr><td>name</td><td>varchar(100)</td><td>YES</td><td></td><td>NULL</td><td></td></tr>
<tr><td> PATCHES </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td><center><strong>PATCHES</strong></center></td></tr>
<tr><td> id </td><td> int(11) </td><td> NO </td><td> PRI </td><td> NULL </td><td> auto_increment </td></tr>
<tr><td>id</td><td>int(11)</td><td>NO</td><td>PRI</td><td>NULL</td><td>auto_increment</td></tr>
<tr><td> patch </td><td> text </td><td> YES </td><td> </td><td> NULL </td><td> </td></tr>
<tr><td>patch</td><td>text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>
<tr><td> patchlevel </td><td> int(11) </td><td> YES </td><td> </td><td> NULL </td><td> </td></tr>
<tr><td>patchlevel</td><td>int(11)</td><td>YES</td><td></td><td>NULL</td><td></td></tr>
<tr><td> PROPERTIES </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td><center><strong>PROPERTIES</strong></center></td></tr>
<tr><td> id </td><td> int(11) </td><td> NO </td><td> PRI </td><td> NULL </td><td> auto_increment </td></tr>
<tr><td>id</td><td>int(11)</td><td>NO</td><td>PRI</td><td>NULL</td><td>auto_increment</td></tr>
<tr><td> name </td><td> varchar(40) </td><td> YES </td><td> MUL </td><td> NULL </td><td> </td></tr>
<tr><td>name</td><td>varchar(40)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr>
<tr><td> source </td><td> varchar(40) </td><td> YES </td><td> MUL </td><td> NULL </td><td> </td></tr>
<tr><td>source</td><td>varchar(40)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr>
<tr><td> value </td><td> text </td><td> YES </td><td> </td><td> NULL </td><td> </td></tr>
<tr><td>value</td><td>text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>
<tr><td> REQUEST_PROPERTIES </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td><center><strong>REQUEST_PROPERTIES</strong></center></td></tr>
<tr><td> property_id </td><td> int(11) </td><td> NO </td><td> MUL </td><td> NULL </td><td> </td></tr>
<tr><td>property_id</td><td>int(11)</td><td>NO</td><td>MUL</td><td>NULL</td><td></td></tr>
<tr><td> request_id </td><td> int(11) </td><td> NO </td><td> MUL </td><td> NULL </td><td> </td></tr>
<tr><td>request_id</td><td>int(11)</td><td>NO</td><td>MUL</td><td>NULL</td><td></td></tr>
<tr><td> REQUESTS </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td><center><strong>REQUESTS</strong></center></td></tr>
<tr><td> id </td><td> int(11) </td><td> NO </td><td> PRI </td><td> NULL </td><td> auto_increment </td></tr>
<tr><td>id</td><td>int(11)</td><td>NO</td><td>PRI</td><td>NULL</td><td>auto_increment</td></tr>
<tr><td> submittime </td><td> datetime </td><td> YES </td><td> MUL </td><td> NULL </td><td> </td></tr>
<tr><td>submittime</td><td>datetime</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr>
<tr><td> builder_id </td><td> int(11) </td><td> YES </td><td> MUL </td><td> NULL </td><td> </td></tr>
<tr><td>builder_id</td><td>int(11)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr>
<tr><td> startcount </td><td> int(11) </td><td> NO </td><td> MUL </td><td> NULL </td><td> </td></tr>
<tr><td>startcount</td><td>int(11)</td><td>NO</td><td>MUL</td><td>NULL</td><td></td></tr>
<tr><td> source_id </td><td> int(11) </td><td> YES </td><td> MUL </td><td> NULL </td><td> </td></tr>
<tr><td>source_id</td><td>int(11)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr>
<tr><td> lost </td><td> tinyint(1) </td><td> NO </td><td> MUL </td><td> NULL </td><td> </td></tr>
<tr><td>lost</td><td>tinyint(1)</td><td>NO</td><td>MUL</td><td>NULL</td><td></td></tr>
<tr><td> cancelled </td><td> tinyint(1) </td><td> NO </td><td> MUL </td><td> NULL </td><td> </td></tr>
<tr><td>cancelled</td><td>tinyint(1)</td><td>NO</td><td>MUL</td><td>NULL</td><td></td></tr>
<tr><td> SCHEDULERDB_REQUESTS </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td><center><strong>SCHEDULERDB_REQUESTS</strong></center></td></tr>
<tr><td> status_build_id </td><td> int(11) </td><td> NO </td><td> MUL </td><td> NULL </td><td> </td></tr>
<tr><td>status_build_id</td><td>int(11)</td><td>NO</td><td>MUL</td><td>NULL</td><td></td></tr>
<tr><td> scheduler_request_id </td><td> int(11) </td><td> NO </td><td> MUL </td><td> NULL </td><td> </td></tr>
<tr><td>scheduler_request_id</td><td>int(11)</td><td>NO</td><td>MUL</td><td>NULL</td><td></td></tr>
<tr><td> scheduler_build_id </td><td> int(11) </td><td> NO </td><td> MUL </td><td> NULL </td><td> </td></tr>
<tr><td>scheduler_build_id</td><td>int(11)</td><td>NO</td><td>MUL</td><td>NULL</td><td></td></tr>
<tr><td> SLAVES </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td><center><strong>SLAVES</strong></center></td></tr>
<tr><td> id </td><td> int(11) </td><td> NO </td><td> PRI </td><td> NULL </td><td> auto_increment </td></tr>
<tr><td>id</td><td>int(11)</td><td>NO</td><td>PRI</td><td>NULL</td><td>auto_increment</td></tr>
<tr><td> name </td><td> varchar(50) </td><td> NO </td><td> MUL </td><td> NULL </td><td> </td></tr>
<tr><td>name</td><td>varchar(50)</td><td>NO</td><td>MUL</td><td>NULL</td><td></td></tr>
<tr><td> SOURCE_CHANGES </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td><center><strong>SOURCE_CHANGES</strong></center></td></tr>
<tr><td> source_id </td><td> int(11) </td><td> NO </td><td> MUL </td><td> NULL </td><td> </td></tr>
<tr><td>source_id</td><td>int(11)</td><td>NO</td><td>MUL</td><td>NULL</td><td></td></tr>
<tr><td> change_id </td><td> int(11) </td><td> NO </td><td> MUL </td><td> NULL </td><td> </td></tr>
<tr><td>change_id</td><td>int(11)</td><td>NO</td><td>MUL</td><td>NULL</td><td></td></tr>
<tr><td> order </td><td> int(11) </td><td> NO </td><td> </td><td> NULL </td><td> </td></tr>
<tr><td>order</td><td>int(11)</td><td>NO</td><td></td><td>NULL</td><td></td></tr>
<tr><td> id </td><td> int(11) </td><td> NO </td><td> PRI </td><td> NULL </td><td> auto_increment </td></tr>
<tr><td>id</td><td>int(11)</td><td>NO</td><td>PRI</td><td>NULL</td><td>auto_increment</td></tr>
<tr><td> SOURCESTAMPS </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td><center><strong>SOURCESTAMPS</strong></center></td></tr>
<tr><td> id </td><td> int(11) </td><td> NO </td><td> PRI </td><td> NULL </td><td> auto_increment </td></tr>
<tr><td>id</td><td>int(11)</td><td>NO</td><td>PRI</td><td>NULL</td><td>auto_increment</td></tr>
<tr><td> branch </td><td> varchar(50) </td><td> YES </td><td> </td><td> NULL </td><td> </td></tr>
<tr><td>branch</td><td>varchar(50)</td><td>YES</td><td></td><td>NULL</td><td></td></tr>
<tr><td> revision </td><td> varchar(50) </td><td> YES </td><td> MUL </td><td> NULL </td><td> </td></tr>
<tr><td>revision</td><td>varchar(50)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr>
<tr><td> patch_id </td><td> int(11) </td><td> YES </td><td> MUL </td><td> NULL </td><td> </td></tr>
<tr><td>patch_id</td><td>int(11)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr>
<tr><td> STEPS </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td><center><strong>STEPS</strong></center></td></tr>
<tr><td> id </td><td> int(11) </td><td> NO </td><td> PRI </td><td> NULL </td><td> auto_increment </td></tr>
<tr><td>id</td><td>int(11)</td><td>NO</td><td>PRI</td><td>NULL</td><td>auto_increment</td></tr>
<tr><td> name </td><td> varchar(256) </td><td> NO </td><td> MUL </td><td> NULL </td><td> </td></tr>
<tr><td>name</td><td>varchar(256)</td><td>NO</td><td>MUL</td><td>NULL</td><td></td></tr>
<tr><td> description </td><td> text </td><td> YES </td><td> </td><td> NULL </td><td> </td></tr>
<tr><td>description</td><td>text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>
<tr><td> build_id </td><td> int(11) </td><td> NO </td><td> MUL </td><td> NULL </td><td> </td></tr>
<tr><td>build_id</td><td>int(11)</td><td>NO</td><td>MUL</td><td>NULL</td><td></td></tr>
<tr><td> order </td><td> int(11) </td><td> NO </td><td> </td><td> NULL </td><td> </td></tr>
<tr><td>order</td><td>int(11)</td><td>NO</td><td></td><td>NULL</td><td></td></tr>
<tr><td> starttime </td><td> datetime </td><td> YES </td><td> </td><td> NULL </td><td> </td></tr>
<tr><td>starttime</td><td>datetime</td><td>YES</td><td></td><td>NULL</td><td></td></tr>
<tr><td> endtime </td><td> datetime </td><td> YES </td><td> </td><td> NULL </td><td> </td></tr>
<tr><td>endtime</td><td>datetime</td><td>YES</td><td></td><td>NULL</td><td></td></tr>
<tr><td> status </td><td> int(11) </td><td> YES </td><td> MUL </td><td> NULL </td><td> </td></tr></table>
<tr><td>status</td><td>int(11)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr></table>

Revision as of 00:46, 25 July 2013

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