diff options
author | Erich Eckner <git@eckner.net> | 2019-06-18 10:36:01 +0200 |
---|---|---|
committer | Erich Eckner <git@eckner.net> | 2019-06-18 10:36:01 +0200 |
commit | f286f76871841745021ede6a4dba8ef2bbffdafe (patch) | |
tree | 2d1e0b1195b58fb8af4a52112ab2d8ffd2804326 | |
parent | 309a37a0c59471c3f1848493986ea0c1d887342d (diff) | |
download | builder-f286f76871841745021ede6a4dba8ef2bbffdafe.tar.xz |
new column `build_assignments`.`currently_blocking` to count how many dependent package builds are blocked by this build_assignment
-rw-r--r-- | misc/database-layout.dmf | 276 | ||||
-rw-r--r-- | misc/database-layout.dump | 1 |
2 files changed, 142 insertions, 135 deletions
diff --git a/misc/database-layout.dmf b/misc/database-layout.dmf index 019de29..d96301b 100644 --- a/misc/database-layout.dmf +++ b/misc/database-layout.dmf @@ -58,8 +58,8 @@ </item> <item type="database-table" id="{fdd7ff7b-7a96-4625-9287-820e1b076c2a}"> <position> - <x>29</x> - <y>569</y> + <x>47</x> + <y>594</y> </position> <table> <name>toolchain_order</name> @@ -370,8 +370,8 @@ </item> <item type="database-table" id="{04b6fdc5-85ae-4416-8db5-034ad05be93a}"> <position> - <x>69</x> - <y>483</y> + <x>65</x> + <y>509</y> </position> <table> <name>build_dependency_loops</name> @@ -484,8 +484,8 @@ </item> <item type="database-table" id="{7c210122-c51d-4724-b7cc-22f143bc47ac}"> <position> - <x>248</x> - <y>499</y> + <x>247</x> + <y>534</y> </position> <table> <name>package_sources</name> @@ -905,6 +905,12 @@ <required>False</required> <primary-key>False</primary-key> </column> + <column> + <name>currently_blocking</name> + <data-type>MEDIUMINT</data-type> + <required>False</required> + <primary-key>False</primary-key> + </column> </column-list> </table> </item> @@ -1466,15 +1472,15 @@ <connector> <position> <x>826</x> - <y>148.922</y> + <y>149.406</y> </position> <angle>180</angle> <hub owner="{9085c36f-5884-41c8-9ca8-9d53973e657d}"/> </connector> <connector> <position> - <x>490.5</x> - <y>329.615</y> + <x>489.547</x> + <y>329.938</y> </position> <angle>0</angle> <hub owner="{04f424bf-6465-478b-9529-0038615b51d9}"/> @@ -1499,15 +1505,15 @@ <connector> <position> <x>817</x> - <y>520.922</y> + <y>521.406</y> </position> <angle>180</angle> <hub owner="{fa0bc448-5ecc-4238-9d76-da742ab6eb14}"/> </connector> <connector> <position> - <x>678.984</x> - <y>592.281</y> + <x>677.453</x> + <y>592.604</y> </position> <angle>0</angle> <hub owner="{d01e6205-a6dc-4724-a1fd-d4b2f73637ea}"/> @@ -1531,16 +1537,16 @@ <connector-list> <connector> <position> - <x>138.656</x> - <y>593.922</y> + <x>155.547</x> + <y>619.406</y> </position> <angle>0</angle> <hub owner="{fdd7ff7b-7a96-4625-9287-820e1b076c2a}"/> </connector> <connector> <position> - <x>248</x> - <y>565.922</y> + <x>247</x> + <y>601.406</y> </position> <angle>180</angle> <hub owner="{7c210122-c51d-4724-b7cc-22f143bc47ac}"/> @@ -1564,15 +1570,15 @@ <connector-list> <connector> <position> - <x>447.167</x> - <y>34.8438</y> + <x>446.115</x> + <y>35.8125</y> </position> <angle>270</angle> <hub owner="{caab4a73-46dc-49dc-ac51-d8ae916827c5}"/> </connector> <connector> <position> - <x>525.008</x> + <x>524.594</x> <y>57</y> </position> <angle>90</angle> @@ -1598,15 +1604,15 @@ <connector> <position> <x>613</x> - <y>116.615</y> + <y>116.938</y> </position> <angle>180</angle> <hub owner="{f8caa2d5-11ba-485c-b273-8183713896bf}"/> </connector> <connector> <position> - <x>567.016</x> - <y>95.9219</y> + <x>566.188</x> + <y>96.4063</y> </position> <angle>0</angle> <hub owner="{a67b38a9-c701-412c-8292-5ef58536da85}"/> @@ -1630,8 +1636,8 @@ <connector-list> <connector> <position> - <x>498.25</x> - <y>-35.7188</y> + <x>496.672</x> + <y>-35.3958</y> </position> <angle>0</angle> <hub owner="{caab4a73-46dc-49dc-ac51-d8ae916827c5}"/> @@ -1639,7 +1645,7 @@ <connector> <position> <x>580</x> - <y>-32.0781</y> + <y>-31.5938</y> </position> <angle>180</angle> <hub owner="{be821d83-a9b4-4c0c-8e1b-433730200714}"/> @@ -1663,8 +1669,8 @@ <connector-list> <connector> <position> - <x>498.25</x> - <y>-0.4375</y> + <x>496.672</x> + <y>0.208333</y> </position> <angle>0</angle> <hub owner="{caab4a73-46dc-49dc-ac51-d8ae916827c5}"/> @@ -1672,7 +1678,7 @@ <connector> <position> <x>653</x> - <y>45.9219</y> + <y>46.4063</y> </position> <angle>180</angle> <hub owner="{e84f8e5f-28e0-4d8b-a7e5-0f80a896f74e}"/> @@ -1696,15 +1702,15 @@ <connector-list> <connector> <position> - <x>652.008</x> - <y>279.844</y> + <x>650.922</x> + <y>280.813</y> </position> <angle>270</angle> <hub owner="{b33d4844-b4e4-4ef6-944b-36b4113c2b82}"/> </connector> <connector> <position> - <x>779.547</x> + <x>778.703</x> <y>300</y> </position> <angle>90</angle> @@ -1729,15 +1735,15 @@ <connector-list> <connector> <position> - <x>396.083</x> - <y>34.8438</y> + <x>395.557</x> + <y>35.8125</y> </position> <angle>270</angle> <hub owner="{caab4a73-46dc-49dc-ac51-d8ae916827c5}"/> </connector> <connector> <position> - <x>382.773</x> + <x>381.93</x> <y>99</y> </position> <angle>90</angle> @@ -1763,15 +1769,15 @@ <connector> <position> <x>546</x> - <y>233.922</y> + <y>234.406</y> </position> <angle>180</angle> <hub owner="{b33d4844-b4e4-4ef6-944b-36b4113c2b82}"/> </connector> <connector> <position> - <x>466.547</x> - <y>225.562</y> + <x>464.859</x> + <y>226.208</y> </position> <angle>0</angle> <hub owner="{2e6c3b80-fef6-4d2b-8945-7ea6be1b646c}"/> @@ -1795,8 +1801,8 @@ <connector-list> <connector> <position> - <x>60.6406</x> - <y>179.922</y> + <x>59.5313</x> + <y>180.406</y> </position> <angle>0</angle> <hub owner="{5f12db03-a8bb-4467-bab6-a57e545b9081}"/> @@ -1804,7 +1810,7 @@ <connector> <position> <x>118</x> - <y>221.922</y> + <y>222.406</y> </position> <angle>180</angle> <hub owner="{a945e439-8796-49e8-aa9b-7ce0a58a2c26}"/> @@ -1828,15 +1834,15 @@ <connector-list> <connector> <position> - <x>689.336</x> - <y>481.844</y> + <x>688.133</x> + <y>482.813</y> </position> <angle>270</angle> <hub owner="{d823ab09-1c04-44ee-ad4b-6802208967ff}"/> </connector> <connector> <position> - <x>603.492</x> + <x>602.727</x> <y>571</y> </position> <angle>90</angle> @@ -1861,7 +1867,7 @@ <connector-list> <connector> <position> - <x>649.557</x> + <x>648.755</x> <y>404</y> </position> <angle>90</angle> @@ -1869,8 +1875,8 @@ </connector> <connector> <position> - <x>808.062</x> - <y>391.844</y> + <x>750.469</x> + <y>392.813</y> </position> <angle>270</angle> <hub owner="{844766fc-c5af-4f61-b51b-d3f9393c60ca}"/> @@ -1894,7 +1900,7 @@ <connector-list> <connector> <position> - <x>729.115</x> + <x>727.51</x> <y>404</y> </position> <angle>90</angle> @@ -1902,8 +1908,8 @@ </connector> <connector> <position> - <x>751.031</x> - <y>391.844</y> + <x>806.938</x> + <y>392.813</y> </position> <angle>270</angle> <hub owner="{844766fc-c5af-4f61-b51b-d3f9393c60ca}"/> @@ -1927,15 +1933,15 @@ <connector-list> <connector> <position> - <x>410.698</x> - <y>288.844</y> + <x>409.573</x> + <y>289.813</y> </position> <angle>270</angle> <hub owner="{2e6c3b80-fef6-4d2b-8945-7ea6be1b646c}"/> </connector> <connector> <position> - <x>442.75</x> + <x>442.273</x> <y>313</y> </position> <angle>90</angle> @@ -1960,8 +1966,8 @@ <connector-list> <connector> <position> - <x>865.094</x> - <y>345.922</y> + <x>863.406</x> + <y>346.406</y> </position> <angle>0</angle> <hub owner="{844766fc-c5af-4f61-b51b-d3f9393c60ca}"/> @@ -1969,7 +1975,7 @@ <connector> <position> <x>899</x> - <y>421.922</y> + <y>422.406</y> </position> <angle>180</angle> <hub owner="{fee50b4d-969b-4b5f-8545-90ea8f8f7aec}"/> @@ -1993,7 +1999,7 @@ <connector-list> <connector> <position> - <x>707.117</x> + <x>706.203</x> <y>86</y> </position> <angle>90</angle> @@ -2001,8 +2007,8 @@ </connector> <connector> <position> - <x>703.516</x> - <y>70.8438</y> + <x>703.016</x> + <y>71.8125</y> </position> <angle>270</angle> <hub owner="{e84f8e5f-28e0-4d8b-a7e5-0f80a896f74e}"/> @@ -2027,15 +2033,15 @@ <connector> <position> <x>613</x> - <y>147.229</y> + <y>147.875</y> </position> <angle>180</angle> <hub owner="{f8caa2d5-11ba-485c-b273-8183713896bf}"/> </connector> <connector> <position> - <x>466.547</x> - <y>162.281</y> + <x>464.859</x> + <y>162.604</y> </position> <angle>0</angle> <hub owner="{2e6c3b80-fef6-4d2b-8945-7ea6be1b646c}"/> @@ -2059,8 +2065,8 @@ <connector-list> <connector> <position> - <x>486.672</x> - <y>565.922</y> + <x>483.266</x> + <y>601.406</y> </position> <angle>0</angle> <hub owner="{7c210122-c51d-4724-b7cc-22f143bc47ac}"/> @@ -2068,7 +2074,7 @@ <connector> <position> <x>528</x> - <y>602.922</y> + <y>603.406</y> </position> <angle>180</angle> <hub owner="{d01e6205-a6dc-4724-a1fd-d4b2f73637ea}"/> @@ -2092,8 +2098,8 @@ <connector-list> <connector> <position> - <x>678.984</x> - <y>613.562</y> + <x>677.453</x> + <y>614.208</y> </position> <angle>0</angle> <hub owner="{d01e6205-a6dc-4724-a1fd-d4b2f73637ea}"/> @@ -2101,7 +2107,7 @@ <connector> <position> <x>817</x> - <y>631.922</y> + <y>632.406</y> </position> <angle>180</angle> <hub owner="{b3c86235-971a-4d3e-873c-c4179aa96cbc}"/> @@ -2125,16 +2131,16 @@ <connector-list> <connector> <position> - <x>290.906</x> - <y>459.844</y> + <x>291.854</x> + <y>474.813</y> </position> <angle>270</angle> <hub owner="{6ea5c997-98b5-4ec8-b63e-3f2acdcaf627}"/> </connector> <connector> <position> - <x>367.336</x> - <y>499</y> + <x>365.133</x> + <y>534</y> </position> <angle>90</angle> <hub owner="{7c210122-c51d-4724-b7cc-22f143bc47ac}"/> @@ -2158,8 +2164,8 @@ <connector-list> <connector> <position> - <x>338.359</x> - <y>392.922</y> + <x>339.781</x> + <y>400.406</y> </position> <angle>0</angle> <hub owner="{6ea5c997-98b5-4ec8-b63e-3f2acdcaf627}"/> @@ -2167,7 +2173,7 @@ <connector> <position> <x>395</x> - <y>337.922</y> + <y>338.406</y> </position> <angle>180</angle> <hub owner="{04f424bf-6465-478b-9529-0038615b51d9}"/> @@ -2191,15 +2197,15 @@ <connector-list> <connector> <position> - <x>354.849</x> - <y>288.844</y> + <x>354.286</x> + <y>289.813</y> </position> <angle>270</angle> <hub owner="{2e6c3b80-fef6-4d2b-8945-7ea6be1b646c}"/> </connector> <connector> <position> - <x>290.906</x> + <x>291.854</x> <y>326</y> </position> <angle>90</angle> @@ -2224,15 +2230,15 @@ <connector-list> <connector> <position> - <x>213.26</x> - <y>295.844</y> + <x>212.302</x> + <y>296.813</y> </position> <angle>270</angle> <hub owner="{a945e439-8796-49e8-aa9b-7ce0a58a2c26}"/> </connector> <connector> <position> - <x>243.453</x> + <x>243.927</x> <y>326</y> </position> <angle>90</angle> @@ -2257,16 +2263,16 @@ <connector-list> <connector> <position> - <x>151.016</x> - <y>483</y> + <x>146.195</x> + <y>509</y> </position> <angle>90</angle> <hub owner="{04b6fdc5-85ae-4416-8db5-034ad05be93a}"/> </connector> <connector> <position> - <x>243.453</x> - <y>459.844</y> + <x>243.927</x> + <y>474.813</y> </position> <angle>270</angle> <hub owner="{6ea5c997-98b5-4ec8-b63e-3f2acdcaf627}"/> @@ -2290,7 +2296,7 @@ <connector-list> <connector> <position> - <x>85.1458</x> + <x>84.1458</x> <y>342</y> </position> <angle>90</angle> @@ -2298,8 +2304,8 @@ </connector> <connector> <position> - <x>165.63</x> - <y>295.844</y> + <x>165.151</x> + <y>296.813</y> </position> <angle>270</angle> <hub owner="{a945e439-8796-49e8-aa9b-7ce0a58a2c26}"/> @@ -2323,8 +2329,8 @@ <connector-list> <connector> <position> - <x>136.219</x> - <y>401.922</y> + <x>134.719</x> + <y>402.406</y> </position> <angle>0</angle> <hub owner="{a774fcb7-1193-4b57-947c-135212695915}"/> @@ -2332,7 +2338,7 @@ <connector> <position> <x>196</x> - <y>392.922</y> + <y>400.406</y> </position> <angle>180</angle> <hub owner="{6ea5c997-98b5-4ec8-b63e-3f2acdcaf627}"/> @@ -2356,7 +2362,7 @@ <connector-list> <connector> <position> - <x>34.0729</x> + <x>33.5729</x> <y>342</y> </position> <angle>90</angle> @@ -2364,8 +2370,8 @@ </connector> <connector> <position> - <x>-4.80469</x> - <y>317.844</y> + <x>-5.0625</x> + <y>318.813</y> </position> <angle>270</angle> <hub owner="{7b159780-7f39-45a7-9557-046874a57e43}"/> @@ -2389,15 +2395,15 @@ <connector-list> <connector> <position> - <x>1009.6</x> - <y>351.844</y> + <x>1008.31</x> + <y>352.813</y> </position> <angle>270</angle> <hub owner="{92f54126-a433-458e-80b7-67235e560334}"/> </connector> <connector> <position> - <x>952.182</x> + <x>1004.27</x> <y>390</y> </position> <angle>90</angle> @@ -2422,15 +2428,15 @@ <connector-list> <connector> <position> - <x>946.302</x> - <y>351.844</y> + <x>945.656</x> + <y>352.813</y> </position> <angle>270</angle> <hub owner="{92f54126-a433-458e-80b7-67235e560334}"/> </connector> <connector> <position> - <x>1005.36</x> + <x>951.635</x> <y>390</y> </position> <angle>90</angle> @@ -2455,8 +2461,8 @@ <connector-list> <connector> <position> - <x>949.578</x> - <y>-32.3854</y> + <x>948.234</x> + <y>-32.0625</y> </position> <angle>0</angle> <hub owner="{36980651-4f03-4748-aee8-1f9211aaafde}"/> @@ -2464,7 +2470,7 @@ <connector> <position> <x>971</x> - <y>-7.77083</y> + <y>-38.0625</y> </position> <angle>180</angle> <hub owner="{dc01c567-d657-4db7-8a55-d2763ed00cee}"/> @@ -2488,8 +2494,8 @@ <connector-list> <connector> <position> - <x>949.578</x> - <y>-15.7708</y> + <x>948.234</x> + <y>-15.125</y> </position> <angle>0</angle> <hub owner="{36980651-4f03-4748-aee8-1f9211aaafde}"/> @@ -2497,7 +2503,7 @@ <connector> <position> <x>971</x> - <y>-38.3854</y> + <y>-7.125</y> </position> <angle>180</angle> <hub owner="{dc01c567-d657-4db7-8a55-d2763ed00cee}"/> @@ -2521,8 +2527,8 @@ <connector-list> <connector> <position> - <x>213.297</x> - <y>-19.0781</y> + <x>212.656</x> + <y>-18.5938</y> </position> <angle>0</angle> <hub owner="{f31249ea-ab19-45a4-9427-1854379ad8e7}"/> @@ -2530,7 +2536,7 @@ <connector> <position> <x>240</x> - <y>-41.0781</y> + <y>-40.5938</y> </position> <angle>180</angle> <hub owner="{75e4ebd8-5915-4aff-8316-0c542d3953da}"/> @@ -2554,8 +2560,8 @@ <connector-list> <connector> <position> - <x>36.1719</x> - <y>-12.0781</y> + <x>35.2969</x> + <y>-11.5938</y> </position> <angle>0</angle> <hub owner="{5cbe15f1-fea8-48eb-a84f-97f7e22060f6}"/> @@ -2563,7 +2569,7 @@ <connector> <position> <x>106</x> - <y>-19.0781</y> + <y>-18.5938</y> </position> <angle>180</angle> <hub owner="{f31249ea-ab19-45a4-9427-1854379ad8e7}"/> @@ -2587,7 +2593,7 @@ <connector-list> <connector> <position> - <x>143.531</x> + <x>142.789</x> <y>42</y> </position> <angle>90</angle> @@ -2595,8 +2601,8 @@ </connector> <connector> <position> - <x>159.648</x> - <y>12.8438</y> + <x>159.328</x> + <y>13.8125</y> </position> <angle>270</angle> <hub owner="{f31249ea-ab19-45a4-9427-1854379ad8e7}"/> @@ -2621,15 +2627,15 @@ <connector> <position> <x>68</x> - <y>73.9219</y> + <y>74.4063</y> </position> <angle>180</angle> <hub owner="{b5671c08-e24a-4293-b983-3c86b1a6d622}"/> </connector> <connector> <position> - <x>44.4062</x> - <y>94.9219</y> + <x>43.4531</x> + <y>95.4063</y> </position> <angle>0</angle> <hub owner="{6180fcbf-5069-4d86-8919-fd39394f1813}"/> @@ -2653,15 +2659,15 @@ <connector-list> <connector> <position> - <x>-9.41406</x> - <y>47.8438</y> + <x>-9.85156</x> + <y>48.8125</y> </position> <angle>270</angle> <hub owner="{5cbe15f1-fea8-48eb-a84f-97f7e22060f6}"/> </connector> <connector> <position> - <x>-4.79688</x> + <x>-5.27344</x> <y>70</y> </position> <angle>90</angle> @@ -2686,7 +2692,7 @@ <connector-list> <connector> <position> - <x>189.445</x> + <x>188.727</x> <y>148</y> </position> <angle>90</angle> @@ -2694,8 +2700,8 @@ </connector> <connector> <position> - <x>282.648</x> - <y>83.8438</y> + <x>282.328</x> + <y>84.8125</y> </position> <angle>270</angle> <hub owner="{33867a1e-ef36-4cc2-a08e-7366f56fbf5f}"/> @@ -2719,7 +2725,7 @@ <connector-list> <connector> <position> - <x>282.648</x> + <x>282.328</x> <y>20</y> </position> <angle>90</angle> @@ -2727,8 +2733,8 @@ </connector> <connector> <position> - <x>275.641</x> - <y>-16.1562</y> + <x>275.289</x> + <y>-15.1875</y> </position> <angle>270</angle> <hub owner="{75e4ebd8-5915-4aff-8316-0c542d3953da}"/> @@ -2753,15 +2759,15 @@ <connector> <position> <x>694</x> - <y>345.922</y> + <y>346.406</y> </position> <angle>180</angle> <hub owner="{844766fc-c5af-4f61-b51b-d3f9393c60ca}"/> </connector> <connector> <position> - <x>490.5</x> - <y>346.229</y> + <x>489.547</x> + <y>346.875</y> </position> <angle>0</angle> <hub owner="{04f424bf-6465-478b-9529-0038615b51d9}"/> @@ -2785,7 +2791,7 @@ <connector-list> <connector> <position> - <x>434.854</x> + <x>434.229</x> <y>392</y> </position> <angle>90</angle> @@ -2793,8 +2799,8 @@ </connector> <connector> <position> - <x>458.667</x> - <y>362.844</y> + <x>426.516</x> + <y>363.813</y> </position> <angle>270</angle> <hub owner="{04f424bf-6465-478b-9529-0038615b51d9}"/> @@ -2818,7 +2824,7 @@ <connector-list> <connector> <position> - <x>498.708</x> + <x>497.458</x> <y>392</y> </position> <angle>90</angle> @@ -2826,8 +2832,8 @@ </connector> <connector> <position> - <x>426.833</x> - <y>362.844</y> + <x>458.031</x> + <y>363.813</y> </position> <angle>270</angle> <hub owner="{04f424bf-6465-478b-9529-0038615b51d9}"/> diff --git a/misc/database-layout.dump b/misc/database-layout.dump index 698a158..dc9848e 100644 --- a/misc/database-layout.dump +++ b/misc/database-layout.dump @@ -578,6 +578,7 @@ build_assignments CREATE TABLE `build_assignments` ( `priority` smallint(6) NOT NULL, `is_black_listed` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `return_date` timestamp NULL DEFAULT NULL, + `currently_blocking` mediumint(9) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `content` (`package_source`,`architecture`), KEY `architecture` (`architecture`), |