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 === | |||
=== Schema 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> | |||
<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;">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;" colspan="6"><center><strong>BUILD_REQUESTS</strong></center></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;">request_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;" colspan="6"><center><strong>BUILDER_SLAVES</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;">builder_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;">slave_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;">added</td><td style="border:1px solid black;">datetime</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;">removed</td><td style="border:1px solid black;">datetime</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;" colspan="6"><center><strong>BUILDERS</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;">name</td><td style="border:1px solid black;">varchar(200)</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;">master_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;">category</td><td style="border:1px solid black;">varchar(30)</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;" colspan="6"><center><strong>BUILDS</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;">buildnumber</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;">builder_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;">slave_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;">master_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;">starttime</td><td style="border:1px solid black;">datetime</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;">endtime</td><td style="border:1px solid black;">datetime</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;">result</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;">reason</td><td style="border:1px solid black;">varchar(500)</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;">source_id</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;">lost</td><td style="border:1px solid black;">tinyint(1)</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;" colspan="6"><center><strong>CHANGES</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;">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;"></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(50)</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;">revision</td><td style="border:1px solid black;">varchar(50)</td><td style="border:1px solid black;">YES</td><td style="border:1px solid black;"></td><td style="border:1px solid black;">MUL</td><td style="border:1px solid black;"></td></tr> | |||
<tr><td style="border:1px solid black;">who</td><td style="border:1px solid black;">varchar(200)</td><td style="border:1px solid black;">YES</td><td style="border:1px solid black;">MUL</td><td style="border:1px solid black;">MUL</td><td style="border:1px solid black;"></td></tr> | |||
<tr><td style="border:1px solid black;">comments</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;">when</td><td style="border:1px solid black;">datetime</td><td style="border:1px solid black;">YES</td><td style="border:1px solid black;"></td><td style="border:1px solid black;">NULL</td><td style="border:1px solid black;"></td></tr> | |||
<tr><td style="border:1px solid black;" colspan="6"><center><strong>FILE_CHANGES</strong></center></td></tr> | |||
<tr><td style="border:1px solid black;">file_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;">change_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;" colspan="6"><center><strong>FILES</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;">path</td><td style="border:1px solid black;">varchar(400)</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>MASTER_SLAVES</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;">slave_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;">master_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;">connected</td><td style="border:1px solid black;">datetime</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;">disconnected</td><td style="border:1px solid black;">datetime</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;" colspan="6"><center><strong>MASTERS</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;">url</td><td style="border:1px solid black;">varchar(100)</td><td style="border:1px solid black;">YES</td><td style="border:1px solid black;">UNI</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;">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>PATCHES</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;">patch</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;">patchlevel</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;" colspan="6"><center><strong>PROPERTIES</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;">name</td><td style="border:1px solid black;">varchar(40)</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;">source</td><td style="border:1px solid black;">varchar(40)</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;">value</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>REQUEST_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;">request_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;" colspan="6"><center><strong>REQUESTS</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;">submittime</td><td style="border:1px solid black;">datetime</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;">builder_id</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;">startcount</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;">source_id</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;">lost</td><td style="border:1px solid black;">tinyint(1)</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;">cancelled</td><td style="border:1px solid black;">tinyint(1)</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>SCHEDULERDB_REQUESTS</strong></center></td></tr> | |||
<tr><td style="border:1px solid black;">status_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;">scheduler_request_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;">scheduler_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;" colspan="6"><center><strong>SLAVES</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;">name</td><td style="border:1px solid black;">varchar(50)</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>SOURCE_CHANGES</strong></center></td></tr> | |||
<tr><td style="border:1px solid black;">source_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;">change_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;">order</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;">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>SOURCESTAMPS</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;">branch</td><td style="border:1px solid black;">varchar(50)</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;">revision</td><td style="border:1px solid black;">varchar(50)</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;">patch_id</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;" colspan="6"><center><strong>STEPS</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;">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;">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;">description</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;">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;">order</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;">starttime</td><td style="border:1px solid black;">datetime</td><td style="border:1px solid black;">YES</td><td style="border:1px solid black;"></td><td style="border:1px solid black;">NULL</td><td style="border:1px solid black;"></td></tr> | |||
<tr><td style="border:1px solid black;">endtime</td><td style="border:1px solid black;">datetime</td><td style="border:1px solid black;">YES</td><td style="border:1px solid black;"></td><td style="border:1px solid black;">NULL</td><td style="border:1px solid black;"></td></tr> | |||
<tr><td style="border:1px solid black;">status</td><td style="border:1px solid black;">int(11)</td><td style="border:1px solid black;">YES</td><td style="border:1px solid black;">MUL</td><td style="border:1px solid black;">NULL</td><td style="border:1px solid black;"></td></tr></table></center> | |||
== Schedulerdb == | |||
=== Overview === | === Overview === | ||
=== Schema of every Table === | === Schema of every Table === | ||
Revision as of 01:07, 25 July 2013
Statusdb
Overview
Schema 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
Schema 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 | |