From 0bc88d347f7d5f3b4fc51e277c3e0489d34dfe04 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Thu, 3 May 2018 15:50:48 +0200 Subject: remove `binary_packages`.`repository` from the graph (but the column is still there for now --- misc/database-layout.dmf | 1450 +++++++++++++++++++++++----------------------- 1 file changed, 722 insertions(+), 728 deletions(-) (limited to 'misc') diff --git a/misc/database-layout.dmf b/misc/database-layout.dmf index 1e3a23a..f53237b 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,69 +18,51 @@ True - package - BIGINT + owner + MEDIUMINT True False - repository - MEDIUMINT + fingerprint + TEXT True False
- + - 42 - 135 + -68 + 71 - ssh_log + email_actions#ffffff id - BIGINT + MEDIUMINT True True - date - DATETIME - 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 @@ -90,92 +72,62 @@ True - date - DATETIME - 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
- + - 481 - 395 + 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 -
- + - 763 - 241 + 258 + -44 - repository_stabilities + persons#ffffff id - SMALLINT + MEDIUMINT True True @@ -185,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 @@ -224,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 @@ -276,141 +222,111 @@ True - dependent - BIGINT + date + DATETIME 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 - DATETIME + less_stable + MEDIUMINT True False
- + - 539 - 533 + -62 + 370 - upstream_repositories + fail_reasons#ffffff @@ -421,12 +337,18 @@ name + VARCHAR(32) + True + False + + + identifier VARCHAR(64) True False - git_repository + severity SMALLINT True False @@ -434,117 +356,165 @@
- + - 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 + DATETIME True False - head - VARCHAR(40) + reason + SMALLINT + True + False + + + log_file + VARCHAR(512) True False
- + - 529 - 273 + 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 + DATETIME + False + False +
- + - 549 - 105 + 186 + 137 - 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 +
@@ -569,12 +539,6 @@ True False - - repository - MEDIUMINT - True - False - epoch MEDIUMINT @@ -644,175 +608,127 @@
- + - 186 - 137 + 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 -
- + - 247 - 291 + 529 + 273 - 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 - DATETIME - 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 - DATETIME + 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 - DATETIME + 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 + DATETIME 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 + 763 + 241 - persons + repository_stabilities#ffffff id - MEDIUMINT + SMALLINT True True @@ -1043,46 +983,58 @@ True False + + bugtracker_category + VARCHAR(32) + False + False +
- + - 106 - -51 + 481 + 395 - 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 + DATETIME + 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 + DATETIME + 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,71 @@ True - owner - MEDIUMINT + package + BIGINT True False - fingerprint - TEXT + repository + MEDIUMINT True False
- + - 647.922 - 245.812 + 529 + 318.906 - 270 - + 180 + - 613.703 - 273 + 509.547 + 345.906 - 90 - + 0 + - OneToMany + OneToOne - Optional - Optional + Mandatory + Mandatory - 2 + 4 0 - + - 543 - 213.906 + 290.109 + 40 - 180 - + 90 + - 511.719 - 201.208 + 293.289 + 5.8125 - 0 - + 270 + @@ -1226,24 +1220,24 @@ - + - 153.531 - 180.906 + 256.727 + 137 - 0 - + 90 + - 186 - 196.906 + 290.109 + 103.812 - 180 - + 270 + @@ -1259,24 +1253,24 @@ - + - 599.133 - 472.812 + -9.85156 + 47.8125 270 - + - 613.727 - 533 + -19.2734 + 71 90 - + @@ -1292,24 +1286,24 @@ - + - 559.755 - 395 + 68 + 80.9062 - 90 - + 180 + - 585.469 - 364.812 + 29.4531 + 95.9062 - 270 - + 0 + @@ -1320,29 +1314,29 @@ Mandatory - 1 + 2 0 - + - 638.51 - 395 + 142.789 + 49 90 - + - 641.938 - 364.812 + 159.109 + 12.8125 270 - + @@ -1353,29 +1347,29 @@ Mandatory - 2 + 1 0 - + - 461.146 - 273.812 + 35.2969 + -12.0938 - 270 - + 0 + - 462.273 - 321 + 106 + -19.0938 - 90 - + 180 + @@ -1386,29 +1380,29 @@ Mandatory - 11 + 5 0 - + - 499.672 - -34.0625 + 212.219 + -19.0938 0 - + - 540 - -25.0938 + 258 + -19.0938 180 - + @@ -1419,29 +1413,29 @@ Mandatory - 3 + 2 0 - + - 698.406 - 318.906 + 915.234 + -43.3958 0 - + - 763 - 272.906 + 945 + -39.3958 180 - + @@ -1452,29 +1446,29 @@ Mandatory - 2 + 0 0 - + - 499.672 - -8.125 + 915.234 + -26.7917 0 - + - 557 - 54.9062 + 945 + -8.79167 180 - + @@ -1485,29 +1479,29 @@ Mandatory - 2 + 1 0 - + - 627.109 - 105 + 816.656 + 399 90 - + - 607.016 - 79.8125 + 815.635 + 304.812 270 - + @@ -1523,24 +1517,24 @@ - + - 423.836 - 17.8125 + 879.312 + 399 - 270 - + 90 + - 435.859 - 56 + 868.271 + 304.812 - 90 - + 270 + @@ -1556,24 +1550,24 @@ - + - 549 - 136.906 + 53 + 398.906 180 - + - 511.719 - 128.604 + 33.4375 + 408.906 0 - + @@ -1584,29 +1578,29 @@ Mandatory - 1 + 4 0 - + - 456.531 - 539.906 + 204.719 + 398.906 0 - + - 539 - 564.906 + 247 + 357.906 180 - + @@ -1617,29 +1611,29 @@ Mandatory - 4 + 2 0 - + - 688.453 - 564.906 + 128.859 + 346 - 0 - + 90 + - 770 - 553.906 + 233.151 + 256.812 - 180 - + 270 + @@ -1650,29 +1644,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 +1677,29 @@ Mandatory - 1 + 2 0 - + - 387.922 - 357.906 + 280.302 + 256.812 - 0 - + 270 + - 415 - 345.906 + 293.974 + 291 - 180 - + 90 + @@ -1716,7 +1710,7 @@ Mandatory - 2 + 3 0 @@ -1727,7 +1721,7 @@ 410.573 - 273.812 + 259.812 270 @@ -1754,24 +1748,24 @@ - + - 280.302 - 256.812 + 387.922 + 357.906 - 270 - + 0 + - 293.974 - 291 + 415 + 345.906 - 90 - + 180 + @@ -1782,29 +1776,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 +1809,29 @@ Mandatory - 2 + 1 0 - + - 128.859 - 346 + 688.453 + 564.906 - 90 - + 0 + - 233.151 - 256.812 + 770 + 553.906 - 270 - + 180 + @@ -1848,29 +1842,29 @@ Mandatory - 1 + 2 0 - + - 204.719 - 398.906 + 456.531 + 539.906 0 - + - 247 - 357.906 + 539 + 564.906 180 - + @@ -1881,29 +1875,29 @@ Mandatory - 2 + 4 0 - + - 53 - 398.906 + 549 + 136.906 180 - + - 33.4375 - 408.906 + 511.719 + 123.938 0 - + @@ -1914,29 +1908,29 @@ Mandatory - 4 + 1 0 - + - 816.656 - 399 + 423.836 + 17.8125 - 90 - + 270 + - 815.635 - 304.812 + 435.859 + 56 - 270 - + 90 + @@ -1952,24 +1946,24 @@ - + - 879.312 - 399 + 627.109 + 105 90 - + - 868.271 - 304.812 + 607.016 + 79.8125 270 - + @@ -1985,24 +1979,24 @@ - + - 915.234 - -43.3958 + 499.672 + -8.125 0 - + - 945 - -39.3958 + 557 + 54.9062 180 - + @@ -2013,29 +2007,29 @@ Mandatory - 1 + 2 0 - + - 915.234 - -26.7917 + 698.406 + 318.906 0 - + - 945 - -8.79167 + 763 + 272.906 180 - + @@ -2046,29 +2040,29 @@ Mandatory - 0 + 2 0 - + - 212.219 - -19.0938 + 499.672 + -34.0625 0 - + - 258 - -19.0938 + 540 + -25.0938 180 - + @@ -2079,29 +2073,29 @@ Mandatory - 2 + 3 0 - + - 35.2969 - -12.0938 + 461.146 + 259.812 - 0 - + 270 + - 106 - -19.0938 + 462.273 + 321 - 180 - + 90 + @@ -2112,29 +2106,29 @@ Mandatory - 5 + 10 0 - + - 142.789 - 49 + 638.51 + 395 90 - + - 159.109 - 12.8125 + 641.938 + 364.812 270 - + @@ -2145,29 +2139,29 @@ Mandatory - 1 + 2 0 - + - 68 - 80.9062 + 559.755 + 395 - 180 - + 90 + - 29.4531 - 95.9062 + 585.469 + 364.812 - 0 - + 270 + @@ -2178,29 +2172,29 @@ Mandatory - 2 + 1 0 - + - -9.85156 - 47.8125 + 599.133 + 472.812 270 - + - -19.2734 - 71 + 613.727 + 533 90 - + @@ -2216,24 +2210,24 @@ - + - 256.727 - 137 + 153.531 + 180.906 - 90 - + 0 + - 290.109 - 103.812 + 186 + 196.906 - 270 - + 180 + @@ -2249,24 +2243,24 @@ - + - 290.109 - 40 + 543 + 213.906 - 90 - + 180 + - 293.289 - 5.8125 + 511.719 + 191.875 - 270 - + 0 + @@ -2282,35 +2276,35 @@ - + - 529 - 318.906 + 647.922 + 245.812 - 180 - + 270 + - 509.547 - 345.906 + 613.703 + 273 - 0 - + 90 + - OneToOne + OneToMany - Mandatory - Mandatory + Optional + Optional - 4 + 2 0 -- cgit v1.2.3-70-g09d2