From 462730feca527e84867030cb44a28253fd3ca683 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Fri, 27 Jul 2018 12:17:28 +0200 Subject: misc/database-layout.dmf: `versions` table new --- misc/database-layout.dmf | 1718 +++++++++++++++++++++++++--------------------- 1 file changed, 919 insertions(+), 799 deletions(-) (limited to 'misc') diff --git a/misc/database-layout.dmf b/misc/database-layout.dmf index 9277d32..9f6b9aa 100644 --- a/misc/database-layout.dmf +++ b/misc/database-layout.dmf @@ -2,13 +2,13 @@ Relational - + - 952 - 253 + 483 + 57 - mirror_statuses + versions#ffffff @@ -18,117 +18,123 @@ True - protocol - VARCHAR(8) - True - False - - - url - VARCHAR(128) + order + BIGINT True False - country - VARCHAR(64) + epoch + MEDIUMINT True False - country_code - VARCHAR(4) + version + VARCHAR(32) True False + +
+
+ + + 398 + -74 + + + dependencies + #ffffff + - last_sync + id BIGINT True - False - - - start - FLOAT - True - False + True - stop - FLOAT + dependent + BIGINT True False - isos - BIT + depending_on + BIGINT True False - ipv4 - BIT + dependency_type + SMALLINT True False - ipv6 - BIT + version + BIGINT True False - active - BIT + version_condition + CHAR(1) True False
- + - 375 - 369 + 546 + 188 - architecture_compatibilities + binary_packages_in_repositories#ffffff id - MEDIUMINT + BIGINT True True - built_for - SMALLINT + package + BIGINT True False - runs_on - SMALLINT + repository + MEDIUMINT True False - fully_compatible + is_to_be_deleted BIT True False + + last_moved + TIMESTAMP + True + False +
- + - 237 - 40 + -52 + 134 - ssh_keys + ssh_log#ffffff @@ -138,13 +144,25 @@ True - owner + date + TIMESTAMP + True + False + + + build_slave MEDIUMINT + False + False + + + action + VARCHAR(32) True False - fingerprint + parameters TEXT True False @@ -152,102 +170,108 @@
- + - -59 - 73 + -55 + -72 - email_actions + email_log#ffffff id - MEDIUMINT + BIGINT True True - name - VARCHAR(32) + date + TIMESTAMP True False - -
-
- - - 68 - 49 - - - allowed_email_actions - #ffffff - - id - BIGINT + success + BIT True - True + False + + + action + MEDIUMINT + False + False + + + count + MEDIUMINT + False + False gpg_key BIGINT - True + False False - action - MEDIUMINT - True + comment + TEXT + False False
- + - 106 - -51 + 488 + 475 - 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 +
- + - 258 - -44 + 770 + 345 - persons + repository_stabilities#ffffff id - MEDIUMINT + SMALLINT True True @@ -257,26 +281,38 @@ True False + + bugtracker_category + VARCHAR(32) + False + False +
- + - 788 - -60 + 282 + 497 - todo_links + build_dependency_loops#ffffff - dependent + id BIGINT True + True + + + loop + MEDIUMINT + True False - depending_on + build_assignment BIGINT True False @@ -284,55 +320,49 @@
- + - 945 + 637 -70 - 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 -
- + - 777 - 32 + 653 + 21 - statitstics + install_targets#ffffff @@ -342,111 +372,135 @@ True - date - TIMESTAMP - True - False - - - stable_packages_count - MEDIUMINT + name + VARCHAR(64) True False + +
+
+ + + 395 + 313 + + + architectures + #ffffff + - pending_tasks_count - MEDIUMINT + id + SMALLINT True - False + True - staging_packages_count - MEDIUMINT + name + VARCHAR(16) True False + +
+
+ + + 21 + 510 + + + package_sources + #ffffff + - testing_packages_count - MEDIUMINT + id + BIGINT + True + True + + + 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 + TIMESTAMP True False
- + - 756 - 452 + 528 + 571 - 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
- + - -53 - 240 + 811 + 553 - fail_reasons + git_repositories#ffffff @@ -457,32 +511,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
- + - -17 - 342 + 566 + 299 - failed_builds + repositories#ffffff @@ -492,51 +552,75 @@ True - build_slave - MEDIUMINT + name + VARCHAR(64) True False - build_assignment - BIGINT + stability + SMALLINT True False - date - TIMESTAMP + is_on_master_mirror + BIT True False - reason + architecture SMALLINT True False + +
+
+ + + 618 + 100 + + + install_target_providers + #ffffff + + + id + BIGINT + True + True + - log_file - VARCHAR(512) + package + BIGINT True False - log_file_exists - BIT + install_target + BIGINT + True + False + + + version + BIGINT True False
- + - 187 - 311 + 299 + 99 - build_assignments + binary_packages#ffffff @@ -546,54 +630,78 @@ True - package_source + build_assignment BIGINT True False - architecture - SMALLINT + epoch + MEDIUMINT True False - is_blocked - VARCHAR(128) - False + pkgver + VARCHAR(64) + True False - is_black_listed - VARCHAR(128) - False + pkgrel + MEDIUMINT + True False - is_broken + sub_pkgrel + MEDIUMINT + True + False + + + has_issues BIT True False - priority + is_tested + BIT + True + False + + + pkgname + VARCHAR(64) + True + False + + + architecture SMALLINT True False - return_date - TIMESTAMP + sha512sum + VARCHAR(128) False False + + sub_pkgrel_omitted + BIT + True + False +
- 185 - 122 + 118 + 148 build_slaves @@ -656,13 +764,13 @@
- + - 360 - 56 + 196 + 326 - binary_packages + build_assignments#ffffff @@ -672,153 +780,111 @@ True - build_assignment + package_source BIGINT True False - epoch - MEDIUMINT - True - False - - - pkgver - VARCHAR(64) - True - False - - - pkgrel - MEDIUMINT + architecture + SMALLINT True False - sub_pkgrel - MEDIUMINT - True + is_blocked + VARCHAR(128) + False False - has_issues - BIT - True + is_black_listed + VARCHAR(128) + False False - is_tested + is_broken BIT True False - pkgname - VARCHAR(64) - True - False - - - architecture + priority SMALLINT True False - sha512sum - VARCHAR(128) + return_date + TIMESTAMP False False - - sub_pkgrel_omitted - BIT - True - False -
- + - 549 - 105 + -17 + 342 - 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 - -
-
- - - 566 - 299 - - - repositories - #ffffff - - - id - MEDIUMINT - True - True - - name - VARCHAR(64) + date + TIMESTAMP True False - stability + reason SMALLINT True False - is_on_master_mirror - BIT + log_file + VARCHAR(512) True False - architecture - SMALLINT + log_file_exists + BIT True False
- + - 803 - 533 + -53 + 240 - git_repositories + fail_reasons#ffffff @@ -829,68 +895,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
- + - 535 - 562 + 756 + 452 - 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
- + - 175 - 497 + 820 + 145 - package_sources + statitstics#ffffff @@ -900,81 +960,81 @@ True - pkgbase - VARCHAR(64) + date + TIMESTAMP 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 - TIMESTAMP + dependency_loops_count + MEDIUMINT True False - -
-
- - - 399 - 289 - - - architectures - #ffffff - - id - SMALLINT + dependency_looped_tasks_count + MEDIUMINT True - True + False - name - VARCHAR(16) + locked_tasks_count + MEDIUMINT + True + False + + + blocked_tasks_count + MEDIUMINT + True + False + + + next_tasks_count + MEDIUMINT True False
- + - 557 - 30 + 945 + -70 - install_targets + todos#ffffff @@ -984,29 +1044,41 @@ True - name + file VARCHAR(64) True False + + line + MEDIUMINT + True + False + + + description + TEXT + True + False + + + importance + SMALLINT + False + False +
- + - 348 - -60 + 940 + 71 - dependencies + todo_links#ffffff - - id - BIGINT - True - True - dependent BIGINT @@ -1019,27 +1091,21 @@ True False - - dependency_type - SMALLINT - True - False -
- + - 540 - -64 + 240 + -66 - dependency_types + persons#ffffff id - SMALLINT + MEDIUMINT True True @@ -1049,28 +1115,46 @@ True False + +
+
+ + + 106 + -51 + + + gpg_keys + #ffffff + + + id + BIGINT + True + True + - relevant_for_building - BIT + fingerprint + VARCHAR(40) True False - relevant_for_binary_packages - BIT + owner + MEDIUMINT True False
- + - -21 - 537 + 68 + 42 - build_dependency_loops + allowed_email_actions#ffffff @@ -1080,32 +1164,32 @@ True - loop - MEDIUMINT + gpg_key + BIGINT True False - build_assignment - BIGINT + action + MEDIUMINT True False
- + - 770 - 345 + -54 + 70 - repository_stabilities + email_actions#ffffff id - SMALLINT + MEDIUMINT True True @@ -1115,112 +1199,82 @@ True False - - bugtracker_category - VARCHAR(32) - False - False -
- + - 492 - 459 + 229 + 20 - repository_moves + ssh_keys#ffffff id - MEDIUMINT + BIGINT True True - from_repository - MEDIUMINT - True - False - - - to_repository + owner MEDIUMINT True False - upstream_package_repository - SMALLINT + fingerprint + TEXT True False
- + - -55 - -72 + 373 + 388 - email_log + architecture_compatibilities#ffffff id - BIGINT + MEDIUMINT True True - date - TIMESTAMP + built_for + SMALLINT True False - success - BIT + runs_on + SMALLINT True False - action - MEDIUMINT - False - False - - - count - MEDIUMINT - False - False - - - gpg_key - BIGINT - False - False - - - comment - TEXT - False + fully_compatible + BIT + True False
- + - -52 - 134 + 956 + 420 - ssh_log + mirror_statuses#ffffff @@ -1230,92 +1284,125 @@ True - date - TIMESTAMP + protocol + VARCHAR(8) True False - build_slave - MEDIUMINT - False + url + VARCHAR(128) + True False - action - VARCHAR(32) + country + VARCHAR(64) True False - parameters - TEXT + country_code + VARCHAR(4) True False - -
-
- - - 543 - 182 - - - binary_packages_in_repositories - #ffffff - - id + last_sync BIGINT True - True + False - package - BIGINT + start + FLOAT True False - repository - MEDIUMINT + stop + FLOAT True False - is_to_be_deleted + isos BIT True False - last_moved - TIMESTAMP + ipv4 + BIT + True + False + + + ipv6 + BIT + True + False + + + active + BIT True False
- + + + + + + 499.573 + 31.8125 + + 270 + + + + + 524.594 + 57 + + 90 + + + + + + OneToOne + + Mandatory + Mandatory + + + 4 + 0 + + + + - 435.714 - 369 + 618 + 125.938 - 90 - + 180 + - 430.516 - 338.812 + 566.188 + 95.9062 - 270 - + 0 + @@ -1326,29 +1413,29 @@ Mandatory - 1 + 3 0 - + - 496.427 - 369 + 550.359 + -38.7292 - 90 - + 0 + - 462.031 - 338.812 + 637 + -31.0938 - 270 - + 180 + @@ -1359,29 +1446,29 @@ Mandatory - 2 + 3 0 - + - 566 - 344.906 + 550.359 + -3.45833 - 180 - + 0 + - 493.547 - 313.906 + 653 + 45.9062 - 0 - + 180 + @@ -1392,62 +1479,62 @@ Mandatory - 4 + 2 0 - + - 290.109 - 40 + 650.922 + 279.812 - 90 - + 270 + - 293.289 - 5.8125 + 650.703 + 299 - 270 - + 90 + - OneToOne + OneToMany - Mandatory - Mandatory + Optional + Optional - 1 + 2 0 - + - 255.727 - 122 + 448.786 + 31.8125 - 90 - + 270 + - 290.109 - 103.812 + 381.93 + 99 - 270 - + 90 + @@ -1458,29 +1545,29 @@ Mandatory - 2 + 1 0 - + - -9.85156 - 47.8125 + 546 + 233.906 - 270 - + 180 + - -10.2734 - 73 + 464.859 + 225.542 - 90 - + 0 + @@ -1491,29 +1578,29 @@ Mandatory - 3 + 1 0 - + - 68 - 80.9062 + 59.5312 + 179.906 - 180 - + 0 + - 38.4531 - 97.9062 + 118 + 221.906 - 0 - + 180 + @@ -1529,24 +1616,24 @@ - + - 142.789 - 49 + 606.133 + 552.812 - 90 - + 270 + - 159.109 - 12.8125 + 602.727 + 571 - 270 - + 90 + @@ -1557,29 +1644,29 @@ Mandatory - 1 + 3 0 - + - 35.2969 - -12.0938 + 645.51 + 475 - 0 - + 90 + - 106 - -19.0938 + 678.938 + 390.812 - 180 - + 270 + @@ -1590,29 +1677,29 @@ Mandatory - 5 + 1 0 - + - 212.219 - -19.0938 + 566.755 + 475 - 0 - + 90 + - 258 - -19.0938 + 622.469 + 390.812 - 180 - + 270 + @@ -1628,24 +1715,24 @@ - + - 915.234 - -43.3958 + 409.573 + 288.812 - 0 - + 270 + - 945 - -39.3958 + 442.273 + 313 - 180 - + 90 + @@ -1656,29 +1743,29 @@ Mandatory - 0 + 9 0 - + - 915.234 - -26.7917 + 735.406 + 344.906 0 - + - 945 - -8.79167 + 770 + 376.906 180 - + @@ -1689,29 +1776,29 @@ Mandatory - 1 + 2 0 - + - 818.656 - 452 + 696.109 + 100 90 - + - 822.635 - 408.812 + 703.016 + 70.8125 270 - + @@ -1727,24 +1814,24 @@ - + - 881.312 - 452 + 618 + 151.875 - 90 - + 180 + - 875.271 - 408.812 + 464.859 + 162.271 - 270 - + 0 + @@ -1760,24 +1847,24 @@ - + - 33.5729 - 342 + 251.531 + 576.906 - 90 - + 0 + - -5.28125 - 317.812 + 528 + 602.906 - 270 - + 180 + @@ -1793,24 +1880,24 @@ - + - 134.719 - 401.906 + 677.453 + 602.906 0 - + - 187 - 377.906 + 811 + 598.906 180 - + @@ -1826,24 +1913,57 @@ - + - 84.1458 - 342 + 242.974 + 459.812 + + 270 + + + + + 136.266 + 510 90 - + + + + + + OneToOne + + Mandatory + Mandatory + + + 1 + 0 + + + + + + + + + 336.922 + 392.906 + + 0 + - 232.151 - 269.812 + 395 + 337.906 - 270 - + 180 + @@ -1854,28 +1974,28 @@ Mandatory - 1 + 2 0 - + - 60.1953 - 537 + 354.286 + 288.812 - 90 - + 270 + - 233.974 - 444.812 + 289.948 + 326 - 270 + 90 @@ -1887,7 +2007,7 @@ Mandatory - 2 + 1 0 @@ -1897,16 +2017,16 @@ - 279.302 - 269.812 + 212.302 + 295.812 270 - 233.974 - 311 + 242.974 + 326 90 @@ -1925,23 +2045,23 @@ - + - 415.286 - 245.812 + 363.195 + 497 - 270 - + 90 + - 280.948 - 311 + 289.948 + 459.812 - 90 + 270 @@ -1953,29 +2073,29 @@ Mandatory - 1 + 2 0 - + - 327.922 - 377.906 + 84.1458 + 342 - 0 - + 90 + - 399 - 313.906 + 165.151 + 295.812 - 180 - + 270 + @@ -1986,29 +2106,29 @@ Mandatory - 2 + 1 0 - + - 280.948 - 444.812 + 134.719 + 401.906 - 270 - + 0 + - 290.266 - 497 + 196 + 392.906 - 90 - + 180 + @@ -2019,29 +2139,29 @@ Mandatory - 1 + 2 0 - + - 684.453 - 593.906 + 33.5729 + 342 - 0 - + 90 + - 803 - 578.906 + -5.28125 + 317.812 - 180 - + 270 + @@ -2052,29 +2172,29 @@ Mandatory - 2 + 4 0 - + - 405.531 - 563.906 + 818.656 + 452 - 0 - + 90 + - 535 - 593.906 + 822.635 + 408.812 - 180 - + 270 + @@ -2085,29 +2205,29 @@ Mandatory - 4 + 1 0 - + - 549 - 136.906 + 881.312 + 452 - 180 - + 90 + - 525.859 - 119.271 + 875.271 + 408.812 - 0 - + 270 + @@ -2118,29 +2238,29 @@ Mandatory - 1 + 2 0 - + - 423.836 - 17.8125 + 982.411 + 71 - 270 - + 90 + - 442.93 - 56 + 981.495 + 21.8125 - 90 - + 270 + @@ -2156,24 +2276,24 @@ - + - 627.109 - 105 + 1024.82 + 71 90 - + - 607.016 - 79.8125 + 1017.99 + 21.8125 270 - + @@ -2184,29 +2304,29 @@ Mandatory - 2 + 0 0 - + - 499.672 - -8.125 + 212.219 + -19.0938 0 - + - 557 - 54.9062 + 240 + -41.0938 180 - + @@ -2222,24 +2342,24 @@ - + - 735.406 - 344.906 + 35.2969 + -12.0938 0 - + - 770 - 376.906 + 106 + -19.0938 180 - + @@ -2250,29 +2370,29 @@ Mandatory - 2 + 5 0 - + - 499.672 - -34.0625 + 142.789 + 42 - 0 - + 90 + - 540 - -25.0938 + 159.109 + 12.8125 - 180 - + 270 + @@ -2283,29 +2403,29 @@ Mandatory - 3 + 1 0 - + - 470.573 - 245.812 + 68 + 73.9062 - 270 - + 180 + - 446.273 - 289 + 43.4531 + 94.9062 - 90 - + 0 + @@ -2316,29 +2436,29 @@ Mandatory - 9 + 2 0 - + - 570.755 - 459 + -9.85156 + 47.8125 - 90 - + 270 + - 622.469 - 390.812 + -5.27344 + 70 - 270 - + 90 + @@ -2349,29 +2469,29 @@ Mandatory - 2 + 3 0 - + - 649.51 - 459 + 188.727 + 148 90 - + - 678.938 - 390.812 + 282.109 + 83.8125 270 - + @@ -2382,29 +2502,29 @@ Mandatory - 1 + 2 0 - + - 610.133 - 536.812 + 282.109 + 20 - 270 - + 90 + - 609.727 - 562 + 275.289 + -16.1875 - 90 - + 270 + @@ -2415,29 +2535,29 @@ Mandatory - 3 + 1 0 - + - 59.5312 - 179.906 + 566 + 344.906 - 0 - + 180 + - 185 - 195.906 + 489.547 + 337.906 - 180 - + 0 + @@ -2448,29 +2568,29 @@ Mandatory - 2 + 4 0 - + - 543 - 227.906 + 494.427 + 388 - 180 - + 90 + - 525.859 - 182.542 + 458.031 + 362.812 - 0 - + 270 + @@ -2481,40 +2601,40 @@ Mandatory - 1 + 2 0 - + - 647.922 - 273.812 + 433.714 + 388 - 270 - + 90 + - 650.703 - 299 + 426.516 + 362.812 - 90 - + 270 + - OneToMany + OneToOne - Optional - Optional + Mandatory + Mandatory - 2 + 1 0 -- cgit v1.2.3-70-g09d2