From 13226434ea25cedda7c0ce96c50bfe8febdd266a Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Tue, 5 Jun 2018 10:31:57 +0200 Subject: `build_slaves`.`is_sane` new --- misc/database-layout.dmf | 1480 +++++++++++++++++++++++---------------------- misc/database-layout.dump | 1 + 2 files changed, 744 insertions(+), 737 deletions(-) (limited to 'misc') diff --git a/misc/database-layout.dmf b/misc/database-layout.dmf index 295e412..0b3a864 100644 --- a/misc/database-layout.dmf +++ b/misc/database-layout.dmf @@ -2,13 +2,13 @@ Relational - + - 543 - 182 + 237 + 40 - binary_packages_in_repositories + ssh_keys#ffffff @@ -18,81 +18,51 @@ True - package - BIGINT - True - False - - - repository + owner MEDIUMINT True False - is_to_be_deleted - BIT - True - False - - - last_moved - TIMESTAMP + fingerprint + TEXT True False
- + - 42 - 135 + -68 + 71 - ssh_log + email_actions#ffffff id - BIGINT + MEDIUMINT True True - date - TIMESTAMP - True - False - - - build_slave - MEDIUMINT - False - False - - - action + name VARCHAR(32) True False - - parameters - TEXT - True - False -
- + - -55 - -72 + 68 + 49 - email_log + allowed_email_actions#ffffff @@ -102,92 +72,62 @@ True - date - TIMESTAMP - True - False - - - success - BIT + gpg_key + BIGINT True False action MEDIUMINT - False - False - - - count - MEDIUMINT - False - False - - - gpg_key - BIGINT - False - False - - - comment - TEXT - False + True False
- + - 494 - 427 + 106 + -51 - repository_moves + gpg_keys#ffffff id - MEDIUMINT + BIGINT True True - from_repository - MEDIUMINT + fingerprint + VARCHAR(40) True False - to_repository + owner MEDIUMINT True False - - upstream_package_repository - SMALLINT - True - False -
- + - 788 - 281 + 258 + -44 - repository_stabilities + persons#ffffff id - SMALLINT + MEDIUMINT True True @@ -197,38 +137,26 @@ True False - - bugtracker_category - VARCHAR(32) - False - False -
- + - 53 - 501 + 788 + -60 - build_dependency_loops + todo_links#ffffff - id + dependent BIGINT True - True - - - loop - MEDIUMINT - True False - build_assignment + depending_on BIGINT True False @@ -236,49 +164,55 @@
- + - 540 - -64 + 945 + -70 - dependency_types + todos#ffffff id - SMALLINT + BIGINT True True - name - VARCHAR(32) + file + VARCHAR(64) True False - relevant_for_building - BIT + line + MEDIUMINT True False - relevant_for_binary_packages - BIT + description + TEXT True False + + importance + SMALLINT + False + False +
- + - 348 - -60 + 777 + 32 - dependencies + statitstics#ffffff @@ -288,141 +222,111 @@ True - dependent - BIGINT + date + TIMESTAMP True False - depending_on - BIGINT + stable_packages_count + MEDIUMINT True False - dependency_type - SMALLINT + pending_tasks_count + MEDIUMINT True False - -
-
- - - 557 - 30 - - - install_targets - #ffffff - - id - BIGINT - True - True - - - name - VARCHAR(64) + staging_packages_count + MEDIUMINT True False - -
-
- - - 415 - 321 - - - architectures - #ffffff - - id - SMALLINT + testing_packages_count + MEDIUMINT True - True + False - name - VARCHAR(16) + broken_tasks_count + MEDIUMINT True False - -
-
- - - 226 - 473 - - - package_sources - #ffffff - - id - BIGINT + dependency_loops_count + MEDIUMINT True - True + False - pkgbase - VARCHAR(64) + dependency_looped_tasks_count + MEDIUMINT True False - git_revision - VARCHAR(40) + locked_tasks_count + MEDIUMINT True False - mod_git_revision - VARCHAR(40) + blocked_tasks_count + MEDIUMINT True False - upsream_package_repository - SMALLINT + next_tasks_count + MEDIUMINT True False + +
+
+ + + 754 + 399 + + + repository_stability_relations + #ffffff + - uses_upstream - BIT + id + MEDIUMINT True - False + True - uses_modification - BIT + more_stable + MEDIUMINT True False - commit_time - TIMESTAMP + less_stable + MEDIUMINT True False
- + - 539 - 533 + -62 + 370 - upstream_repositories + fail_reasons#ffffff @@ -433,12 +337,18 @@ name + VARCHAR(32) + True + False + + + identifier VARCHAR(64) True False - git_repository + severity SMALLINT True False @@ -446,114 +356,174 @@
- + - 770 - 508 + 53 + 346 - git_repositories + failed_builds#ffffff id - SMALLINT + MEDIUMINT True True - name - VARCHAR(64) + build_slave + MEDIUMINT True False - url - VARCHAR(128) + build_assignment + BIGINT True False - directory - VARCHAR(128) + date + TIMESTAMP True False - head - VARCHAR(40) + reason + SMALLINT + True + False + + + log_file + VARCHAR(512) True False
- + - 549 - 301 + 247 + 291 - repositories + build_assignments#ffffff id - MEDIUMINT + BIGINT True True - name - VARCHAR(64) + package_source + BIGINT True False - stability + architecture SMALLINT True False - is_on_master_mirror + is_blocked + VARCHAR(128) + False + False + + + is_black_listed + VARCHAR(128) + False + False + + + is_broken BIT True False - architecture + priority SMALLINT True False + + return_date + TIMESTAMP + False + False +
- + - 549 - 105 + 185 + 122 - install_target_providers + build_slaves#ffffff id - BIGINT + MEDIUMINT True True - package + name + VARCHAR(32) + True + False + + + ssh_key BIGINT True False - install_target + currently_building + BIGINT + False + False + + + last_connection + TIME + True + False + + + logged_lines BIGINT + False + False + + + last_action + VARCHAR(32) + False + False + + + trials + MEDIUMINT + False + False + + + is_sane + BIT True False @@ -638,181 +608,127 @@
- + - 187 - 130 + 549 + 105 - build_slaves + install_target_providers#ffffff id - MEDIUMINT + BIGINT True True - name - VARCHAR(32) - True - False - - - ssh_key + package BIGINT True False - currently_building + install_target BIGINT - False - False - - - last_connection - TIME True False - - logged_lines - BIGINT - False - False - - - last_action - VARCHAR(32) - False - False - - - trials - MEDIUMINT - False - False -
- + - 247 - 291 + 549 + 301 - build_assignments + repositories#ffffff id - BIGINT + MEDIUMINT True True - package_source - BIGINT + name + VARCHAR(64) True False - architecture + stability SMALLINT True False - is_blocked - VARCHAR(128) - False - False - - - is_black_listed - VARCHAR(128) - False - False - - - is_broken + is_on_master_mirror BIT True False - priority + architecture SMALLINT True False - - return_date - TIMESTAMP - False - False -
- + - 53 - 346 + 770 + 508 - failed_builds + git_repositories#ffffff id - MEDIUMINT + SMALLINT True True - build_slave - MEDIUMINT - True - False - - - build_assignment - BIGINT + name + VARCHAR(64) True False - date - TIMESTAMP + url + VARCHAR(128) True False - reason - SMALLINT + directory + VARCHAR(128) True False - log_file - VARCHAR(512) + head + VARCHAR(40) True False
- + - -62 - 370 + 539 + 533 - fail_reasons + upstream_repositories#ffffff @@ -823,18 +739,12 @@ name - VARCHAR(32) - True - False - - - identifier VARCHAR(64) True False - severity + git_repository SMALLINT True False @@ -842,179 +752,209 @@
- + - 754 - 399 + 226 + 473 - repository_stability_relations + package_sources#ffffff id - MEDIUMINT + BIGINT True True - more_stable - MEDIUMINT + pkgbase + VARCHAR(64) True False - less_stable - MEDIUMINT + git_revision + VARCHAR(40) True False - -
-
- - - 777 - 32 - - - statitstics - #ffffff - - id - BIGINT + mod_git_revision + VARCHAR(40) True - True + False - date - TIMESTAMP + upsream_package_repository + SMALLINT True False - stable_packages_count - MEDIUMINT + uses_upstream + BIT True False - pending_tasks_count - MEDIUMINT + uses_modification + BIT True False - staging_packages_count - MEDIUMINT + commit_time + TIMESTAMP True False + +
+
+ + + 415 + 321 + + + architectures + #ffffff + + + id + SMALLINT + True + True + - testing_packages_count - MEDIUMINT + name + VARCHAR(16) True False + +
+
+ + + 557 + 30 + + + install_targets + #ffffff + - broken_tasks_count - MEDIUMINT + id + BIGINT True - False + True - dependency_loops_count - MEDIUMINT + name + VARCHAR(64) True False + +
+
+ + + 348 + -60 + + + dependencies + #ffffff + - dependency_looped_tasks_count - MEDIUMINT + id + BIGINT True - False + True - locked_tasks_count - MEDIUMINT + dependent + BIGINT True False - blocked_tasks_count - MEDIUMINT + depending_on + BIGINT True False - next_tasks_count - MEDIUMINT + dependency_type + SMALLINT True False
- + - 945 - -70 + 540 + -64 - todos + dependency_types#ffffff id - BIGINT + SMALLINT True True - file - VARCHAR(64) + name + VARCHAR(32) True False - line - MEDIUMINT + relevant_for_building + BIT True False - description - TEXT + relevant_for_binary_packages + BIT True False - - importance - SMALLINT - False - False -
- + - 788 - -60 + 53 + 501 - todo_links + build_dependency_loops#ffffff - dependent + id BIGINT True + True + + + loop + MEDIUMINT + True False - depending_on + build_assignment BIGINT True False @@ -1022,18 +962,18 @@
- + - 258 - -44 + 788 + 281 - persons + repository_stabilities#ffffff id - MEDIUMINT + SMALLINT True True @@ -1043,46 +983,58 @@ True False + + bugtracker_category + VARCHAR(32) + False + False +
- + - 106 - -51 + 494 + 427 - gpg_keys + repository_moves#ffffff id - BIGINT + MEDIUMINT True True - fingerprint - VARCHAR(40) + from_repository + MEDIUMINT True False - owner + to_repository MEDIUMINT True False + + upstream_package_repository + SMALLINT + True + False +
- + - 68 - 49 + -55 + -72 - allowed_email_actions + email_log#ffffff @@ -1092,51 +1044,93 @@ True - gpg_key - BIGINT + date + TIMESTAMP + True + False + + + success + BIT True False action MEDIUMINT - True + False + False + + + count + MEDIUMINT + False + False + + + gpg_key + BIGINT + False + False + + + comment + TEXT + False False
- + - -68 - 71 + 42 + 135 - email_actions + ssh_log#ffffff id - MEDIUMINT + BIGINT True True - name + date + TIMESTAMP + True + False + + + build_slave + MEDIUMINT + False + False + + + action VARCHAR(32) True False + + parameters + TEXT + True + False +
- + - 237 - 40 + 543 + 182 - ssh_keys + binary_packages_in_repositories#ffffff @@ -1146,71 +1140,83 @@ True - owner + package + BIGINT + True + False + + + repository MEDIUMINT True False - fingerprint - TEXT + is_to_be_deleted + BIT + True + False + + + last_moved + TIMESTAMP True False
- + - 647.922 - 273.812 + 549 + 346.906 - 270 - + 180 + - 633.703 - 301 + 509.547 + 345.906 - 90 - + 0 + - OneToMany + OneToOne - Optional - Optional + Mandatory + Mandatory - 2 + 4 0 - + - 543 - 227.906 + 290.109 + 40 - 180 - + 90 + - 511.719 - 173.208 + 293.289 + 5.8125 - 0 - + 270 + @@ -1226,24 +1232,24 @@ - + - 153.531 - 180.906 + 255.727 + 122 - 0 - + 90 + - 187 - 196.906 + 290.109 + 103.812 - 180 - + 270 + @@ -1259,24 +1265,24 @@ - + - 612.133 - 504.812 + -9.85156 + 47.8125 270 - + - 613.727 - 533 + -19.2734 + 71 90 - + @@ -1292,24 +1298,24 @@ - + - 572.755 - 427 + 68 + 80.9062 - 90 - + 180 + - 605.469 - 392.812 + 29.4531 + 95.9062 - 270 - + 0 + @@ -1320,29 +1326,29 @@ Mandatory - 1 + 2 0 - + - 651.51 - 427 + 142.789 + 49 90 - + - 661.938 - 392.812 + 159.109 + 12.8125 270 - + @@ -1353,29 +1359,29 @@ Mandatory - 2 + 1 0 - + - 461.146 - 231.812 + 35.2969 + -12.0938 - 270 - + 0 + - 462.273 - 321 + 106 + -19.0938 - 90 - + 180 + @@ -1386,29 +1392,29 @@ Mandatory - 9 + 5 0 - + - 499.672 - -34.0625 + 212.219 + -19.0938 0 - + - 540 - -25.0938 + 258 + -19.0938 180 - + @@ -1419,29 +1425,29 @@ Mandatory - 3 + 2 0 - + - 718.406 - 346.906 + 915.234 + -43.3958 0 - + - 788 - 312.906 + 945 + -39.3958 180 - + @@ -1452,29 +1458,29 @@ Mandatory - 2 + 0 0 - + - 499.672 - -8.125 + 915.234 + -26.7917 0 - + - 557 - 54.9062 + 945 + -8.79167 180 - + @@ -1485,29 +1491,29 @@ Mandatory - 2 + 1 0 - + - 627.109 - 105 + 816.656 + 399 90 - + - 607.016 - 79.8125 + 840.635 + 344.812 270 - + @@ -1523,24 +1529,24 @@ - + - 423.836 - 17.8125 + 879.312 + 399 - 270 - + 90 + - 435.859 - 56 + 893.271 + 344.812 - 90 - + 270 + @@ -1556,24 +1562,24 @@ - + - 549 - 136.906 + 53 + 398.906 180 - + - 511.719 - 114.604 + 33.4375 + 408.906 0 - + @@ -1584,29 +1590,29 @@ Mandatory - 1 + 4 0 - + - 456.531 - 539.906 + 204.719 + 398.906 0 - + - 539 - 564.906 + 247 + 357.906 180 - + @@ -1617,29 +1623,29 @@ Mandatory - 4 + 2 0 - + - 688.453 - 564.906 + 128.859 + 346 - 0 - + 90 + - 770 - 553.906 + 232.151 + 269.812 - 180 - + 270 + @@ -1650,29 +1656,29 @@ Mandatory - 2 + 1 0 - + - 340.948 - 424.812 + 134.195 + 501 - 270 - + 90 + - 341.266 - 473 + 293.974 + 424.812 - 90 - + 270 + @@ -1683,29 +1689,29 @@ Mandatory - 1 + 2 0 - + - 387.922 - 357.906 + 279.302 + 269.812 - 0 - + 270 + - 415 - 345.906 + 293.974 + 291 - 180 - + 90 + @@ -1716,7 +1722,7 @@ Mandatory - 2 + 3 0 @@ -1754,24 +1760,24 @@ - + - 281.302 - 263.812 + 387.922 + 357.906 - 270 - + 0 + - 293.974 - 291 + 415 + 345.906 - 90 - + 180 + @@ -1782,29 +1788,29 @@ Mandatory - 3 + 2 0 - + - 134.195 - 501 + 340.948 + 424.812 - 90 - + 270 + - 293.974 - 424.812 + 341.266 + 473 - 270 - + 90 + @@ -1815,29 +1821,29 @@ Mandatory - 2 + 1 0 - + - 128.859 - 346 + 688.453 + 564.906 - 90 - + 0 + - 234.151 - 263.812 + 770 + 553.906 - 270 - + 180 + @@ -1848,29 +1854,29 @@ Mandatory - 1 + 2 0 - + - 204.719 - 398.906 + 456.531 + 539.906 0 - + - 247 - 357.906 + 539 + 564.906 180 - + @@ -1881,29 +1887,29 @@ Mandatory - 2 + 4 0 - + - 53 - 398.906 + 549 + 136.906 180 - + - 33.4375 - 408.906 + 511.719 + 114.604 0 - + @@ -1914,29 +1920,29 @@ Mandatory - 4 + 1 0 - + - 816.656 - 399 + 423.836 + 17.8125 - 90 - + 270 + - 840.635 - 344.812 + 435.859 + 56 - 270 - + 90 + @@ -1952,24 +1958,24 @@ - + - 879.312 - 399 + 627.109 + 105 90 - + - 893.271 - 344.812 + 607.016 + 79.8125 270 - + @@ -1985,24 +1991,24 @@ - + - 915.234 - -43.3958 + 499.672 + -8.125 0 - + - 945 - -39.3958 + 557 + 54.9062 180 - + @@ -2013,29 +2019,29 @@ Mandatory - 1 + 2 0 - + - 915.234 - -26.7917 + 718.406 + 346.906 0 - + - 945 - -8.79167 + 788 + 312.906 180 - + @@ -2046,29 +2052,29 @@ Mandatory - 0 + 2 0 - + - 212.219 - -19.0938 + 499.672 + -34.0625 0 - + - 258 - -19.0938 + 540 + -25.0938 180 - + @@ -2079,29 +2085,29 @@ Mandatory - 2 + 3 0 - + - 35.2969 - -12.0938 + 461.146 + 231.812 - 0 - + 270 + - 106 - -19.0938 + 462.273 + 321 - 180 - + 90 + @@ -2112,29 +2118,29 @@ Mandatory - 5 + 9 0 - + - 142.789 - 49 + 572.755 + 427 90 - + - 159.109 - 12.8125 + 605.469 + 392.812 270 - + @@ -2145,29 +2151,29 @@ Mandatory - 1 + 2 0 - + - 68 - 80.9062 + 651.51 + 427 - 180 - + 90 + - 29.4531 - 95.9062 + 661.938 + 392.812 - 0 - + 270 + @@ -2178,29 +2184,29 @@ Mandatory - 2 + 1 0 - + - -9.85156 - 47.8125 + 612.133 + 504.812 270 - + - -19.2734 - 71 + 613.727 + 533 90 - + @@ -2216,24 +2222,24 @@ - + - 257.727 - 130 + 153.531 + 180.906 - 90 - + 0 + - 290.109 - 103.812 + 185 + 195.906 - 270 - + 180 + @@ -2249,24 +2255,24 @@ - + - 290.109 - 40 + 543 + 227.906 - 90 - + 180 + - 293.289 - 5.8125 + 511.719 + 173.208 - 270 - + 0 + @@ -2282,35 +2288,35 @@ - + - 549 - 346.906 + 647.922 + 273.812 - 180 - + 270 + - 509.547 - 345.906 + 633.703 + 301 - 0 - + 90 + - OneToOne + OneToMany - Mandatory - Mandatory + Optional + Optional - 4 + 2 0 diff --git a/misc/database-layout.dump b/misc/database-layout.dump index 1f89e3d..ff882b9 100644 --- a/misc/database-layout.dump +++ b/misc/database-layout.dump @@ -406,6 +406,7 @@ build_slaves CREATE TABLE `build_slaves` ( `last_action` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ssh_key` bigint(20) NOT NULL, `trials` mediumint(9) DEFAULT NULL, + `is_sane` bit(1) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`), KEY `currently_building` (`currently_building`), -- cgit v1.2.3-70-g09d2