ReleaseEngineering/Buildbot Database Schemas: Difference between revisions

From MozillaWiki
Jump to navigation Jump to search
No edit summary
(deleting obsolete page)
 
(27 intermediate revisions by 2 users not shown)
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>
 
<tr><td> BUILD_PROPERTIES </td><td> </td><td> </td><td> </td><td> </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_REQUESTS </td><td> </td><td> </td><td> </td><td> </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> BUILDER_SLAVES </td><td> </td><td> </td><td> </td><td> </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> 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> 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> BUILDERS </td><td> </td><td> </td><td> </td><td> </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> 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> 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> 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> 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> 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> 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> 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> 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> 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> 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> 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> 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> 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> FILES </td><td> </td><td> </td><td> </td><td> </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> 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> 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> 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> 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> 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> 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> 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> 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> 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> 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> REQUEST_PROPERTIES </td><td> </td><td> </td><td> </td><td> </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> REQUESTS </td><td> </td><td> </td><td> </td><td> </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> 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> 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> 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> SCHEDULERDB_REQUESTS </td><td> </td><td> </td><td> </td><td> </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_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> 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> SOURCE_CHANGES </td><td> </td><td> </td><td> </td><td> </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> 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> SOURCESTAMPS </td><td> </td><td> </td><td> </td><td> </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> 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> 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> 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> 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> 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> 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>

Latest revision as of 21:42, 19 November 2018