From b1560e318912b1b7698d8424423402f107859de7 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Sun, 25 Mar 2018 14:16:24 +0200 Subject: misc/database-layout.dmf: layout of the database saved in git, too --- misc/database-layout.dmf | 1473 ++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 1473 insertions(+) create mode 100644 misc/database-layout.dmf diff --git a/misc/database-layout.dmf b/misc/database-layout.dmf new file mode 100644 index 0000000..304ea40 --- /dev/null +++ b/misc/database-layout.dmf @@ -0,0 +1,1473 @@ + + + Relational + + + + 686 + 272 + + + repository_moves + #ffffff + + + id + MEDIUMINT + True + True + + + from_repository + MEDIUMINT + True + False + + + to_repository + MEDIUMINT + True + False + + + upstream_package_repository + SMALLINT + True + False + + +
+ + + + 494 + 275 + + + repository_stabilities + #ffffff + + + id + SMALLINT + True + True + + + name + VARCHAR(32) + True + False + + + bugtracker_category + VARCHAR(32) + False + False + + +
+ + + + 54 + 334 + + + build_dependency_loops + #ffffff + + + id + BIGINT + True + True + + + loop + MEDIUMINT + True + False + + + build_assignment + BIGINT + True + False + + +
+ + + + 51 + -8 + + + dependency_types + #ffffff + + + id + SMALLINT + True + True + + + name + VARCHAR(32) + True + False + + + relevant_for_building + BIT + True + False + + + relevant_for_binary_packages + BIT + True + False + + +
+ + + + 453 + -10 + + + dependencies + #ffffff + + + id + BIGINT + True + True + + + dependent + BIGINT + True + False + + + depending_on + BIGINT + True + False + + + dependency_type + SMALLINT + True + False + + +
+ + + + 716 + 3 + + + install_targets + #ffffff + + + id + BIGINT + True + True + + + name + VARCHAR(64) + True + False + + +
+ + + + 333 + 418 + + + architectures + #ffffff + + + id + SMALLINT + True + True + + + name + VARCHAR(16) + True + False + + +
+ + + + 61 + 420 + + + package_sources + #ffffff + + + id + BIGINT + True + True + + + pkgbase + VARCHAR(64) + True + False + + + git_revision + VARCHAR(40) + True + False + + + mod_git_revision + VARCHAR(40) + True + False + + + upsream_package_repository + SMALLINT + True + False + + + uses_upstream + BIT + True + False + + + uses_modification + BIT + True + False + + +
+ + + + 584 + 472 + + + upstream_repositories + #ffffff + + + id + SMALLINT + True + True + + + name + VARCHAR(64) + True + False + + + git_repository + SMALLINT + True + False + + +
+ + + + 795 + 448 + + + git_repositories + #ffffff + + + id + SMALLINT + True + True + + + name + VARCHAR(64) + True + False + + + url + VARCHAR(128) + True + False + + + directory + VARCHAR(128) + True + False + + + head + VARCHAR(40) + True + False + + +
+ + + + 505 + 174 + + + repositories + #ffffff + + + id + MEDIUMINT + True + True + + + name + VARCHAR(64) + True + False + + + stability + SMALLINT + True + False + + + is_on_master_mirror + BIT + True + False + + +
+ + + + 691 + 94 + + + install_target_providers + #ffffff + + + id + BIGINT + True + True + + + package + BIGINT + True + False + + + install_target + BIGINT + True + False + + +
+ + + + 327 + 74 + + + binary_packages + #ffffff + + + id + BIGINT + True + True + + + build_assignment + 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 + True + False + + + is_tested + BIT + True + False + + + is_to_be_deleted + BIT + True + False + + + pkgname + VARCHAR(64) + True + False + + + architecture + SMALLINT + True + False + + +
+ + + + 172 + 101 + + + build_slaves + #ffffff + + + id + MEDIUMINT + True + True + + + name + VARCHAR(32) + True + False + + + ssh_key + VARCHAR(1024) + True + False + + + operator + VARCHAR(32) + True + False + + + currently_building + BIGINT + False + False + + + last_connection + TIME + True + False + + +
+ + + + 244 + 280 + + + build_assignments + #ffffff + + + id + BIGINT + True + True + + + package_source + BIGINT + True + False + + + architecture + SMALLINT + True + False + + + is_blocked + VARCHAR(128) + False + False + + + is_black_listed + VARCHAR(128) + False + False + + + is_broken + BIT + True + False + + + priority + SMALLINT + True + False + + +
+ + + + 57 + 220 + + + failed_builds + #ffffff + + + id + MEDIUMINT + True + True + + + build_slave + MEDIUMINT + True + False + + + build_assignment + BIGINT + True + False + + + date + TIME + True + False + + + reason + SMALLINT + True + False + + + log_file + VARCHAR(512) + True + False + + +
+ + + + 53 + 103 + + + fail_reasons + #ffffff + + + id + SMALLINT + True + True + + + name + VARCHAR(32) + True + False + + + identifier + VARCHAR(64) + True + False + + + severity + SMALLINT + True + False + + +
+ + + + 451 + 390 + + + repository_stability_relations + #ffffff + + + id + MEDIUMINT + True + True + + + more_stable + MEDIUMINT + True + False + + + less_stable + MEDIUMINT + True + False + + +
+ + + + + + + 804.133 + 349.812 + + 270 + + + + + 658.727 + 472 + + 90 + + + + + + OneToMany + + Mandatory + Mandatory + + + 3 + 0 + + + + + + + + + 764.755 + 272 + + 90 + + + + + 674.406 + 225.875 + + 0 + + + + + + OneToMany + + Mandatory + Mandatory + + + 1 + 0 + + + + + + + + + 843.51 + 272 + + 90 + + + + + 674.406 + 199.938 + + 0 + + + + + + OneToMany + + Mandatory + Mandatory + + + 2 + 0 + + + + + + + + + 428.146 + 263.812 + + 270 + + + + + 396.031 + 418 + + 90 + + + + + + OneToMany + + Mandatory + Mandatory + + + 11 + 0 + + + + + + + + + 453 + 28.9062 + + 180 + + + + + 284.844 + 30.9062 + + 0 + + + + + + OneToMany + + Mandatory + Mandatory + + + 3 + 0 + + + + + + + + + 589.703 + 251.812 + + 270 + + + + + 572.953 + 275 + + 90 + + + + + + OneToMany + + Mandatory + Mandatory + + + 2 + 0 + + + + + + + + + 604.672 + 28.9062 + + 0 + + + + + 716 + 27.9062 + + 180 + + + + + + OneToMany + + Mandatory + Mandatory + + + 2 + 0 + + + + + + + + + 769.109 + 94 + + 90 + + + + + 766.016 + 52.8125 + + 270 + + + + + + OneToMany + + Mandatory + Mandatory + + + 2 + 0 + + + + + + + + + 528.836 + 67.8125 + + 270 + + + + + 478.719 + 121.453 + + 0 + + + + + + OneToMany + + Mandatory + Mandatory + + + 1 + 0 + + + + + + + + + 691 + 125.906 + + 180 + + + + + 478.719 + 168.906 + + 0 + + + + + + OneToMany + + Mandatory + Mandatory + + + 1 + 0 + + + + + + + + + 291.531 + 479.906 + + 0 + + + + + 584 + 503.906 + + 180 + + + + + + OneToMany + + Mandatory + Mandatory + + + 4 + 0 + + + + + + + + + 478.719 + 216.359 + + 0 + + + + + 505 + 212.906 + + 180 + + + + + + OneToMany + + Mandatory + Mandatory + + + 2 + 0 + + + + + + + + + 733.453 + 503.906 + + 0 + + + + + 795 + 493.906 + + 180 + + + + + + OneToMany + + Mandatory + Mandatory + + + 2 + 0 + + + + + + + + + 290.974 + 399.812 + + 270 + + + + + 176.266 + 420 + + 90 + + + + + + OneToMany + + Mandatory + Mandatory + + + 1 + 0 + + + + + + + + + 337.948 + 399.812 + + 270 + + + + + 364.516 + 418 + + 90 + + + + + + OneToMany + + Mandatory + Mandatory + + + 2 + 0 + + + + + + + + + 377.573 + 263.812 + + 270 + + + + + 337.948 + 280 + + 90 + + + + + + OneToMany + + Mandatory + Mandatory + + + 1 + 0 + + + + + + + + + 266.302 + 206.812 + + 270 + + + + + 290.974 + 280 + + 90 + + + + + + OneToMany + + Mandatory + Mandatory + + + 4 + 0 + + + + + + + + + 216.391 + 365.906 + + 0 + + + + + 244 + 359.875 + + 180 + + + + + + OneToMany + + Mandatory + Mandatory + + + 2 + 0 + + + + + + + + + 158.146 + 220 + + 90 + + + + + 219.151 + 206.812 + + 270 + + + + + + OneToMany + + Mandatory + Mandatory + + + 1 + 0 + + + + + + + + + 208.719 + 272.906 + + 0 + + + + + 244 + 319.938 + + 180 + + + + + + OneToMany + + Mandatory + Mandatory + + + 2 + 0 + + + + + + + + + 107.573 + 220 + + 90 + + + + + 100.719 + 180.812 + + 270 + + + + + + OneToMany + + Mandatory + Mandatory + + + 4 + 0 + + + + + + + + + 576.312 + 390 + + 90 + + + + + 599.271 + 338.812 + + 270 + + + + + + OneToMany + + Mandatory + Mandatory + + + 1 + 0 + + + + + + + + + 513.656 + 390 + + 90 + + + + + 546.635 + 338.812 + + 270 + + + + + + OneToMany + + Mandatory + Mandatory + + + 2 + 0 + + + + + -- cgit v1.2.3-70-g09d2