diff options
| -rwxr-xr-x | bin/bootstrap-mysql | 1 | ||||
| -rw-r--r-- | misc/database-layout.dmf | 1012 |
2 files changed, 510 insertions, 503 deletions
diff --git a/bin/bootstrap-mysql b/bin/bootstrap-mysql index afe9c42..ca84bcf 100755 --- a/bin/bootstrap-mysql +++ b/bin/bootstrap-mysql @@ -111,6 +111,7 @@ if [ ! "$1" = 'slim' ]; then ' upstream_package_repository SMALLINT :upstream_repositories' \ ' uses_upstream BIT' \ ' uses_modification BIT' \ + ' commit_time DATETIME' \ ' UNIQUE content pkgbase git_revision mod_git_revision' \ 'upstream_repositories SMALLINT' \ ' name VARCHAR(64)' \ diff --git a/misc/database-layout.dmf b/misc/database-layout.dmf index 0a596d2..adb7445 100644 --- a/misc/database-layout.dmf +++ b/misc/database-layout.dmf @@ -2,121 +2,109 @@ <diagram xmlns="http://oxygene.sk/ns/diagram/1/"> <notation>Relational</notation> <item-list> - <item type="database-table" id="{457d2e44-2570-45c8-b93e-7b335efd0483}"> + <item type="database-table" id="{d823ab09-1c04-44ee-ad4b-6802208967ff}"> <position> - <x>796</x> - <y>131</y> + <x>481</x> + <y>395</y> </position> <table> - <name>file_providers</name> + <name>repository_moves</name> <color>#ffffff</color> <column-list> <column> <name>id</name> - <data-type>BIGINT</data-type> + <data-type>MEDIUMINT</data-type> <required>True</required> <primary-key>True</primary-key> </column> <column> - <name>package</name> - <data-type>BIGINT</data-type> + <name>from_repository</name> + <data-type>MEDIUMINT</data-type> <required>True</required> <primary-key>False</primary-key> </column> <column> - <name>file</name> - <data-type>BIGINT</data-type> + <name>to_repository</name> + <data-type>MEDIUMINT</data-type> <required>True</required> <primary-key>False</primary-key> </column> <column> - <name>file_name_hash</name> - <data-type>MEDIUMINT</data-type> + <name>upstream_package_repository</name> + <data-type>SMALLINT</data-type> <required>True</required> <primary-key>False</primary-key> </column> </column-list> </table> </item> - <item type="database-table" id="{f24a3299-870d-4312-8dbe-50b3bf1953d3}"> + <item type="database-table" id="{fee50b4d-969b-4b5f-8545-90ea8f8f7aec}"> <position> - <x>785</x> - <y>6</y> + <x>763</x> + <y>241</y> </position> <table> - <name>files</name> + <name>repository_stabilities</name> <color>#ffffff</color> <column-list> <column> <name>id</name> - <data-type>BIGINT</data-type> + <data-type>SMALLINT</data-type> <required>True</required> <primary-key>True</primary-key> </column> <column> - <name>path</name> - <data-type>TEXT</data-type> - <required>True</required> - <primary-key>False</primary-key> - </column> - <column> <name>name</name> - <data-type>TEXT</data-type> - <required>True</required> - <primary-key>False</primary-key> - </column> - <column> - <name>name_hash</name> - <data-type>MEDIUMINT</data-type> + <data-type>VARCHAR(32)</data-type> <required>True</required> <primary-key>False</primary-key> </column> <column> - <name>absolute_name_hash</name> - <data-type>VARCHAR(54)</data-type> - <required>True</required> + <name>bugtracker_category</name> + <data-type>VARCHAR(32)</data-type> + <required>False</required> <primary-key>False</primary-key> </column> </column-list> </table> </item> - <item type="database-table" id="{92f54126-a433-458e-80b7-67235e560334}"> + <item type="database-table" id="{04b6fdc5-85ae-4416-8db5-034ad05be93a}"> <position> - <x>754</x> - <y>399</y> + <x>52</x> + <y>516</y> </position> <table> - <name>repository_stability_relations</name> + <name>build_dependency_loops</name> <color>#ffffff</color> <column-list> <column> <name>id</name> - <data-type>MEDIUMINT</data-type> + <data-type>BIGINT</data-type> <required>True</required> <primary-key>True</primary-key> </column> <column> - <name>more_stable</name> + <name>loop</name> <data-type>MEDIUMINT</data-type> <required>True</required> <primary-key>False</primary-key> </column> <column> - <name>less_stable</name> - <data-type>MEDIUMINT</data-type> + <name>build_assignment</name> + <data-type>BIGINT</data-type> <required>True</required> <primary-key>False</primary-key> </column> </column-list> </table> </item> - <item type="database-table" id="{7b159780-7f39-45a7-9557-046874a57e43}"> + <item type="database-table" id="{be821d83-a9b4-4c0c-8e1b-433730200714}"> <position> - <x>53</x> - <y>103</y> + <x>51</x> + <y>-8</y> </position> <table> - <name>fail_reasons</name> + <name>dependency_types</name> <color>#ffffff</color> <column-list> <column> @@ -132,75 +120,63 @@ <primary-key>False</primary-key> </column> <column> - <name>identifier</name> - <data-type>VARCHAR(64)</data-type> + <name>relevant_for_building</name> + <data-type>BIT</data-type> <required>True</required> <primary-key>False</primary-key> </column> <column> - <name>severity</name> - <data-type>SMALLINT</data-type> + <name>relevant_for_binary_packages</name> + <data-type>BIT</data-type> <required>True</required> <primary-key>False</primary-key> </column> </column-list> </table> </item> - <item type="database-table" id="{a774fcb7-1193-4b57-947c-135212695915}"> + <item type="database-table" id="{caab4a73-46dc-49dc-ac51-d8ae916827c5}"> <position> - <x>45</x> - <y>287</y> + <x>496</x> + <y>-6</y> </position> <table> - <name>failed_builds</name> + <name>dependencies</name> <color>#ffffff</color> <column-list> <column> <name>id</name> - <data-type>MEDIUMINT</data-type> + <data-type>BIGINT</data-type> <required>True</required> <primary-key>True</primary-key> </column> <column> - <name>build_slave</name> - <data-type>MEDIUMINT</data-type> - <required>True</required> - <primary-key>False</primary-key> - </column> - <column> - <name>build_assignment</name> + <name>dependent</name> <data-type>BIGINT</data-type> <required>True</required> <primary-key>False</primary-key> </column> <column> - <name>date</name> - <data-type>TIME</data-type> + <name>depending_on</name> + <data-type>BIGINT</data-type> <required>True</required> <primary-key>False</primary-key> </column> <column> - <name>reason</name> + <name>dependency_type</name> <data-type>SMALLINT</data-type> <required>True</required> <primary-key>False</primary-key> </column> - <column> - <name>log_file</name> - <data-type>VARCHAR(512)</data-type> - <required>True</required> - <primary-key>False</primary-key> - </column> </column-list> </table> </item> - <item type="database-table" id="{6ea5c997-98b5-4ec8-b63e-3f2acdcaf627}"> + <item type="database-table" id="{e84f8e5f-28e0-4d8b-a7e5-0f80a896f74e}"> <position> - <x>245</x> - <y>331</y> + <x>680</x> + <y>3</y> </position> <table> - <name>build_assignments</name> + <name>install_targets</name> <color>#ffffff</color> <column-list> <column> @@ -210,189 +186,201 @@ <primary-key>True</primary-key> </column> <column> - <name>package_source</name> - <data-type>BIGINT</data-type> + <name>name</name> + <data-type>VARCHAR(64)</data-type> <required>True</required> <primary-key>False</primary-key> </column> + </column-list> + </table> + </item> + <item type="database-table" id="{04f424bf-6465-478b-9529-0038615b51d9}"> + <position> + <x>415</x> + <y>321</y> + </position> + <table> + <name>architectures</name> + <color>#ffffff</color> + <column-list> <column> - <name>architecture</name> + <name>id</name> <data-type>SMALLINT</data-type> <required>True</required> - <primary-key>False</primary-key> - </column> - <column> - <name>is_blocked</name> - <data-type>VARCHAR(128)</data-type> - <required>False</required> - <primary-key>False</primary-key> - </column> - <column> - <name>is_black_listed</name> - <data-type>VARCHAR(128)</data-type> - <required>False</required> - <primary-key>False</primary-key> - </column> - <column> - <name>is_broken</name> - <data-type>BIT</data-type> - <required>True</required> - <primary-key>False</primary-key> + <primary-key>True</primary-key> </column> <column> - <name>priority</name> - <data-type>SMALLINT</data-type> + <name>name</name> + <data-type>VARCHAR(16)</data-type> <required>True</required> <primary-key>False</primary-key> </column> </column-list> </table> </item> - <item type="database-table" id="{a945e439-8796-49e8-aa9b-7ce0a58a2c26}"> + <item type="database-table" id="{7c210122-c51d-4724-b7cc-22f143bc47ac}"> <position> - <x>163</x> - <y>88</y> + <x>229</x> + <y>471</y> </position> <table> - <name>build_slaves</name> + <name>package_sources</name> <color>#ffffff</color> <column-list> <column> <name>id</name> - <data-type>MEDIUMINT</data-type> + <data-type>BIGINT</data-type> <required>True</required> <primary-key>True</primary-key> </column> <column> - <name>name</name> - <data-type>VARCHAR(32)</data-type> + <name>pkgbase</name> + <data-type>VARCHAR(64)</data-type> <required>True</required> <primary-key>False</primary-key> </column> <column> - <name>ssh_key</name> - <data-type>VARCHAR(1024)</data-type> + <name>git_revision</name> + <data-type>VARCHAR(40)</data-type> <required>True</required> <primary-key>False</primary-key> </column> <column> - <name>operator</name> - <data-type>VARCHAR(32)</data-type> + <name>mod_git_revision</name> + <data-type>VARCHAR(40)</data-type> <required>True</required> <primary-key>False</primary-key> </column> <column> - <name>currently_building</name> - <data-type>BIGINT</data-type> - <required>False</required> + <name>upsream_package_repository</name> + <data-type>SMALLINT</data-type> + <required>True</required> <primary-key>False</primary-key> </column> <column> - <name>last_connection</name> - <data-type>TIME</data-type> + <name>uses_upstream</name> + <data-type>BIT</data-type> <required>True</required> <primary-key>False</primary-key> </column> <column> - <name>logged_lines</name> - <data-type>BIGINT</data-type> - <required>False</required> + <name>uses_modification</name> + <data-type>BIT</data-type> + <required>True</required> <primary-key>False</primary-key> </column> <column> - <name>last_action</name> - <data-type>VARCHAR(32)</data-type> - <required>False</required> + <name>commit_time</name> + <data-type>DATETIME</data-type> + <required>True</required> <primary-key>False</primary-key> </column> </column-list> </table> </item> - <item type="database-table" id="{2e6c3b80-fef6-4d2b-8945-7ea6be1b646c}"> + <item type="database-table" id="{d01e6205-a6dc-4724-a1fd-d4b2f73637ea}"> <position> - <x>329</x> - <y>46</y> + <x>539</x> + <y>533</y> </position> <table> - <name>binary_packages</name> + <name>upstream_repositories</name> <color>#ffffff</color> <column-list> <column> <name>id</name> - <data-type>BIGINT</data-type> + <data-type>SMALLINT</data-type> <required>True</required> <primary-key>True</primary-key> </column> <column> - <name>build_assignment</name> - <data-type>BIGINT</data-type> + <name>name</name> + <data-type>VARCHAR(64)</data-type> <required>True</required> <primary-key>False</primary-key> </column> <column> - <name>repository</name> - <data-type>MEDIUMINT</data-type> + <name>git_repository</name> + <data-type>SMALLINT</data-type> <required>True</required> <primary-key>False</primary-key> </column> + </column-list> + </table> + </item> + <item type="database-table" id="{b3c86235-971a-4d3e-873c-c4179aa96cbc}"> + <position> + <x>770</x> + <y>508</y> + </position> + <table> + <name>git_repositories</name> + <color>#ffffff</color> + <column-list> <column> - <name>epoch</name> - <data-type>MEDIUMINT</data-type> + <name>id</name> + <data-type>SMALLINT</data-type> <required>True</required> - <primary-key>False</primary-key> + <primary-key>True</primary-key> </column> <column> - <name>pkgver</name> + <name>name</name> <data-type>VARCHAR(64)</data-type> <required>True</required> <primary-key>False</primary-key> </column> <column> - <name>pkgrel</name> - <data-type>MEDIUMINT</data-type> - <required>True</required> - <primary-key>False</primary-key> - </column> - <column> - <name>sub_pkgrel</name> - <data-type>MEDIUMINT</data-type> + <name>url</name> + <data-type>VARCHAR(128)</data-type> <required>True</required> <primary-key>False</primary-key> </column> <column> - <name>has_issues</name> - <data-type>BIT</data-type> + <name>directory</name> + <data-type>VARCHAR(128)</data-type> <required>True</required> <primary-key>False</primary-key> </column> <column> - <name>is_tested</name> - <data-type>BIT</data-type> + <name>head</name> + <data-type>VARCHAR(40)</data-type> <required>True</required> <primary-key>False</primary-key> </column> + </column-list> + </table> + </item> + <item type="database-table" id="{844766fc-c5af-4f61-b51b-d3f9393c60ca}"> + <position> + <x>516</x> + <y>246</y> + </position> + <table> + <name>repositories</name> + <color>#ffffff</color> + <column-list> <column> - <name>is_to_be_deleted</name> - <data-type>BIT</data-type> + <name>id</name> + <data-type>MEDIUMINT</data-type> <required>True</required> - <primary-key>False</primary-key> + <primary-key>True</primary-key> </column> <column> - <name>pkgname</name> + <name>name</name> <data-type>VARCHAR(64)</data-type> <required>True</required> <primary-key>False</primary-key> </column> <column> - <name>architecture</name> + <name>stability</name> <data-type>SMALLINT</data-type> <required>True</required> <primary-key>False</primary-key> </column> <column> - <name>sha512sum</name> - <data-type>VARCHAR(128)</data-type> - <required>False</required> + <name>is_on_master_mirror</name> + <data-type>BIT</data-type> + <required>True</required> <primary-key>False</primary-key> </column> </column-list> @@ -428,259 +416,265 @@ </column-list> </table> </item> - <item type="database-table" id="{844766fc-c5af-4f61-b51b-d3f9393c60ca}"> + <item type="database-table" id="{2e6c3b80-fef6-4d2b-8945-7ea6be1b646c}"> <position> - <x>516</x> - <y>246</y> + <x>329</x> + <y>46</y> </position> <table> - <name>repositories</name> + <name>binary_packages</name> <color>#ffffff</color> <column-list> <column> <name>id</name> - <data-type>MEDIUMINT</data-type> + <data-type>BIGINT</data-type> <required>True</required> <primary-key>True</primary-key> </column> <column> - <name>name</name> - <data-type>VARCHAR(64)</data-type> + <name>build_assignment</name> + <data-type>BIGINT</data-type> <required>True</required> <primary-key>False</primary-key> </column> <column> - <name>stability</name> - <data-type>SMALLINT</data-type> + <name>repository</name> + <data-type>MEDIUMINT</data-type> <required>True</required> <primary-key>False</primary-key> </column> <column> - <name>is_on_master_mirror</name> - <data-type>BIT</data-type> + <name>epoch</name> + <data-type>MEDIUMINT</data-type> <required>True</required> <primary-key>False</primary-key> </column> - </column-list> - </table> - </item> - <item type="database-table" id="{b3c86235-971a-4d3e-873c-c4179aa96cbc}"> - <position> - <x>770</x> - <y>508</y> - </position> - <table> - <name>git_repositories</name> - <color>#ffffff</color> - <column-list> <column> - <name>id</name> - <data-type>SMALLINT</data-type> + <name>pkgver</name> + <data-type>VARCHAR(64)</data-type> <required>True</required> - <primary-key>True</primary-key> + <primary-key>False</primary-key> </column> <column> - <name>name</name> - <data-type>VARCHAR(64)</data-type> + <name>pkgrel</name> + <data-type>MEDIUMINT</data-type> <required>True</required> <primary-key>False</primary-key> </column> <column> - <name>url</name> - <data-type>VARCHAR(128)</data-type> + <name>sub_pkgrel</name> + <data-type>MEDIUMINT</data-type> <required>True</required> <primary-key>False</primary-key> </column> <column> - <name>directory</name> - <data-type>VARCHAR(128)</data-type> + <name>has_issues</name> + <data-type>BIT</data-type> <required>True</required> <primary-key>False</primary-key> </column> <column> - <name>head</name> - <data-type>VARCHAR(40)</data-type> + <name>is_tested</name> + <data-type>BIT</data-type> <required>True</required> <primary-key>False</primary-key> </column> - </column-list> - </table> - </item> - <item type="database-table" id="{d01e6205-a6dc-4724-a1fd-d4b2f73637ea}"> - <position> - <x>539</x> - <y>533</y> - </position> - <table> - <name>upstream_repositories</name> - <color>#ffffff</color> - <column-list> <column> - <name>id</name> - <data-type>SMALLINT</data-type> + <name>is_to_be_deleted</name> + <data-type>BIT</data-type> <required>True</required> - <primary-key>True</primary-key> + <primary-key>False</primary-key> </column> <column> - <name>name</name> + <name>pkgname</name> <data-type>VARCHAR(64)</data-type> <required>True</required> <primary-key>False</primary-key> </column> <column> - <name>git_repository</name> + <name>architecture</name> <data-type>SMALLINT</data-type> <required>True</required> <primary-key>False</primary-key> </column> + <column> + <name>sha512sum</name> + <data-type>VARCHAR(128)</data-type> + <required>False</required> + <primary-key>False</primary-key> + </column> </column-list> </table> </item> - <item type="database-table" id="{7c210122-c51d-4724-b7cc-22f143bc47ac}"> + <item type="database-table" id="{a945e439-8796-49e8-aa9b-7ce0a58a2c26}"> <position> - <x>229</x> - <y>487</y> + <x>163</x> + <y>88</y> </position> <table> - <name>package_sources</name> + <name>build_slaves</name> <color>#ffffff</color> <column-list> <column> <name>id</name> - <data-type>BIGINT</data-type> + <data-type>MEDIUMINT</data-type> <required>True</required> <primary-key>True</primary-key> </column> <column> - <name>pkgbase</name> - <data-type>VARCHAR(64)</data-type> + <name>name</name> + <data-type>VARCHAR(32)</data-type> <required>True</required> <primary-key>False</primary-key> </column> <column> - <name>git_revision</name> - <data-type>VARCHAR(40)</data-type> + <name>ssh_key</name> + <data-type>VARCHAR(1024)</data-type> <required>True</required> <primary-key>False</primary-key> </column> <column> - <name>mod_git_revision</name> - <data-type>VARCHAR(40)</data-type> + <name>operator</name> + <data-type>VARCHAR(32)</data-type> <required>True</required> <primary-key>False</primary-key> </column> <column> - <name>upsream_package_repository</name> - <data-type>SMALLINT</data-type> - <required>True</required> + <name>currently_building</name> + <data-type>BIGINT</data-type> + <required>False</required> <primary-key>False</primary-key> </column> <column> - <name>uses_upstream</name> - <data-type>BIT</data-type> + <name>last_connection</name> + <data-type>TIME</data-type> <required>True</required> <primary-key>False</primary-key> </column> <column> - <name>uses_modification</name> - <data-type>BIT</data-type> - <required>True</required> + <name>logged_lines</name> + <data-type>BIGINT</data-type> + <required>False</required> + <primary-key>False</primary-key> + </column> + <column> + <name>last_action</name> + <data-type>VARCHAR(32)</data-type> + <required>False</required> <primary-key>False</primary-key> </column> </column-list> </table> </item> - <item type="database-table" id="{04f424bf-6465-478b-9529-0038615b51d9}"> + <item type="database-table" id="{6ea5c997-98b5-4ec8-b63e-3f2acdcaf627}"> <position> - <x>421</x> - <y>321</y> + <x>247</x> + <y>291</y> </position> <table> - <name>architectures</name> + <name>build_assignments</name> <color>#ffffff</color> <column-list> <column> <name>id</name> - <data-type>SMALLINT</data-type> + <data-type>BIGINT</data-type> <required>True</required> <primary-key>True</primary-key> </column> <column> - <name>name</name> - <data-type>VARCHAR(16)</data-type> + <name>package_source</name> + <data-type>BIGINT</data-type> <required>True</required> <primary-key>False</primary-key> </column> - </column-list> - </table> - </item> - <item type="database-table" id="{e84f8e5f-28e0-4d8b-a7e5-0f80a896f74e}"> - <position> - <x>680</x> - <y>3</y> - </position> - <table> - <name>install_targets</name> - <color>#ffffff</color> - <column-list> <column> - <name>id</name> - <data-type>BIGINT</data-type> + <name>architecture</name> + <data-type>SMALLINT</data-type> <required>True</required> - <primary-key>True</primary-key> + <primary-key>False</primary-key> </column> <column> - <name>name</name> - <data-type>VARCHAR(64)</data-type> + <name>is_blocked</name> + <data-type>VARCHAR(128)</data-type> + <required>False</required> + <primary-key>False</primary-key> + </column> + <column> + <name>is_black_listed</name> + <data-type>VARCHAR(128)</data-type> + <required>False</required> + <primary-key>False</primary-key> + </column> + <column> + <name>is_broken</name> + <data-type>BIT</data-type> + <required>True</required> + <primary-key>False</primary-key> + </column> + <column> + <name>priority</name> + <data-type>SMALLINT</data-type> <required>True</required> <primary-key>False</primary-key> </column> </column-list> </table> </item> - <item type="database-table" id="{caab4a73-46dc-49dc-ac51-d8ae916827c5}"> + <item type="database-table" id="{a774fcb7-1193-4b57-947c-135212695915}"> <position> - <x>496</x> - <y>-6</y> + <x>45</x> + <y>287</y> </position> <table> - <name>dependencies</name> + <name>failed_builds</name> <color>#ffffff</color> <column-list> <column> <name>id</name> - <data-type>BIGINT</data-type> + <data-type>MEDIUMINT</data-type> <required>True</required> <primary-key>True</primary-key> </column> <column> - <name>dependent</name> - <data-type>BIGINT</data-type> + <name>build_slave</name> + <data-type>MEDIUMINT</data-type> <required>True</required> <primary-key>False</primary-key> </column> <column> - <name>depending_on</name> + <name>build_assignment</name> <data-type>BIGINT</data-type> <required>True</required> <primary-key>False</primary-key> </column> <column> - <name>dependency_type</name> + <name>date</name> + <data-type>DATETIME</data-type> + <required>True</required> + <primary-key>False</primary-key> + </column> + <column> + <name>reason</name> <data-type>SMALLINT</data-type> <required>True</required> <primary-key>False</primary-key> </column> + <column> + <name>log_file</name> + <data-type>VARCHAR(512)</data-type> + <required>True</required> + <primary-key>False</primary-key> + </column> </column-list> </table> </item> - <item type="database-table" id="{be821d83-a9b4-4c0c-8e1b-433730200714}"> + <item type="database-table" id="{7b159780-7f39-45a7-9557-046874a57e43}"> <position> - <x>51</x> - <y>-8</y> + <x>53</x> + <y>103</y> </position> <table> - <name>dependency_types</name> + <name>fail_reasons</name> <color>#ffffff</color> <column-list> <column> @@ -696,134 +690,146 @@ <primary-key>False</primary-key> </column> <column> - <name>relevant_for_building</name> - <data-type>BIT</data-type> + <name>identifier</name> + <data-type>VARCHAR(64)</data-type> <required>True</required> <primary-key>False</primary-key> </column> <column> - <name>relevant_for_binary_packages</name> - <data-type>BIT</data-type> + <name>severity</name> + <data-type>SMALLINT</data-type> <required>True</required> <primary-key>False</primary-key> </column> </column-list> </table> </item> - <item type="database-table" id="{04b6fdc5-85ae-4416-8db5-034ad05be93a}"> + <item type="database-table" id="{92f54126-a433-458e-80b7-67235e560334}"> <position> - <x>52</x> - <y>516</y> + <x>754</x> + <y>399</y> </position> <table> - <name>build_dependency_loops</name> + <name>repository_stability_relations</name> <color>#ffffff</color> <column-list> <column> <name>id</name> - <data-type>BIGINT</data-type> + <data-type>MEDIUMINT</data-type> <required>True</required> <primary-key>True</primary-key> </column> <column> - <name>loop</name> + <name>more_stable</name> <data-type>MEDIUMINT</data-type> <required>True</required> <primary-key>False</primary-key> </column> <column> - <name>build_assignment</name> - <data-type>BIGINT</data-type> + <name>less_stable</name> + <data-type>MEDIUMINT</data-type> <required>True</required> <primary-key>False</primary-key> </column> </column-list> </table> </item> - <item type="database-table" id="{fee50b4d-969b-4b5f-8545-90ea8f8f7aec}"> + <item type="database-table" id="{f24a3299-870d-4312-8dbe-50b3bf1953d3}"> <position> - <x>763</x> - <y>241</y> + <x>785</x> + <y>6</y> </position> <table> - <name>repository_stabilities</name> + <name>files</name> <color>#ffffff</color> <column-list> <column> <name>id</name> - <data-type>SMALLINT</data-type> + <data-type>BIGINT</data-type> <required>True</required> <primary-key>True</primary-key> </column> <column> + <name>path</name> + <data-type>TEXT</data-type> + <required>True</required> + <primary-key>False</primary-key> + </column> + <column> <name>name</name> - <data-type>VARCHAR(32)</data-type> + <data-type>TEXT</data-type> <required>True</required> <primary-key>False</primary-key> </column> <column> - <name>bugtracker_category</name> - <data-type>VARCHAR(32)</data-type> - <required>False</required> + <name>name_hash</name> + <data-type>MEDIUMINT</data-type> + <required>True</required> + <primary-key>False</primary-key> + </column> + <column> + <name>absolute_name_hash</name> + <data-type>VARCHAR(54)</data-type> + <required>True</required> <primary-key>False</primary-key> </column> </column-list> </table> </item> - <item type="database-table" id="{d823ab09-1c04-44ee-ad4b-6802208967ff}"> + <item type="database-table" id="{457d2e44-2570-45c8-b93e-7b335efd0483}"> <position> - <x>481</x> - <y>395</y> + <x>796</x> + <y>131</y> </position> <table> - <name>repository_moves</name> + <name>file_providers</name> <color>#ffffff</color> <column-list> <column> <name>id</name> - <data-type>MEDIUMINT</data-type> + <data-type>BIGINT</data-type> <required>True</required> <primary-key>True</primary-key> </column> <column> - <name>from_repository</name> - <data-type>MEDIUMINT</data-type> + <name>package</name> + <data-type>BIGINT</data-type> <required>True</required> <primary-key>False</primary-key> </column> <column> - <name>to_repository</name> - <data-type>MEDIUMINT</data-type> + <name>file</name> + <data-type>BIGINT</data-type> <required>True</required> <primary-key>False</primary-key> </column> <column> - <name>upstream_package_repository</name> - <data-type>SMALLINT</data-type> + <name>file_name_hash</name> + <data-type>MEDIUMINT</data-type> <required>True</required> <primary-key>False</primary-key> </column> </column-list> </table> </item> - <item type="database-relationship" id="{4a844898-e05d-4919-8c83-cf90f28edf42}"> + <item type="database-relationship" id="{30efa4b2-f4e7-4c8d-943e-44c699e54853}"> <line> <connector-list> <connector> <position> - <x>796</x> - <y>169.906</y> + <x>599.133</x> + <y>472.812</y> </position> - <angle>180</angle> - <hub owner="{457d2e44-2570-45c8-b93e-7b335efd0483}"/> + <angle>270</angle> + <hub owner="{d823ab09-1c04-44ee-ad4b-6802208967ff}"/> </connector> <connector> <position> - <x>480.719</x> - <y>168.288</y> + <x>613.727</x> + <y>533</y> </position> - <angle>0</angle> - <hub owner="{2e6c3b80-fef6-4d2b-8945-7ea6be1b646c}"/> + <angle>90</angle> + <hub owner="{d01e6205-a6dc-4724-a1fd-d4b2f73637ea}"/> </connector> </connector-list> </line> @@ -834,62 +840,62 @@ <parent>Mandatory</parent> </modality> <columns> - <child>1</child> + <child>3</child> <parent>0</parent> </columns> </relationship> </item> - <item type="database-relationship" id="{e64f4d17-ff78-45f2-ab9b-281bf8fc5fb6}"> + <item type="database-relationship" id="{6094d4c4-439f-4e6c-94e1-736ae145362a}"> <line> <connector-list> <connector> <position> - <x>864</x> - <y>131</y> + <x>559.755</x> + <y>395</y> </position> <angle>90</angle> - <hub owner="{457d2e44-2570-45c8-b93e-7b335efd0483}"/> + <hub owner="{d823ab09-1c04-44ee-ad4b-6802208967ff}"/> </connector> <connector> <position> - <x>871.711</x> - <y>97.8125</y> + <x>572.469</x> + <y>323.812</y> </position> <angle>270</angle> - <hub owner="{f24a3299-870d-4312-8dbe-50b3bf1953d3}"/> + <hub owner="{844766fc-c5af-4f61-b51b-d3f9393c60ca}"/> </connector> </connector-list> </line> <relationship> <cardinality>OneToMany</cardinality> <modality> - <child>Optional</child> - <parent>Optional</parent> + <child>Mandatory</child> + <parent>Mandatory</parent> </modality> <columns> - <child>2</child> + <child>1</child> <parent>0</parent> </columns> </relationship> </item> - <item type="database-relationship" id="{fa899065-104a-466d-bc8c-16589a774a45}"> + <item type="database-relationship" id="{4b0f5386-c5f6-4fa4-9c78-f0d85410c366}"> <line> <connector-list> <connector> <position> - <x>816.656</x> - <y>399</y> + <x>638.51</x> + <y>395</y> </position> <angle>90</angle> - <hub owner="{92f54126-a433-458e-80b7-67235e560334}"/> + <hub owner="{d823ab09-1c04-44ee-ad4b-6802208967ff}"/> </connector> <connector> <position> - <x>815.635</x> - <y>304.812</y> + <x>628.938</x> + <y>323.812</y> </position> <angle>270</angle> - <hub owner="{fee50b4d-969b-4b5f-8545-90ea8f8f7aec}"/> + <hub owner="{844766fc-c5af-4f61-b51b-d3f9393c60ca}"/> </connector> </connector-list> </line> @@ -905,24 +911,24 @@ </columns> </relationship> </item> - <item type="database-relationship" id="{8f5f94cd-2919-43f6-ae67-6b783850a2e7}"> + <item type="database-relationship" id="{c54c97e3-dd0a-4b21-9eeb-708d5b492e2a}"> <line> <connector-list> <connector> <position> - <x>879.312</x> - <y>399</y> + <x>430.146</x> + <y>249.812</y> </position> - <angle>90</angle> - <hub owner="{92f54126-a433-458e-80b7-67235e560334}"/> + <angle>270</angle> + <hub owner="{2e6c3b80-fef6-4d2b-8945-7ea6be1b646c}"/> </connector> <connector> <position> - <x>868.271</x> - <y>304.812</y> + <x>462.273</x> + <y>321</y> </position> - <angle>270</angle> - <hub owner="{fee50b4d-969b-4b5f-8545-90ea8f8f7aec}"/> + <angle>90</angle> + <hub owner="{04f424bf-6465-478b-9529-0038615b51d9}"/> </connector> </connector-list> </line> @@ -933,29 +939,29 @@ <parent>Mandatory</parent> </modality> <columns> - <child>1</child> + <child>11</child> <parent>0</parent> </columns> </relationship> </item> - <item type="database-relationship" id="{65ace480-001e-4e4e-912d-2a975ff995c8}"> + <item type="database-relationship" id="{d3ded37c-70d5-4388-8e27-2329f59a1d9c}"> <line> <connector-list> <connector> <position> - <x>95.5729</x> - <y>287</y> + <x>496</x> + <y>32.9062</y> </position> - <angle>90</angle> - <hub owner="{a774fcb7-1193-4b57-947c-135212695915}"/> + <angle>180</angle> + <hub owner="{caab4a73-46dc-49dc-ac51-d8ae916827c5}"/> </connector> <connector> <position> - <x>100.719</x> - <y>180.812</y> + <x>284.844</x> + <y>30.9062</y> </position> - <angle>270</angle> - <hub owner="{7b159780-7f39-45a7-9557-046874a57e43}"/> + <angle>0</angle> + <hub owner="{be821d83-a9b4-4c0c-8e1b-433730200714}"/> </connector> </connector-list> </line> @@ -966,29 +972,29 @@ <parent>Mandatory</parent> </modality> <columns> - <child>4</child> + <child>3</child> <parent>0</parent> </columns> </relationship> </item> - <item type="database-relationship" id="{35556854-c6c3-45e8-9e10-bd5150680fd2}"> + <item type="database-relationship" id="{67f0b7bd-a201-45d1-b18c-db46a8de0480}"> <line> <connector-list> <connector> <position> - <x>196.719</x> - <y>339.906</y> + <x>685.406</x> + <y>284.906</y> </position> <angle>0</angle> - <hub owner="{a774fcb7-1193-4b57-947c-135212695915}"/> + <hub owner="{844766fc-c5af-4f61-b51b-d3f9393c60ca}"/> </connector> <connector> <position> - <x>245</x> - <y>390.906</y> + <x>763</x> + <y>272.906</y> </position> <angle>180</angle> - <hub owner="{6ea5c997-98b5-4ec8-b63e-3f2acdcaf627}"/> + <hub owner="{fee50b4d-969b-4b5f-8545-90ea8f8f7aec}"/> </connector> </connector-list> </line> @@ -1004,24 +1010,24 @@ </columns> </relationship> </item> - <item type="database-relationship" id="{307a930b-cbe8-4000-b89d-b6cc99479b19}"> + <item type="database-relationship" id="{ab992baa-6a2c-441b-a290-da42a791eb95}"> <line> <connector-list> <connector> <position> - <x>146.146</x> - <y>287</y> + <x>647.672</x> + <y>32.9062</y> </position> - <angle>90</angle> - <hub owner="{a774fcb7-1193-4b57-947c-135212695915}"/> + <angle>0</angle> + <hub owner="{caab4a73-46dc-49dc-ac51-d8ae916827c5}"/> </connector> <connector> <position> - <x>210.151</x> - <y>221.812</y> + <x>680</x> + <y>27.9062</y> </position> - <angle>270</angle> - <hub owner="{a945e439-8796-49e8-aa9b-7ce0a58a2c26}"/> + <angle>180</angle> + <hub owner="{e84f8e5f-28e0-4d8b-a7e5-0f80a896f74e}"/> </connector> </connector-list> </line> @@ -1032,29 +1038,29 @@ <parent>Mandatory</parent> </modality> <columns> - <child>1</child> + <child>2</child> <parent>0</parent> </columns> </relationship> </item> - <item type="database-relationship" id="{40654aec-f5e1-4d82-a528-102a76a971d3}"> + <item type="database-relationship" id="{9a1b5925-a86a-470b-9c2b-3132fdcfc87e}"> <line> <connector-list> <connector> <position> - <x>133.195</x> - <y>516</y> + <x>689.109</x> + <y>89</y> </position> <angle>90</angle> - <hub owner="{04b6fdc5-85ae-4416-8db5-034ad05be93a}"/> + <hub owner="{f8caa2d5-11ba-485c-b273-8183713896bf}"/> </connector> <connector> <position> - <x>291.974</x> - <y>450.812</y> + <x>730.016</x> + <y>52.8125</y> </position> <angle>270</angle> - <hub owner="{6ea5c997-98b5-4ec8-b63e-3f2acdcaf627}"/> + <hub owner="{e84f8e5f-28e0-4d8b-a7e5-0f80a896f74e}"/> </connector> </connector-list> </line> @@ -1070,24 +1076,24 @@ </columns> </relationship> </item> - <item type="database-relationship" id="{41ee8002-8436-4c74-9f79-75b7a8b9d0bf}"> + <item type="database-relationship" id="{f26515ec-f37f-4eb3-a07f-6d5077208806}"> <line> <connector-list> <connector> <position> - <x>257.302</x> - <y>221.812</y> + <x>571.836</x> + <y>71.8125</y> </position> <angle>270</angle> - <hub owner="{a945e439-8796-49e8-aa9b-7ce0a58a2c26}"/> + <hub owner="{caab4a73-46dc-49dc-ac51-d8ae916827c5}"/> </connector> <connector> <position> - <x>291.974</x> - <y>331</y> + <x>480.719</x> + <y>86.7625</y> </position> - <angle>90</angle> - <hub owner="{6ea5c997-98b5-4ec8-b63e-3f2acdcaf627}"/> + <angle>0</angle> + <hub owner="{2e6c3b80-fef6-4d2b-8945-7ea6be1b646c}"/> </connector> </connector-list> </line> @@ -1098,29 +1104,29 @@ <parent>Mandatory</parent> </modality> <columns> - <child>4</child> + <child>1</child> <parent>0</parent> </columns> </relationship> </item> - <item type="database-relationship" id="{883853fb-bda9-450c-bde3-77422973b925}"> + <item type="database-relationship" id="{89cacf0f-5195-48db-aace-02a13aa29eee}"> <line> <connector-list> <connector> <position> - <x>379.573</x> - <y>249.812</y> + <x>611</x> + <y>120.906</y> </position> - <angle>270</angle> - <hub owner="{2e6c3b80-fef6-4d2b-8945-7ea6be1b646c}"/> + <angle>180</angle> + <hub owner="{f8caa2d5-11ba-485c-b273-8183713896bf}"/> </connector> <connector> <position> - <x>338.948</x> - <y>331</y> + <x>480.719</x> + <y>127.525</y> </position> - <angle>90</angle> - <hub owner="{6ea5c997-98b5-4ec8-b63e-3f2acdcaf627}"/> + <angle>0</angle> + <hub owner="{2e6c3b80-fef6-4d2b-8945-7ea6be1b646c}"/> </connector> </connector-list> </line> @@ -1136,24 +1142,24 @@ </columns> </relationship> </item> - <item type="database-relationship" id="{2e8b92fe-d2c0-47e0-91b6-d1667772d162}"> + <item type="database-relationship" id="{48ec4e54-ceb5-48f1-b773-9ab92f6c1c5a}"> <line> <connector-list> <connector> <position> - <x>385.922</x> - <y>390.906</y> + <x>459.531</x> + <y>537.906</y> </position> <angle>0</angle> - <hub owner="{6ea5c997-98b5-4ec8-b63e-3f2acdcaf627}"/> + <hub owner="{7c210122-c51d-4724-b7cc-22f143bc47ac}"/> </connector> <connector> <position> - <x>421</x> - <y>345.906</y> + <x>539</x> + <y>564.906</y> </position> <angle>180</angle> - <hub owner="{04f424bf-6465-478b-9529-0038615b51d9}"/> + <hub owner="{d01e6205-a6dc-4724-a1fd-d4b2f73637ea}"/> </connector> </connector-list> </line> @@ -1164,29 +1170,29 @@ <parent>Mandatory</parent> </modality> <columns> - <child>2</child> + <child>4</child> <parent>0</parent> </columns> </relationship> </item> - <item type="database-relationship" id="{1702ddc7-99c5-4af4-8731-eb8f4b6306d3}"> + <item type="database-relationship" id="{75410d72-ad2c-4357-aab5-e97f9fb74da5}"> <line> <connector-list> <connector> <position> - <x>338.948</x> - <y>450.812</y> + <x>480.719</x> + <y>209.05</y> </position> - <angle>270</angle> - <hub owner="{6ea5c997-98b5-4ec8-b63e-3f2acdcaf627}"/> + <angle>0</angle> + <hub owner="{2e6c3b80-fef6-4d2b-8945-7ea6be1b646c}"/> </connector> <connector> <position> - <x>344.266</x> - <y>487</y> + <x>600.703</x> + <y>246</y> </position> <angle>90</angle> - <hub owner="{7c210122-c51d-4724-b7cc-22f143bc47ac}"/> + <hub owner="{844766fc-c5af-4f61-b51b-d3f9393c60ca}"/> </connector> </connector-list> </line> @@ -1197,7 +1203,7 @@ <parent>Mandatory</parent> </modality> <columns> - <child>1</child> + <child>2</child> <parent>0</parent> </columns> </relationship> @@ -1235,24 +1241,24 @@ </columns> </relationship> </item> - <item type="database-relationship" id="{75410d72-ad2c-4357-aab5-e97f9fb74da5}"> + <item type="database-relationship" id="{1702ddc7-99c5-4af4-8731-eb8f4b6306d3}"> <line> <connector-list> <connector> <position> - <x>480.719</x> - <y>209.05</y> + <x>340.948</x> + <y>410.812</y> </position> - <angle>0</angle> - <hub owner="{2e6c3b80-fef6-4d2b-8945-7ea6be1b646c}"/> + <angle>270</angle> + <hub owner="{6ea5c997-98b5-4ec8-b63e-3f2acdcaf627}"/> </connector> <connector> <position> - <x>600.703</x> - <y>246</y> + <x>344.266</x> + <y>471</y> </position> <angle>90</angle> - <hub owner="{844766fc-c5af-4f61-b51b-d3f9393c60ca}"/> + <hub owner="{7c210122-c51d-4724-b7cc-22f143bc47ac}"/> </connector> </connector-list> </line> @@ -1263,29 +1269,29 @@ <parent>Mandatory</parent> </modality> <columns> - <child>2</child> + <child>1</child> <parent>0</parent> </columns> </relationship> </item> - <item type="database-relationship" id="{48ec4e54-ceb5-48f1-b773-9ab92f6c1c5a}"> + <item type="database-relationship" id="{2e8b92fe-d2c0-47e0-91b6-d1667772d162}"> <line> <connector-list> <connector> <position> - <x>459.531</x> - <y>546.906</y> + <x>387.922</x> + <y>350.906</y> </position> <angle>0</angle> - <hub owner="{7c210122-c51d-4724-b7cc-22f143bc47ac}"/> + <hub owner="{6ea5c997-98b5-4ec8-b63e-3f2acdcaf627}"/> </connector> <connector> <position> - <x>539</x> - <y>564.906</y> + <x>415</x> + <y>345.906</y> </position> <angle>180</angle> - <hub owner="{d01e6205-a6dc-4724-a1fd-d4b2f73637ea}"/> + <hub owner="{04f424bf-6465-478b-9529-0038615b51d9}"/> </connector> </connector-list> </line> @@ -1296,29 +1302,29 @@ <parent>Mandatory</parent> </modality> <columns> - <child>4</child> + <child>2</child> <parent>0</parent> </columns> </relationship> </item> - <item type="database-relationship" id="{89cacf0f-5195-48db-aace-02a13aa29eee}"> + <item type="database-relationship" id="{883853fb-bda9-450c-bde3-77422973b925}"> <line> <connector-list> <connector> <position> - <x>611</x> - <y>120.906</y> + <x>379.573</x> + <y>249.812</y> </position> - <angle>180</angle> - <hub owner="{f8caa2d5-11ba-485c-b273-8183713896bf}"/> + <angle>270</angle> + <hub owner="{2e6c3b80-fef6-4d2b-8945-7ea6be1b646c}"/> </connector> <connector> <position> - <x>480.719</x> - <y>127.525</y> + <x>340.948</x> + <y>291</y> </position> - <angle>0</angle> - <hub owner="{2e6c3b80-fef6-4d2b-8945-7ea6be1b646c}"/> + <angle>90</angle> + <hub owner="{6ea5c997-98b5-4ec8-b63e-3f2acdcaf627}"/> </connector> </connector-list> </line> @@ -1334,24 +1340,24 @@ </columns> </relationship> </item> - <item type="database-relationship" id="{f26515ec-f37f-4eb3-a07f-6d5077208806}"> + <item type="database-relationship" id="{41ee8002-8436-4c74-9f79-75b7a8b9d0bf}"> <line> <connector-list> <connector> <position> - <x>571.836</x> - <y>71.8125</y> + <x>257.302</x> + <y>221.812</y> </position> <angle>270</angle> - <hub owner="{caab4a73-46dc-49dc-ac51-d8ae916827c5}"/> + <hub owner="{a945e439-8796-49e8-aa9b-7ce0a58a2c26}"/> </connector> <connector> <position> - <x>480.719</x> - <y>86.7625</y> + <x>293.974</x> + <y>291</y> </position> - <angle>0</angle> - <hub owner="{2e6c3b80-fef6-4d2b-8945-7ea6be1b646c}"/> + <angle>90</angle> + <hub owner="{6ea5c997-98b5-4ec8-b63e-3f2acdcaf627}"/> </connector> </connector-list> </line> @@ -1362,29 +1368,29 @@ <parent>Mandatory</parent> </modality> <columns> - <child>1</child> + <child>4</child> <parent>0</parent> </columns> </relationship> </item> - <item type="database-relationship" id="{9a1b5925-a86a-470b-9c2b-3132fdcfc87e}"> + <item type="database-relationship" id="{40654aec-f5e1-4d82-a528-102a76a971d3}"> <line> <connector-list> <connector> <position> - <x>689.109</x> - <y>89</y> + <x>133.195</x> + <y>516</y> </position> <angle>90</angle> - <hub owner="{f8caa2d5-11ba-485c-b273-8183713896bf}"/> + <hub owner="{04b6fdc5-85ae-4416-8db5-034ad05be93a}"/> </connector> <connector> <position> - <x>730.016</x> - <y>52.8125</y> + <x>293.974</x> + <y>410.812</y> </position> <angle>270</angle> - <hub owner="{e84f8e5f-28e0-4d8b-a7e5-0f80a896f74e}"/> + <hub owner="{6ea5c997-98b5-4ec8-b63e-3f2acdcaf627}"/> </connector> </connector-list> </line> @@ -1400,24 +1406,24 @@ </columns> </relationship> </item> - <item type="database-relationship" id="{ab992baa-6a2c-441b-a290-da42a791eb95}"> + <item type="database-relationship" id="{307a930b-cbe8-4000-b89d-b6cc99479b19}"> <line> <connector-list> <connector> <position> - <x>647.672</x> - <y>32.9062</y> + <x>146.146</x> + <y>287</y> </position> - <angle>0</angle> - <hub owner="{caab4a73-46dc-49dc-ac51-d8ae916827c5}"/> + <angle>90</angle> + <hub owner="{a774fcb7-1193-4b57-947c-135212695915}"/> </connector> <connector> <position> - <x>680</x> - <y>27.9062</y> + <x>210.151</x> + <y>221.812</y> </position> - <angle>180</angle> - <hub owner="{e84f8e5f-28e0-4d8b-a7e5-0f80a896f74e}"/> + <angle>270</angle> + <hub owner="{a945e439-8796-49e8-aa9b-7ce0a58a2c26}"/> </connector> </connector-list> </line> @@ -1428,29 +1434,29 @@ <parent>Mandatory</parent> </modality> <columns> - <child>2</child> + <child>1</child> <parent>0</parent> </columns> </relationship> </item> - <item type="database-relationship" id="{67f0b7bd-a201-45d1-b18c-db46a8de0480}"> + <item type="database-relationship" id="{35556854-c6c3-45e8-9e10-bd5150680fd2}"> <line> <connector-list> <connector> <position> - <x>685.406</x> - <y>284.906</y> + <x>196.719</x> + <y>339.906</y> </position> <angle>0</angle> - <hub owner="{844766fc-c5af-4f61-b51b-d3f9393c60ca}"/> + <hub owner="{a774fcb7-1193-4b57-947c-135212695915}"/> </connector> <connector> <position> - <x>763</x> - <y>272.906</y> + <x>247</x> + <y>350.906</y> </position> <angle>180</angle> - <hub owner="{fee50b4d-969b-4b5f-8545-90ea8f8f7aec}"/> + <hub owner="{6ea5c997-98b5-4ec8-b63e-3f2acdcaf627}"/> </connector> </connector-list> </line> @@ -1466,24 +1472,24 @@ </columns> </relationship> </item> - <item type="database-relationship" id="{d3ded37c-70d5-4388-8e27-2329f59a1d9c}"> + <item type="database-relationship" id="{65ace480-001e-4e4e-912d-2a975ff995c8}"> <line> <connector-list> <connector> <position> - <x>496</x> - <y>32.9062</y> + <x>95.5729</x> + <y>287</y> </position> - <angle>180</angle> - <hub owner="{caab4a73-46dc-49dc-ac51-d8ae916827c5}"/> + <angle>90</angle> + <hub owner="{a774fcb7-1193-4b57-947c-135212695915}"/> </connector> <connector> <position> - <x>284.844</x> - <y>30.9062</y> + <x>100.719</x> + <y>180.812</y> </position> - <angle>0</angle> - <hub owner="{be821d83-a9b4-4c0c-8e1b-433730200714}"/> + <angle>270</angle> + <hub owner="{7b159780-7f39-45a7-9557-046874a57e43}"/> </connector> </connector-list> </line> @@ -1494,29 +1500,29 @@ <parent>Mandatory</parent> </modality> <columns> - <child>3</child> + <child>4</child> <parent>0</parent> </columns> </relationship> </item> - <item type="database-relationship" id="{c54c97e3-dd0a-4b21-9eeb-708d5b492e2a}"> + <item type="database-relationship" id="{8f5f94cd-2919-43f6-ae67-6b783850a2e7}"> <line> <connector-list> <connector> <position> - <x>430.146</x> - <y>249.812</y> + <x>816.656</x> + <y>399</y> </position> - <angle>270</angle> - <hub owner="{2e6c3b80-fef6-4d2b-8945-7ea6be1b646c}"/> + <angle>90</angle> + <hub owner="{92f54126-a433-458e-80b7-67235e560334}"/> </connector> <connector> <position> - <x>468.273</x> - <y>321</y> + <x>815.635</x> + <y>304.812</y> </position> - <angle>90</angle> - <hub owner="{04f424bf-6465-478b-9529-0038615b51d9}"/> + <angle>270</angle> + <hub owner="{fee50b4d-969b-4b5f-8545-90ea8f8f7aec}"/> </connector> </connector-list> </line> @@ -1527,29 +1533,29 @@ <parent>Mandatory</parent> </modality> <columns> - <child>11</child> + <child>1</child> <parent>0</parent> </columns> </relationship> </item> - <item type="database-relationship" id="{4b0f5386-c5f6-4fa4-9c78-f0d85410c366}"> + <item type="database-relationship" id="{fa899065-104a-466d-bc8c-16589a774a45}"> <line> <connector-list> <connector> <position> - <x>638.51</x> - <y>395</y> + <x>879.312</x> + <y>399</y> </position> <angle>90</angle> - <hub owner="{d823ab09-1c04-44ee-ad4b-6802208967ff}"/> + <hub owner="{92f54126-a433-458e-80b7-67235e560334}"/> </connector> <connector> <position> - <x>628.938</x> - <y>323.812</y> + <x>868.271</x> + <y>304.812</y> </position> <angle>270</angle> - <hub owner="{844766fc-c5af-4f61-b51b-d3f9393c60ca}"/> + <hub owner="{fee50b4d-969b-4b5f-8545-90ea8f8f7aec}"/> </connector> </connector-list> </line> @@ -1565,57 +1571,57 @@ </columns> </relationship> </item> - <item type="database-relationship" id="{6094d4c4-439f-4e6c-94e1-736ae145362a}"> + <item type="database-relationship" id="{e64f4d17-ff78-45f2-ab9b-281bf8fc5fb6}"> <line> <connector-list> <connector> <position> - <x>559.755</x> - <y>395</y> + <x>864</x> + <y>131</y> </position> <angle>90</angle> - <hub owner="{d823ab09-1c04-44ee-ad4b-6802208967ff}"/> + <hub owner="{457d2e44-2570-45c8-b93e-7b335efd0483}"/> </connector> <connector> <position> - <x>572.469</x> - <y>323.812</y> + <x>871.711</x> + <y>97.8125</y> </position> <angle>270</angle> - <hub owner="{844766fc-c5af-4f61-b51b-d3f9393c60ca}"/> + <hub owner="{f24a3299-870d-4312-8dbe-50b3bf1953d3}"/> </connector> </connector-list> </line> <relationship> <cardinality>OneToMany</cardinality> <modality> - <child>Mandatory</child> - <parent>Mandatory</parent> + <child>Optional</child> + <parent>Optional</parent> </modality> <columns> - <child>1</child> + <child>2</child> <parent>0</parent> </columns> </relationship> </item> - <item type="database-relationship" id="{30efa4b2-f4e7-4c8d-943e-44c699e54853}"> + <item type="database-relationship" id="{4a844898-e05d-4919-8c83-cf90f28edf42}"> <line> <connector-list> <connector> <position> - <x>599.133</x> - <y>472.812</y> + <x>796</x> + <y>169.906</y> </position> - <angle>270</angle> - <hub owner="{d823ab09-1c04-44ee-ad4b-6802208967ff}"/> + <angle>180</angle> + <hub owner="{457d2e44-2570-45c8-b93e-7b335efd0483}"/> </connector> <connector> <position> - <x>613.727</x> - <y>533</y> + <x>480.719</x> + <y>168.288</y> </position> - <angle>90</angle> - <hub owner="{d01e6205-a6dc-4724-a1fd-d4b2f73637ea}"/> + <angle>0</angle> + <hub owner="{2e6c3b80-fef6-4d2b-8945-7ea6be1b646c}"/> </connector> </connector-list> </line> @@ -1626,7 +1632,7 @@ <parent>Mandatory</parent> </modality> <columns> - <child>3</child> + <child>1</child> <parent>0</parent> </columns> </relationship> |