ReleaseEngineering/Buildbot Database Schemas: Difference between revisions

Line 128: Line 128:
=== Columns of every Table ===
=== Columns of every Table ===
These are the schemas for each table in Schedulerdb.
These are the schemas for each table in Schedulerdb.
<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>
<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 bgcolor="#C9DAF8"><td style="border:1px solid black;" colspan="6"><center><strong>BUILDREQUESTS</strong></center></td></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>
Line 211: Line 211:
<tr><td style="border:1px solid black;">project</td><td style="border:1px solid black;">text</td><td style="border:1px solid black;">NO</td><td style="border:1px solid black;"></td><td style="border:1px solid black;">NULL</td><td style="border:1px solid black;"></td></tr>
<tr><td style="border:1px solid black;">project</td><td style="border:1px solid black;">text</td><td style="border:1px solid black;">NO</td><td style="border:1px solid black;"></td><td style="border:1px solid black;">NULL</td><td style="border:1px solid black;"></td></tr>
<tr bgcolor="#C9DAF8"><td style="border:1px solid black;" colspan="6"><center><strong>VERSION</strong></center></td></tr>
<tr bgcolor="#C9DAF8"><td style="border:1px solid black;" colspan="6"><center><strong>VERSION</strong></center></td></tr>
<tr><td style="border:1px solid black;">version</td><td style="border:1px solid black;">int(11)</td><td style="border:1px solid black;">NO</td><td style="border:1px solid black;"></td><td style="border:1px solid black;">NULL</td><td style="border:1px solid black;"></td></tr></table></center>
<tr><td style="border:1px solid black;">version</td><td style="border:1px solid black;">int(11)</td><td style="border:1px solid black;">NO</td><td style="border:1px solid black;"></td><td style="border:1px solid black;">NULL</td><td style="border:1px solid black;"></td></tr></table>
Confirmed users
194

edits