diff options
| -rwxr-xr-x | bin/reproducible_build.sh | 6 | ||||
| -rw-r--r-- | reproducible_schema.svg | 2 |
2 files changed, 4 insertions, 4 deletions
diff --git a/bin/reproducible_build.sh b/bin/reproducible_build.sh index b99c7ec6..5a1df62f 100755 --- a/bin/reproducible_build.sh +++ b/bin/reproducible_build.sh @@ -92,7 +92,7 @@ call_debbindiff() { echo "${SRCPACKAGE} built successfully and reproducibly." | tee -a ${RBUILDLOG} calculate_build_duration sqlite3 -init $INIT ${PACKAGES_DB} "REPLACE INTO results (package_id, version, status, build_date, build_duration) VALUES ('${SRCPKGID}', '${VERSION}', 'reproducible', '$DATE', '$DURATION')" - sqlite3 -init $INIT ${PACKAGES_DB} "INSERT INTO stats_builds (name, version, suite, architecture, status, build_date, build_duration) VALUES ('${SRCPACKAGE}', '${VERSION}', '${SUITE}', '${ARCH}', 'reproducible', '${DATE}', '${DURATION}')" + sqlite3 -init $INIT ${PACKAGES_DB} "INSERT INTO stats_build (name, version, suite, architecture, status, build_date, build_duration) VALUES ('${SRCPACKAGE}', '${VERSION}', '${SUITE}', '${ARCH}', 'reproducible', '${DATE}', '${DURATION}')" update_db_and_html else echo | tee -a ${RBUILDLOG} @@ -117,7 +117,7 @@ call_debbindiff() { fi calculate_build_duration sqlite3 -init $INIT ${PACKAGES_DB} "REPLACE INTO results (package_id, version, status, build_date, build_duration) VALUES ('${SRCPKGID}', '${VERSION}', 'unreproducible', '$DATE', '$DURATION')" - sqlite3 -init $INIT ${PACKAGES_DB} "INSERT INTO stats_builds (name, version, suite, architecture, status, build_date, build_duration) VALUES ('${SRCPACKAGE}', '${VERSION}', '${SUITE}', '${ARCH}', 'unreproducible', '${DATE}', '${DURATION}')" + sqlite3 -init $INIT ${PACKAGES_DB} "INSERT INTO stats_build (name, version, suite, architecture, status, build_date, build_duration) VALUES ('${SRCPACKAGE}', '${VERSION}', '${SUITE}', '${ARCH}', 'unreproducible', '${DATE}', '${DURATION}')" update_db_and_html fi } @@ -266,7 +266,7 @@ else echo "${SRCPACKAGE} failed to build from source." calculate_build_duration sqlite3 -init $INIT ${PACKAGES_DB} "REPLACE INTO results (package_id, version, status, build_date, build_duration) VALUES ('${SRCPKGID}', '${VERSION}', 'FTBFS', '$DATE', '$DURATION')" - sqlite3 -init $INIT ${PACKAGES_DB} "INSERT INTO stats_builds (name, version, suite, architecture, status, build_date, build_duration) VALUES ('${SRCPACKAGE}', '${VERSION}', '${SUITE}', '${ARCH}', 'FTBFS', '${DATE}', '${DURATION}')" + sqlite3 -init $INIT ${PACKAGES_DB} "INSERT INTO stats_build (name, version, suite, architecture, status, build_date, build_duration) VALUES ('${SRCPACKAGE}', '${VERSION}', '${SUITE}', '${ARCH}', 'FTBFS', '${DATE}', '${DURATION}')" update_db_and_html fi fi diff --git a/reproducible_schema.svg b/reproducible_schema.svg index c4b1a75b..2d115c0e 100644 --- a/reproducible_schema.svg +++ b/reproducible_schema.svg @@ -1 +1 @@ -<svg xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" width="1148px" height="779px" version="1.1"><defs/><g transform="translate(0.5,0.5)"><path d="M 296 555 L 296 537.4 Q 296 523 281.6 523 L 40.4 523 Q 26 523 26 537.4 L 26 555 Z" fill="#008cff" stroke="#000000" stroke-width="2" stroke-miterlimit="10" pointer-events="none"/><path d="M 26 555 L 26 728.6 Q 26 743 40.4 743 L 281.6 743 Q 296 743 296 728.6 L 296 555" fill="none" stroke="#000000" stroke-width="2" stroke-miterlimit="10" pointer-events="none"/><g transform="translate(136,531)"><switch><foreignObject pointer-events="all" width="49" height="23" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility"><div xmlns="http://www.w3.org/1999/xhtml" style="display: inline-block; font-size: 17px; font-family: Helvetica; color: rgb(255, 255, 255); line-height: 1.26; vertical-align: top; white-space: nowrap; text-align: center;"><div xmlns="http://www.w3.org/1999/xhtml" style="display:inline-block;text-align:inherit;text-decoration:inherit;">results</div></div></foreignObject><text x="25" y="20" fill="#FFFFFF" text-anchor="middle" font-size="17px" font-family="Helvetica">[Not supported by viewer]</text></switch></g><rect x="26" y="555" width="270" height="188" fill="none" stroke="none" pointer-events="none"/><g transform="translate(32,562)"><switch><foreignObject pointer-events="all" width="266" height="183" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility"><div xmlns="http://www.w3.org/1999/xhtml" style="display: inline-block; font-size: 17px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.26; vertical-align: top; width: 266px; white-space: normal;"><div xmlns="http://www.w3.org/1999/xhtml" style="display:inline-block;text-align:inherit;text-decoration:inherit;"><ul style="line-height: 21.4200000762939px"><li><b>id </b>(int, PK)</li><li><b>package_id</b> (int, not null, FK)</li><li><b>version </b>(text, not null)</li><li><b>status </b>(text)</li><li><b>build_date</b> (text)</li><li><b>build_duration </b>(text)</li><li><font color="#006600"><b>unique (package, version)</b></font></li></ul></div></div></foreignObject><text x="133" y="100" fill="#000000" text-anchor="middle" font-size="17px" font-family="Helvetica">[Not supported by viewer]</text></switch></g><path d="M 636 302 L 636 284.4 Q 636 270 621.6 270 L 420.4 270 Q 406 270 406 284.4 L 406 302 Z" fill="#008cff" stroke="#000000" stroke-width="2" stroke-miterlimit="10" pointer-events="none"/><path d="M 406 302 L 406 465.6 Q 406 480 420.4 480 L 621.6 480 Q 636 480 636 465.6 L 636 302" fill="none" stroke="#000000" stroke-width="2" stroke-miterlimit="10" pointer-events="none"/><g transform="translate(491,278)"><switch><foreignObject pointer-events="all" width="60" height="23" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility"><div xmlns="http://www.w3.org/1999/xhtml" style="display: inline-block; font-size: 17px; font-family: Helvetica; color: rgb(255, 255, 255); line-height: 1.26; vertical-align: top; white-space: nowrap; text-align: center;"><div xmlns="http://www.w3.org/1999/xhtml" style="display:inline-block;text-align:inherit;text-decoration:inherit;">sources</div></div></foreignObject><text x="30" y="20" fill="#FFFFFF" text-anchor="middle" font-size="17px" font-family="Helvetica">[Not supported by viewer]</text></switch></g><rect x="406" y="302" width="230" height="178" fill="none" stroke="none" pointer-events="none"/><g transform="translate(412,309)"><switch><foreignObject pointer-events="all" width="226" height="183" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility"><div xmlns="http://www.w3.org/1999/xhtml" style="display: inline-block; font-size: 17px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.26; vertical-align: top; width: 224px; white-space: normal;"><div xmlns="http://www.w3.org/1999/xhtml" style="display:inline-block;text-align:inherit;text-decoration:inherit;"><ul style="line-height: 21.4200000762939px"><li><span style="background-color: rgb(242 , 0 , 69)"><b>id </b>(int, PK)</span></li><li><b>name</b> (text)</li><li><b>version</b> (text)</li><li><b>suite</b> (text)</li><li><b>architecture </b>(text)</li><li><font color="#006600"><b>unique (name, suite, architecture)</b></font></li></ul></div></div></foreignObject><text x="113" y="100" fill="#000000" text-anchor="middle" font-size="17px" font-family="Helvetica">[Not supported by viewer]</text></switch></g><path d="M 241 34 L 241 16.4 Q 241 2 226.6 2 L 16.4 2 Q 2 2 2 16.4 L 2 34 Z" fill="#008cff" stroke="#000000" stroke-width="2" stroke-miterlimit="10" pointer-events="none"/><path d="M 2 34 L 2 107.6 Q 2 122 16.4 122 L 226.6 122 Q 241 122 241 107.6 L 241 34" fill="none" stroke="#000000" stroke-width="2" stroke-miterlimit="10" pointer-events="none"/><g transform="translate(92,10)"><switch><foreignObject pointer-events="all" width="59" height="23" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility"><div xmlns="http://www.w3.org/1999/xhtml" style="display: inline-block; font-size: 17px; font-family: Helvetica; color: rgb(255, 255, 255); line-height: 1.26; vertical-align: top; white-space: nowrap; text-align: center;"><div xmlns="http://www.w3.org/1999/xhtml" style="display:inline-block;text-align:inherit;text-decoration:inherit;"><div><span style="line-height: 1.26">schema</span><br /></div></div></div></foreignObject><text x="30" y="20" fill="#FFFFFF" text-anchor="middle" font-size="17px" font-family="Helvetica">[Not supported by viewer]</text></switch></g><rect x="2" y="34" width="239" height="88" fill="none" stroke="none" pointer-events="none"/><g transform="translate(8,41)"><switch><foreignObject pointer-events="all" width="188" height="78" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility"><div xmlns="http://www.w3.org/1999/xhtml" style="display: inline-block; font-size: 17px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.26; vertical-align: top; width: 188px; white-space: normal;"><div xmlns="http://www.w3.org/1999/xhtml" style="display:inline-block;text-align:inherit;text-decoration:inherit;"><ul style="line-height: 21.4200000762939px"><li><b style="line-height: 21.4200000762939px">version</b><span style="line-height: 21.4200000762939px"> (int, PK)</span></li><li><b>date</b> (text, not null)</li></ul></div></div></foreignObject><text x="94" y="48" fill="#000000" text-anchor="middle" font-size="17px" font-family="Helvetica">[Not supported by viewer]</text></switch></g><path d="M 1046 50 L 1046 32.4 Q 1046 18 1031.6 18 L 720.4 18 Q 706 18 706 32.4 L 706 50 Z" fill="#008cff" stroke="#000000" stroke-width="2" stroke-miterlimit="10" pointer-events="none"/><path d="M 706 50 L 706 223.6 Q 706 238 720.4 238 L 1031.6 238 Q 1046 238 1046 223.6 L 1046 50" fill="none" stroke="#000000" stroke-width="2" stroke-miterlimit="10" pointer-events="none"/><g transform="translate(842,26)"><switch><foreignObject pointer-events="all" width="67" height="23" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility"><div xmlns="http://www.w3.org/1999/xhtml" style="display: inline-block; font-size: 17px; font-family: Helvetica; color: rgb(255, 255, 255); line-height: 1.26; vertical-align: top; white-space: nowrap; text-align: center;"><div xmlns="http://www.w3.org/1999/xhtml" style="display:inline-block;text-align:inherit;text-decoration:inherit;">schedule</div></div></foreignObject><text x="34" y="20" fill="#FFFFFF" text-anchor="middle" font-size="17px" font-family="Helvetica">[Not supported by viewer]</text></switch></g><rect x="706" y="50" width="340" height="188" fill="none" stroke="none" pointer-events="none"/><g transform="translate(712,57)"><switch><foreignObject pointer-events="all" width="300" height="162" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility"><div xmlns="http://www.w3.org/1999/xhtml" style="display: inline-block; font-size: 17px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.26; vertical-align: top; width: 300px; white-space: normal;"><div xmlns="http://www.w3.org/1999/xhtml" style="display:inline-block;text-align:inherit;text-decoration:inherit;"><ul style="line-height: 21.4200000762939px"><li><b>id </b>(int, PK)</li><li><b>package_id</b> (text, not null, FK)</li><li><b style="line-height: 21.4200000762939px">date_scheduled </b><span style="line-height: 21.4200000762939px">(text, not null)</span><br /></li><li><b>date_build_started</b> (text, not null)</li><li><b>save_artifacts </b>(int)</li><li><font color="#006600"><b>unique (package, version)</b></font></li></ul></div></div></foreignObject><text x="150" y="90" fill="#000000" text-anchor="middle" font-size="17px" font-family="Helvetica">[Not supported by viewer]</text></switch></g><path d="M 1066 525 L 1066 507.4 Q 1066 493 1051.6 493 L 790.4 493 Q 776 493 776 507.4 L 776 525 Z" fill="#008cff" stroke="#000000" stroke-width="2" stroke-miterlimit="10" pointer-events="none"/><path d="M 776 525 L 776 758.6 Q 776 773 790.4 773 L 1051.6 773 Q 1066 773 1066 758.6 L 1066 525" fill="none" stroke="#000000" stroke-width="2" stroke-miterlimit="10" pointer-events="none"/><g transform="translate(878,501)"><switch><foreignObject pointer-events="all" width="86" height="23" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility"><div xmlns="http://www.w3.org/1999/xhtml" style="display: inline-block; font-size: 17px; font-family: Helvetica; color: rgb(255, 255, 255); line-height: 1.26; vertical-align: top; white-space: nowrap; text-align: center;"><div xmlns="http://www.w3.org/1999/xhtml" style="display:inline-block;text-align:inherit;text-decoration:inherit;">stats_builds</div></div></foreignObject><text x="43" y="20" fill="#FFFFFF" text-anchor="middle" font-size="17px" font-family="Helvetica">[Not supported by viewer]</text></switch></g><rect x="776" y="525" width="290" height="248" fill="none" stroke="none" pointer-events="none"/><g transform="translate(782,532)"><switch><foreignObject pointer-events="all" width="286" height="246" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility"><div xmlns="http://www.w3.org/1999/xhtml" style="display: inline-block; font-size: 17px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.26; vertical-align: top; width: 284px; white-space: normal;"><div xmlns="http://www.w3.org/1999/xhtml" style="display:inline-block;text-align:inherit;text-decoration:inherit;"><ul style="line-height: 21.4200000762939px"><li><b>id </b>(int, PK)</li><li><b>name</b> (text, not null)</li><li><b>version </b>(text, not null)</li><li><b>suite</b> (text, not null)</li><li><b>architecture </b>(text, not null)</li><li><b>status </b>(text, not null)</li><li><b>build_date</b> (text, not null)</li><li><b>build_duration </b>(text, not null)</li><li><font color="#006600"><b>unique (name, version, suite, architecture, build_date)</b></font></li></ul></div></div></foreignObject><text x="143" y="132" fill="#000000" text-anchor="middle" font-size="17px" font-family="Helvetica">[Not supported by viewer]</text></switch></g><path d="M 696 83 L 606 263" fill="none" stroke="#000000" stroke-miterlimit="10" pointer-events="none"/><path d="M 609.58 264.79 L 609.58 255.84 L 602.42 261.21" fill="none" stroke="#000000" stroke-miterlimit="10" pointer-events="none"/><path d="M 265 513 L 396 333" fill="none" stroke="#000000" stroke-miterlimit="10" pointer-events="none"/><path d="M 392.77 330.65 L 391.29 339.47 L 399.23 335.35" fill="none" stroke="#000000" stroke-miterlimit="10" pointer-events="none"/><rect x="776.33" y="381.33" width="370" height="60" fill="none" stroke="none" pointer-events="none"/><g transform="translate(778,384)"><switch><foreignObject pointer-events="all" width="361" height="82" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility"><div xmlns="http://www.w3.org/1999/xhtml" style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.26; vertical-align: top; white-space: nowrap;"><div xmlns="http://www.w3.org/1999/xhtml" style="display:inline-block;text-align:inherit;text-decoration:inherit;"><div><font size="3">This table is quite the same of <i>results</i>, but</font></div><div><font size="3">it is meant to keep record of all builds.</font></div><div><font size="3">The choice of duplicating data in this way is done for</font></div><div><font size="3">performarce reasones.</font></div></div></div></foreignObject><text x="181" y="47" fill="#000000" text-anchor="middle" font-size="12px" font-family="Helvetica">[Not supported by viewer]</text></switch></g></g></svg>
\ No newline at end of file +<svg xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" width="1148px" height="779px" version="1.1"><defs/><g transform="translate(0.5,0.5)"><path d="M 296 555 L 296 537.4 Q 296 523 281.6 523 L 40.4 523 Q 26 523 26 537.4 L 26 555 Z" fill="#008cff" stroke="#000000" stroke-width="2" stroke-miterlimit="10" pointer-events="none"/><path d="M 26 555 L 26 728.6 Q 26 743 40.4 743 L 281.6 743 Q 296 743 296 728.6 L 296 555" fill="none" stroke="#000000" stroke-width="2" stroke-miterlimit="10" pointer-events="none"/><g transform="translate(136,531)"><switch><foreignObject pointer-events="all" width="49" height="23" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility"><div xmlns="http://www.w3.org/1999/xhtml" style="display: inline-block; font-size: 17px; font-family: Helvetica; color: rgb(255, 255, 255); line-height: 1.26; vertical-align: top; white-space: nowrap; text-align: center;"><div xmlns="http://www.w3.org/1999/xhtml" style="display:inline-block;text-align:inherit;text-decoration:inherit;">results</div></div></foreignObject><text x="25" y="20" fill="#FFFFFF" text-anchor="middle" font-size="17px" font-family="Helvetica">[Not supported by viewer]</text></switch></g><rect x="26" y="555" width="270" height="188" fill="none" stroke="none" pointer-events="none"/><g transform="translate(32,562)"><switch><foreignObject pointer-events="all" width="266" height="183" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility"><div xmlns="http://www.w3.org/1999/xhtml" style="display: inline-block; font-size: 17px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.26; vertical-align: top; width: 266px; white-space: normal;"><div xmlns="http://www.w3.org/1999/xhtml" style="display:inline-block;text-align:inherit;text-decoration:inherit;"><ul style="line-height: 21.4200000762939px"><li><b>id </b>(int, PK)</li><li><b>package_id</b> (int, not null, FK)</li><li><b>version </b>(text, not null)</li><li><b>status </b>(text)</li><li><b>build_date</b> (text)</li><li><b>build_duration </b>(text)</li><li><font color="#006600"><b>unique (package, version)</b></font></li></ul></div></div></foreignObject><text x="133" y="100" fill="#000000" text-anchor="middle" font-size="17px" font-family="Helvetica">[Not supported by viewer]</text></switch></g><path d="M 636 302 L 636 284.4 Q 636 270 621.6 270 L 420.4 270 Q 406 270 406 284.4 L 406 302 Z" fill="#008cff" stroke="#000000" stroke-width="2" stroke-miterlimit="10" pointer-events="none"/><path d="M 406 302 L 406 465.6 Q 406 480 420.4 480 L 621.6 480 Q 636 480 636 465.6 L 636 302" fill="none" stroke="#000000" stroke-width="2" stroke-miterlimit="10" pointer-events="none"/><g transform="translate(491,278)"><switch><foreignObject pointer-events="all" width="60" height="23" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility"><div xmlns="http://www.w3.org/1999/xhtml" style="display: inline-block; font-size: 17px; font-family: Helvetica; color: rgb(255, 255, 255); line-height: 1.26; vertical-align: top; white-space: nowrap; text-align: center;"><div xmlns="http://www.w3.org/1999/xhtml" style="display:inline-block;text-align:inherit;text-decoration:inherit;">sources</div></div></foreignObject><text x="30" y="20" fill="#FFFFFF" text-anchor="middle" font-size="17px" font-family="Helvetica">[Not supported by viewer]</text></switch></g><rect x="406" y="302" width="230" height="178" fill="none" stroke="none" pointer-events="none"/><g transform="translate(412,309)"><switch><foreignObject pointer-events="all" width="226" height="183" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility"><div xmlns="http://www.w3.org/1999/xhtml" style="display: inline-block; font-size: 17px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.26; vertical-align: top; width: 224px; white-space: normal;"><div xmlns="http://www.w3.org/1999/xhtml" style="display:inline-block;text-align:inherit;text-decoration:inherit;"><ul style="line-height: 21.4200000762939px"><li><span style="background-color: rgb(242 , 0 , 69)"><b>id </b>(int, PK)</span></li><li><b>name</b> (text)</li><li><b>version</b> (text)</li><li><b>suite</b> (text)</li><li><b>architecture </b>(text)</li><li><font color="#006600"><b>unique (name, suite, architecture)</b></font></li></ul></div></div></foreignObject><text x="113" y="100" fill="#000000" text-anchor="middle" font-size="17px" font-family="Helvetica">[Not supported by viewer]</text></switch></g><path d="M 241 34 L 241 16.4 Q 241 2 226.6 2 L 16.4 2 Q 2 2 2 16.4 L 2 34 Z" fill="#008cff" stroke="#000000" stroke-width="2" stroke-miterlimit="10" pointer-events="none"/><path d="M 2 34 L 2 107.6 Q 2 122 16.4 122 L 226.6 122 Q 241 122 241 107.6 L 241 34" fill="none" stroke="#000000" stroke-width="2" stroke-miterlimit="10" pointer-events="none"/><g transform="translate(92,10)"><switch><foreignObject pointer-events="all" width="59" height="23" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility"><div xmlns="http://www.w3.org/1999/xhtml" style="display: inline-block; font-size: 17px; font-family: Helvetica; color: rgb(255, 255, 255); line-height: 1.26; vertical-align: top; white-space: nowrap; text-align: center;"><div xmlns="http://www.w3.org/1999/xhtml" style="display:inline-block;text-align:inherit;text-decoration:inherit;"><div><span style="line-height: 1.26">schema</span><br /></div></div></div></foreignObject><text x="30" y="20" fill="#FFFFFF" text-anchor="middle" font-size="17px" font-family="Helvetica">[Not supported by viewer]</text></switch></g><rect x="2" y="34" width="239" height="88" fill="none" stroke="none" pointer-events="none"/><g transform="translate(8,41)"><switch><foreignObject pointer-events="all" width="188" height="78" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility"><div xmlns="http://www.w3.org/1999/xhtml" style="display: inline-block; font-size: 17px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.26; vertical-align: top; width: 188px; white-space: normal;"><div xmlns="http://www.w3.org/1999/xhtml" style="display:inline-block;text-align:inherit;text-decoration:inherit;"><ul style="line-height: 21.4200000762939px"><li><b style="line-height: 21.4200000762939px">version</b><span style="line-height: 21.4200000762939px"> (int, PK)</span></li><li><b>date</b> (text, not null)</li></ul></div></div></foreignObject><text x="94" y="48" fill="#000000" text-anchor="middle" font-size="17px" font-family="Helvetica">[Not supported by viewer]</text></switch></g><path d="M 1046 50 L 1046 32.4 Q 1046 18 1031.6 18 L 720.4 18 Q 706 18 706 32.4 L 706 50 Z" fill="#008cff" stroke="#000000" stroke-width="2" stroke-miterlimit="10" pointer-events="none"/><path d="M 706 50 L 706 223.6 Q 706 238 720.4 238 L 1031.6 238 Q 1046 238 1046 223.6 L 1046 50" fill="none" stroke="#000000" stroke-width="2" stroke-miterlimit="10" pointer-events="none"/><g transform="translate(842,26)"><switch><foreignObject pointer-events="all" width="67" height="23" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility"><div xmlns="http://www.w3.org/1999/xhtml" style="display: inline-block; font-size: 17px; font-family: Helvetica; color: rgb(255, 255, 255); line-height: 1.26; vertical-align: top; white-space: nowrap; text-align: center;"><div xmlns="http://www.w3.org/1999/xhtml" style="display:inline-block;text-align:inherit;text-decoration:inherit;">schedule</div></div></foreignObject><text x="34" y="20" fill="#FFFFFF" text-anchor="middle" font-size="17px" font-family="Helvetica">[Not supported by viewer]</text></switch></g><rect x="706" y="50" width="340" height="188" fill="none" stroke="none" pointer-events="none"/><g transform="translate(712,57)"><switch><foreignObject pointer-events="all" width="300" height="162" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility"><div xmlns="http://www.w3.org/1999/xhtml" style="display: inline-block; font-size: 17px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.26; vertical-align: top; width: 300px; white-space: normal;"><div xmlns="http://www.w3.org/1999/xhtml" style="display:inline-block;text-align:inherit;text-decoration:inherit;"><ul style="line-height: 21.4200000762939px"><li><b>id </b>(int, PK)</li><li><b>package_id</b> (text, not null, FK)</li><li><b style="line-height: 21.4200000762939px">date_scheduled </b><span style="line-height: 21.4200000762939px">(text, not null)</span><br /></li><li><b>date_build_started</b> (text, not null)</li><li><b>save_artifacts </b>(int)</li><li><font color="#006600"><b>unique (package, version)</b></font></li></ul></div></div></foreignObject><text x="150" y="90" fill="#000000" text-anchor="middle" font-size="17px" font-family="Helvetica">[Not supported by viewer]</text></switch></g><path d="M 1066 525 L 1066 507.4 Q 1066 493 1051.6 493 L 790.4 493 Q 776 493 776 507.4 L 776 525 Z" fill="#008cff" stroke="#000000" stroke-width="2" stroke-miterlimit="10" pointer-events="none"/><path d="M 776 525 L 776 758.6 Q 776 773 790.4 773 L 1051.6 773 Q 1066 773 1066 758.6 L 1066 525" fill="none" stroke="#000000" stroke-width="2" stroke-miterlimit="10" pointer-events="none"/><g transform="translate(878,501)"><switch><foreignObject pointer-events="all" width="86" height="23" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility"><div xmlns="http://www.w3.org/1999/xhtml" style="display: inline-block; font-size: 17px; font-family: Helvetica; color: rgb(255, 255, 255); line-height: 1.26; vertical-align: top; white-space: nowrap; text-align: center;"><div xmlns="http://www.w3.org/1999/xhtml" style="display:inline-block;text-align:inherit;text-decoration:inherit;">stats_build</div></div></foreignObject><text x="43" y="20" fill="#FFFFFF" text-anchor="middle" font-size="17px" font-family="Helvetica">[Not supported by viewer]</text></switch></g><rect x="776" y="525" width="290" height="248" fill="none" stroke="none" pointer-events="none"/><g transform="translate(782,532)"><switch><foreignObject pointer-events="all" width="286" height="246" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility"><div xmlns="http://www.w3.org/1999/xhtml" style="display: inline-block; font-size: 17px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.26; vertical-align: top; width: 284px; white-space: normal;"><div xmlns="http://www.w3.org/1999/xhtml" style="display:inline-block;text-align:inherit;text-decoration:inherit;"><ul style="line-height: 21.4200000762939px"><li><b>id </b>(int, PK)</li><li><b>name</b> (text, not null)</li><li><b>version </b>(text, not null)</li><li><b>suite</b> (text, not null)</li><li><b>architecture </b>(text, not null)</li><li><b>status </b>(text, not null)</li><li><b>build_date</b> (text, not null)</li><li><b>build_duration </b>(text, not null)</li><li><font color="#006600"><b>unique (name, version, suite, architecture, build_date)</b></font></li></ul></div></div></foreignObject><text x="143" y="132" fill="#000000" text-anchor="middle" font-size="17px" font-family="Helvetica">[Not supported by viewer]</text></switch></g><path d="M 696 83 L 606 263" fill="none" stroke="#000000" stroke-miterlimit="10" pointer-events="none"/><path d="M 609.58 264.79 L 609.58 255.84 L 602.42 261.21" fill="none" stroke="#000000" stroke-miterlimit="10" pointer-events="none"/><path d="M 265 513 L 396 333" fill="none" stroke="#000000" stroke-miterlimit="10" pointer-events="none"/><path d="M 392.77 330.65 L 391.29 339.47 L 399.23 335.35" fill="none" stroke="#000000" stroke-miterlimit="10" pointer-events="none"/><rect x="776.33" y="381.33" width="370" height="60" fill="none" stroke="none" pointer-events="none"/><g transform="translate(778,384)"><switch><foreignObject pointer-events="all" width="361" height="82" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility"><div xmlns="http://www.w3.org/1999/xhtml" style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.26; vertical-align: top; white-space: nowrap;"><div xmlns="http://www.w3.org/1999/xhtml" style="display:inline-block;text-align:inherit;text-decoration:inherit;"><div><font size="3">This table is quite the same of <i>results</i>, but</font></div><div><font size="3">it is meant to keep record of all builds.</font></div><div><font size="3">The choice of duplicating data in this way is done for</font></div><div><font size="3">performarce reasones.</font></div></div></div></foreignObject><text x="181" y="47" fill="#000000" text-anchor="middle" font-size="12px" font-family="Helvetica">[Not supported by viewer]</text></switch></g></g></svg> |
