From 3e74fde47ed058a59040e68c0ce2b3153563da92 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Sun, 22 Apr 2018 17:05:51 +0200 Subject: `binary_packages`.`last_moved` new --- misc/database-layout.dmf | 1440 +++++++++++++++++++++++----------------------- 1 file changed, 723 insertions(+), 717 deletions(-) (limited to 'misc/database-layout.dmf') diff --git a/misc/database-layout.dmf b/misc/database-layout.dmf index b74c264..faf2eff 100644 --- a/misc/database-layout.dmf +++ b/misc/database-layout.dmf @@ -2,13 +2,13 @@ Relational - + - 237 - 40 + 42 + 135 - ssh_keys + ssh_log#ffffff @@ -18,13 +18,25 @@ True - owner + date + DATETIME + True + False + + + build_slave MEDIUMINT + False + False + + + action + VARCHAR(32) True False - fingerprint + parameters TEXT True False @@ -32,145 +44,199 @@
- + - -68 - 71 + -55 + -72 - email_actions + email_log#ffffff id - MEDIUMINT + BIGINT True True - name - VARCHAR(32) + date + DATETIME True False + + success + BIT + True + False + + + action + MEDIUMINT + False + False + + + count + MEDIUMINT + False + False + + + gpg_key + BIGINT + False + False + + + comment + TEXT + False + False +
- + - 68 - 49 + 481 + 395 - allowed_email_actions + repository_moves#ffffff id - BIGINT + MEDIUMINT True True - gpg_key - BIGINT + from_repository + MEDIUMINT True False - action + to_repository MEDIUMINT True False + + upstream_package_repository + SMALLINT + True + False +
- + - 106 - -51 + 763 + 241 - gpg_keys + repository_stabilities#ffffff id - BIGINT + SMALLINT True True - fingerprint - VARCHAR(40) + name + VARCHAR(32) True False - owner - MEDIUMINT - True + bugtracker_category + VARCHAR(32) + False False
- + - 258 - -44 + 53 + 501 - persons + build_dependency_loops#ffffff id - MEDIUMINT + BIGINT True True - name - VARCHAR(32) + loop + MEDIUMINT + True + False + + + build_assignment + BIGINT True False
- + - 788 - -60 + 540 + -64 - todo_links + dependency_types#ffffff - dependent - BIGINT + id + SMALLINT + True + True + + + name + VARCHAR(32) True False - depending_on - BIGINT + relevant_for_building + BIT + True + False + + + relevant_for_binary_packages + BIT True False
- + - 945 - -70 + 348 + -60 - todos + dependencies#ffffff @@ -180,39 +246,33 @@ True - file - VARCHAR(64) - True - False - - - line - MEDIUMINT + dependent + BIGINT True False - description - TEXT + depending_on + BIGINT True False - importance + dependency_type SMALLINT - False + True False
- + - 737 - 38 + 563 + 42 - statitstics + install_targets#ffffff @@ -222,111 +282,135 @@ True - date - DATETIME + name + VARCHAR(64) True False + +
+
+ + + 415 + 321 + + + architectures + #ffffff + - stable_packages_count - MEDIUMINT + id + SMALLINT True - False + True - pending_tasks_count - MEDIUMINT + name + VARCHAR(16) True False + +
+
+ + + 226 + 473 + + + package_sources + #ffffff + - staging_packages_count - MEDIUMINT + id + BIGINT True - False + True - testing_packages_count - MEDIUMINT + pkgbase + VARCHAR(64) True False - broken_tasks_count - MEDIUMINT + git_revision + VARCHAR(40) True False - dependency_loops_count - MEDIUMINT + mod_git_revision + VARCHAR(40) True False - dependency_looped_tasks_count - MEDIUMINT + upsream_package_repository + SMALLINT True False - locked_tasks_count - MEDIUMINT + uses_upstream + BIT True False - blocked_tasks_count - MEDIUMINT + uses_modification + BIT True False - next_tasks_count - MEDIUMINT + commit_time + DATETIME True False
- + - 754 - 399 + 539 + 533 - repository_stability_relations + upstream_repositories#ffffff id - MEDIUMINT + SMALLINT True True - more_stable - MEDIUMINT + name + VARCHAR(64) True False - less_stable - MEDIUMINT + git_repository + SMALLINT True False
- + - -62 - 370 + 770 + 508 - fail_reasons + git_repositories#ffffff @@ -337,32 +421,38 @@ name - VARCHAR(32) + VARCHAR(64) True False - identifier - VARCHAR(64) + url + VARCHAR(128) True False - severity - SMALLINT + directory + VARCHAR(128) + True + False + + + head + VARCHAR(40) True False
- + - 53 - 346 + 529 + 273 - failed_builds + repositories#ffffff @@ -372,45 +462,63 @@ True - build_slave - MEDIUMINT + name + VARCHAR(64) True False - build_assignment - BIGINT + stability + SMALLINT True False - date - DATETIME + is_on_master_mirror + BIT True False + +
+
+ + + 554 + 117 + + + install_target_providers + #ffffff + - reason - SMALLINT + id + BIGINT + True + True + + + package + BIGINT True False - log_file - VARCHAR(512) + install_target + BIGINT True False
- + - 247 - 291 + 360 + 56 - build_assignments + binary_packages#ffffff @@ -420,47 +528,83 @@ True - package_source + build_assignment BIGINT True False - architecture - SMALLINT + repository + MEDIUMINT True False - is_blocked - VARCHAR(128) - False + epoch + MEDIUMINT + True False - is_black_listed - VARCHAR(128) - False + pkgver + VARCHAR(64) + True False - is_broken + pkgrel + MEDIUMINT + True + False + + + sub_pkgrel + MEDIUMINT + True + False + + + has_issues BIT True False - priority + is_tested + BIT + True + False + + + is_to_be_deleted + BIT + True + False + + + pkgname + VARCHAR(64) + True + False + + + architecture SMALLINT True False - return_date - DATETIME + sha512sum + VARCHAR(128) False False + + last_moved + DATETIME + True + False +
@@ -518,13 +662,13 @@
- + - 360 - 56 + 247 + 291 - binary_packages + build_assignments#ffffff @@ -534,153 +678,105 @@ True - build_assignment + package_source BIGINT True False - repository - MEDIUMINT - True - False - - - epoch - MEDIUMINT - True - False - - - pkgver - VARCHAR(64) - True - False - - - pkgrel - MEDIUMINT - True - False - - - sub_pkgrel - MEDIUMINT - True - False - - - has_issues - BIT + architecture + SMALLINT True False - is_tested - BIT - True + is_blocked + VARCHAR(128) + False False - is_to_be_deleted - BIT - True + is_black_listed + VARCHAR(128) + False False - pkgname - VARCHAR(64) + is_broken + BIT True False - architecture + priority SMALLINT True False - sha512sum - VARCHAR(128) + return_date + DATETIME False False
- + - 554 - 117 + 53 + 346 - install_target_providers + failed_builds#ffffff id - BIGINT + MEDIUMINT True True - package - BIGINT + build_slave + MEDIUMINT True False - install_target + build_assignment BIGINT True False - -
-
- - - 529 - 273 - - - repositories - #ffffff - - - id - MEDIUMINT - True - True - - name - VARCHAR(64) + date + DATETIME True False - stability + reason SMALLINT True False - is_on_master_mirror - BIT + log_file + VARCHAR(512) True False
- + - 770 - 508 + -62 + 370 - git_repositories + fail_reasons#ffffff @@ -691,68 +787,62 @@ name - VARCHAR(64) - True - False - - - url - VARCHAR(128) + VARCHAR(32) True False - directory - VARCHAR(128) + identifier + VARCHAR(64) True False - head - VARCHAR(40) + severity + SMALLINT True False
- + - 539 - 533 + 754 + 399 - upstream_repositories + repository_stability_relations#ffffff id - SMALLINT + MEDIUMINT True True - name - VARCHAR(64) + more_stable + MEDIUMINT True False - git_repository - SMALLINT + less_stable + MEDIUMINT True False
- + - 226 - 473 + 737 + 38 - package_sources + statitstics#ffffff @@ -762,105 +852,81 @@ True - pkgbase - VARCHAR(64) + date + DATETIME True False - git_revision - VARCHAR(40) + stable_packages_count + MEDIUMINT True False - mod_git_revision - VARCHAR(40) + pending_tasks_count + MEDIUMINT True False - upsream_package_repository - SMALLINT + staging_packages_count + MEDIUMINT True False - uses_upstream - BIT + testing_packages_count + MEDIUMINT True False - uses_modification - BIT + broken_tasks_count + MEDIUMINT True False - commit_time - DATETIME + dependency_loops_count + MEDIUMINT True False - -
-
- - - 415 - 321 - - - architectures - #ffffff - - id - SMALLINT + dependency_looped_tasks_count + MEDIUMINT True - True + False - name - VARCHAR(16) + locked_tasks_count + MEDIUMINT True False - -
-
- - - 563 - 42 - - - install_targets - #ffffff - - id - BIGINT + blocked_tasks_count + MEDIUMINT True - True + False - name - VARCHAR(64) + next_tasks_count + MEDIUMINT True False
- + - 348 - -60 + 945 + -70 - dependencies + todos#ffffff @@ -870,85 +936,49 @@ True - dependent - BIGINT + file + VARCHAR(64) True False - depending_on - BIGINT + line + MEDIUMINT True False - dependency_type - SMALLINT + description + TEXT True False - -
-
- - - 540 - -64 - - - dependency_types - #ffffff - - id + importance SMALLINT - True - True - - - name - VARCHAR(32) - True - False - - - relevant_for_building - BIT - True - False - - - relevant_for_binary_packages - BIT - True + 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 @@ -956,18 +986,18 @@
- - - 763 - 241 + + + 258 + -44 - repository_stabilities + persons#ffffff id - SMALLINT + MEDIUMINT True True @@ -977,58 +1007,46 @@ True False - - bugtracker_category - VARCHAR(32) - False - 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 -
- + - -55 - -72 + 68 + 49 - email_log + allowed_email_actions#ffffff @@ -1038,51 +1056,51 @@ True - date - DATETIME - True - False - - - success - BIT + gpg_key + BIGINT True False action MEDIUMINT - False + True False + +
+
+ + + -68 + 71 + + + email_actions + #ffffff + - count + id MEDIUMINT - False - False - - - gpg_key - BIGINT - False - False + True + True - comment - TEXT - False + name + VARCHAR(32) + True False
- + - 42 - 135 + 237 + 40 - ssh_log + ssh_keys#ffffff @@ -1092,25 +1110,13 @@ True - date - DATETIME - True - False - - - build_slave + owner MEDIUMINT - False - False - - - action - VARCHAR(32) True False - parameters + fingerprint TEXT True False @@ -1118,24 +1124,24 @@
- + - 290.109 - 40 + 148.781 + 186.812 - 90 - + 0 + - 293.289 - 5.8125 + 186 + 204.812 - 270 - + 180 + @@ -1146,29 +1152,29 @@ Mandatory - 1 + 2 0 - + - 256.727 - 137 + 596.758 + 482.625 - 90 - + 270 + - 290.109 - 103.812 + 600.391 + 533 - 270 - + 90 + @@ -1179,29 +1185,29 @@ Mandatory - 2 + 3 0 - + - -9.85156 - 47.8125 + 558.172 + 395 - 270 - + 90 + - -19.2734 - 71 + 583.885 + 360.625 - 90 - + 270 + @@ -1212,29 +1218,29 @@ Mandatory - 3 + 1 0 - + - 68 - 80.9062 + 635.344 + 395 - 180 - + 90 + - 29.4531 - 95.9062 + 638.771 + 360.625 - 0 - + 270 + @@ -1250,24 +1256,24 @@ - + - 142.789 - 49 + 433.484 + 303.625 - 90 - + 270 + - 159.109 - 12.8125 + 447.914 + 321 - 270 - + 90 + @@ -1278,29 +1284,29 @@ Mandatory - 1 + 11 0 - + - 35.2969 - -12.0938 + 494.922 + -30.7917 0 - + - 106 - -19.0938 + 540 + -20.1875 180 - + @@ -1311,29 +1317,29 @@ Mandatory - 5 + 3 0 - + - 212.219 - -19.0938 + 693.656 + 316.812 0 - + - 258 - -19.0938 + 763 + 276.812 180 - + @@ -1349,24 +1355,24 @@ - + - 915.234 - -43.3958 + 494.922 + -1.58333 0 - + - 945 - -39.3958 + 563 + 69.8125 180 - + @@ -1377,29 +1383,29 @@ Mandatory - 0 + 2 0 - + - 915.234 - -26.7917 + 613.289 + 117 - 0 - + 90 + - 945 - -8.79167 + 599.156 + 97.625 - 180 - + 270 + @@ -1410,29 +1416,29 @@ Mandatory - 1 + 2 0 - + - 816.656 - 399 + 421.461 + 27.625 - 90 - + 270 + - 815.635 - 304.812 + 433.484 + 56 - 270 - + 90 + @@ -1443,29 +1449,29 @@ Mandatory - 2 + 1 0 - + - 879.312 - 399 + 554 + 152.812 - 90 - + 180 + - 868.271 - 304.812 + 506.969 + 138.542 - 270 - + 0 + @@ -1481,24 +1487,24 @@ - + - 53 - 398.906 + 451.781 + 548.812 - 180 - + 0 + - 33.4375 - 408.906 + 539 + 568.812 - 0 - + 180 + @@ -1514,24 +1520,24 @@ - + - 204.719 - 398.906 + 506.969 + 221.083 0 - + - 247 - 357.906 + 611.328 + 273 - 180 - + 90 + @@ -1547,24 +1553,24 @@ - + - 128.859 - 346 + 661.781 + 568.812 - 90 - + 0 + - 233.151 - 256.812 + 770 + 559.812 - 270 - + 180 + @@ -1575,29 +1581,29 @@ Mandatory - 1 + 2 0 - + - 134.195 - 501 + 315.086 + 442.625 - 90 - + 270 + - 293.974 - 424.812 + 338.891 + 473 - 270 - + 90 + @@ -1608,29 +1614,29 @@ Mandatory - 2 + 1 0 - + - 280.302 - 256.812 + 383.172 + 366.812 - 270 - + 0 + - 293.974 - 291 + 415 + 348.812 - 90 - + 180 + @@ -1641,7 +1647,7 @@ Mandatory - 3 + 2 0 @@ -1651,15 +1657,15 @@ - 410.573 - 259.812 + 360 + 179.812 - 270 + 180 - 340.948 + 337.781 291 90 @@ -1679,24 +1685,24 @@ - + - 387.922 - 357.906 + 275.271 + 272.625 - 0 - + 270 + - 415 - 345.906 + 292.391 + 291 - 180 - + 90 + @@ -1707,29 +1713,29 @@ Mandatory - 2 + 3 0 - + - 340.948 - 424.812 + 126.484 + 501 - 270 - + 90 + - 341.266 - 473 + 247 + 392.083 - 90 - + 180 + @@ -1740,29 +1746,29 @@ Mandatory - 1 + 2 0 - + - 688.453 - 564.906 + 126.484 + 346 - 0 - + 90 + - 770 - 553.906 + 230.635 + 272.625 - 180 - + 270 + @@ -1773,29 +1779,29 @@ Mandatory - 2 + 1 0 - + - 511.719 - 191.875 + 199.969 + 405.812 0 - + - 613.703 - 273 + 247 + 341.542 - 90 - + 180 + @@ -1811,24 +1817,24 @@ - + - 456.531 - 539.906 + 53 + 405.812 - 0 - + 180 + - 539 - 564.906 + 28.6875 + 413.812 - 180 - + 0 + @@ -1844,24 +1850,24 @@ - + - 554 - 148.906 + 799.115 + 399 - 180 - + 90 + - 511.719 - 123.938 + 801.13 + 312.625 - 0 - + 270 + @@ -1877,24 +1883,24 @@ - + - 423.836 - 17.8125 + 844.229 + 399 - 270 - + 90 + - 435.859 - 56 + 839.26 + 312.625 - 90 - + 270 + @@ -1905,29 +1911,29 @@ Mandatory - 1 + 2 0 - + - 632.109 - 117 + 910.484 + -41.4583 - 90 - + 0 + - 613.016 - 91.8125 + 945 + -35.4583 - 270 - + 180 + @@ -1938,29 +1944,29 @@ Mandatory - 2 + 1 0 - + - 499.672 - -8.125 + 910.484 + -22.9167 0 - + - 563 - 66.9062 + 945 + -0.916667 180 - + @@ -1971,29 +1977,29 @@ Mandatory - 2 + 0 0 - + - 698.406 - 311.906 + 207.469 + -15.1875 0 - + - 763 - 272.906 + 258 + -16.1875 180 - + @@ -2009,24 +2015,24 @@ - + - 499.672 - -34.0625 + 25.875 + -4.1875 0 - + - 540 - -25.0938 + 106 + -15.1875 180 - + @@ -2037,29 +2043,29 @@ Mandatory - 3 + 5 0 - + - 461.146 - 259.812 + 121.914 + 49 - 270 - + 90 + - 462.273 - 321 + 156.734 + 20.625 - 90 - + 270 + @@ -2070,29 +2076,29 @@ Mandatory - 11 + 1 0 - + - 559.755 - 395 + 68 + 84.8125 - 90 - + 180 + - 585.469 - 350.812 + 0.75 + 98.8125 - 270 - + 0 + @@ -2108,24 +2114,24 @@ - + - 638.51 - 395 + -14.5625 + 63.625 - 90 - + 270 + - 641.938 - 350.812 + -33.625 + 71 - 270 - + 90 + @@ -2136,29 +2142,29 @@ Mandatory - 1 + 3 0 - + - 599.133 - 472.812 + 252.953 + 137 - 270 - + 90 + - 613.727 - 533 + 287.734 + 111.625 - 90 - + 270 + @@ -2169,29 +2175,29 @@ Mandatory - 3 + 2 0 - + - 153.531 - 180.906 + 287.734 + 40 - 0 - + 90 + - 186 - 196.906 + 290.914 + 11.625 - 180 - + 270 + @@ -2202,7 +2208,7 @@ Mandatory - 2 + 1 0 -- cgit v1.2.3