diff options
| -rw-r--r-- | misc/database-layout.dmf | 172 | ||||
| -rw-r--r-- | misc/database-layout.dump | 15 |
2 files changed, 143 insertions, 44 deletions
diff --git a/misc/database-layout.dmf b/misc/database-layout.dmf index e9fdc88..14c5710 100644 --- a/misc/database-layout.dmf +++ b/misc/database-layout.dmf @@ -142,8 +142,8 @@ </item> <item type="database-table" id="{d823ab09-1c04-44ee-ad4b-6802208967ff}"> <position> - <x>585</x> - <y>455</y> + <x>492</x> + <y>459</y> </position> <table> <name>repository_moves</name> @@ -178,8 +178,8 @@ </item> <item type="database-table" id="{fee50b4d-969b-4b5f-8545-90ea8f8f7aec}"> <position> - <x>856</x> - <y>280</y> + <x>770</x> + <y>345</y> </position> <table> <name>repository_stabilities</name> @@ -448,8 +448,8 @@ </item> <item type="database-table" id="{b3c86235-971a-4d3e-873c-c4179aa96cbc}"> <position> - <x>906</x> - <y>532</y> + <x>803</x> + <y>533</y> </position> <table> <name>git_repositories</name> @@ -490,8 +490,8 @@ </item> <item type="database-table" id="{844766fc-c5af-4f61-b51b-d3f9393c60ca}"> <position> - <x>625</x> - <y>307</y> + <x>566</x> + <y>299</y> </position> <table> <name>repositories</name> @@ -856,8 +856,8 @@ </item> <item type="database-table" id="{92f54126-a433-458e-80b7-67235e560334}"> <position> - <x>844</x> - <y>427</y> + <x>756</x> + <y>452</y> </position> <table> <name>repository_stability_relations</name> @@ -1174,8 +1174,8 @@ </item> <item type="database-table" id="{3d2d24a7-42f1-4c59-9cb3-a8d8478ac4a8}"> <position> - <x>360</x> - <y>400</y> + <x>375</x> + <y>369</y> </position> <table> <name>architecture_compatibilities</name> @@ -1208,6 +1208,90 @@ </column-list> </table> </item> + <item type="database-table" id="{bb59ebca-0255-40dd-91b4-68bd2e110447}"> + <position> + <x>952</x> + <y>253</y> + </position> + <table> + <name>mirror_statuses</name> + <color>#ffffff</color> + <column-list> + <column> + <name>id</name> + <data-type>BIGINT</data-type> + <required>True</required> + <primary-key>True</primary-key> + </column> + <column> + <name>protocol</name> + <data-type>VARCHAR(8)</data-type> + <required>True</required> + <primary-key>False</primary-key> + </column> + <column> + <name>url</name> + <data-type>VARCHAR(128)</data-type> + <required>True</required> + <primary-key>False</primary-key> + </column> + <column> + <name>country</name> + <data-type>VARCHAR(64)</data-type> + <required>True</required> + <primary-key>False</primary-key> + </column> + <column> + <name>country_code</name> + <data-type>VARCHAR(4)</data-type> + <required>True</required> + <primary-key>False</primary-key> + </column> + <column> + <name>last_sync</name> + <data-type>BIGINT</data-type> + <required>True</required> + <primary-key>False</primary-key> + </column> + <column> + <name>start</name> + <data-type>FLOAT</data-type> + <required>True</required> + <primary-key>False</primary-key> + </column> + <column> + <name>stop</name> + <data-type>FLOAT</data-type> + <required>True</required> + <primary-key>False</primary-key> + </column> + <column> + <name>isos</name> + <data-type>BIT</data-type> + <required>True</required> + <primary-key>False</primary-key> + </column> + <column> + <name>ipv4</name> + <data-type>BIT</data-type> + <required>True</required> + <primary-key>False</primary-key> + </column> + <column> + <name>ipv6</name> + <data-type>BIT</data-type> + <required>True</required> + <primary-key>False</primary-key> + </column> + <column> + <name>active</name> + <data-type>BIT</data-type> + <required>True</required> + <primary-key>False</primary-key> + </column> + </column-list> + </table> + </item> <item type="database-relationship" id="{0213a360-5a3b-484f-82c7-320003506c8a}"> <line> <connector-list> @@ -1221,8 +1305,8 @@ </connector> <connector> <position> - <x>709.703</x> - <y>307</y> + <x>650.703</x> + <y>299</y> </position> <angle>90</angle> <hub owner="{844766fc-c5af-4f61-b51b-d3f9393c60ca}"/> @@ -1312,8 +1396,8 @@ <connector-list> <connector> <position> - <x>703.133</x> - <y>532.812</y> + <x>610.133</x> + <y>536.812</y> </position> <angle>270</angle> <hub owner="{d823ab09-1c04-44ee-ad4b-6802208967ff}"/> @@ -1345,16 +1429,16 @@ <connector-list> <connector> <position> - <x>663.755</x> - <y>455</y> + <x>649.51</x> + <y>459</y> </position> <angle>90</angle> <hub owner="{d823ab09-1c04-44ee-ad4b-6802208967ff}"/> </connector> <connector> <position> - <x>681.469</x> - <y>398.812</y> + <x>678.938</x> + <y>390.812</y> </position> <angle>270</angle> <hub owner="{844766fc-c5af-4f61-b51b-d3f9393c60ca}"/> @@ -1378,16 +1462,16 @@ <connector-list> <connector> <position> - <x>742.51</x> - <y>455</y> + <x>570.755</x> + <y>459</y> </position> <angle>90</angle> <hub owner="{d823ab09-1c04-44ee-ad4b-6802208967ff}"/> </connector> <connector> <position> - <x>737.938</x> - <y>398.812</y> + <x>622.469</x> + <y>390.812</y> </position> <angle>270</angle> <hub owner="{844766fc-c5af-4f61-b51b-d3f9393c60ca}"/> @@ -1477,16 +1561,16 @@ <connector-list> <connector> <position> - <x>794.406</x> - <y>352.906</y> + <x>735.406</x> + <y>344.906</y> </position> <angle>0</angle> <hub owner="{844766fc-c5af-4f61-b51b-d3f9393c60ca}"/> </connector> <connector> <position> - <x>856</x> - <y>311.906</y> + <x>770</x> + <y>376.906</y> </position> <angle>180</angle> <hub owner="{fee50b4d-969b-4b5f-8545-90ea8f8f7aec}"/> @@ -1683,8 +1767,8 @@ </connector> <connector> <position> - <x>906</x> - <y>577.906</y> + <x>803</x> + <y>578.906</y> </position> <angle>180</angle> <hub owner="{b3c86235-971a-4d3e-873c-c4179aa96cbc}"/> @@ -1972,16 +2056,16 @@ <connector-list> <connector> <position> - <x>906.656</x> - <y>427</y> + <x>818.656</x> + <y>452</y> </position> <angle>90</angle> <hub owner="{92f54126-a433-458e-80b7-67235e560334}"/> </connector> <connector> <position> - <x>908.635</x> - <y>343.812</y> + <x>822.635</x> + <y>408.812</y> </position> <angle>270</angle> <hub owner="{fee50b4d-969b-4b5f-8545-90ea8f8f7aec}"/> @@ -2005,16 +2089,16 @@ <connector-list> <connector> <position> - <x>969.312</x> - <y>427</y> + <x>881.312</x> + <y>452</y> </position> <angle>90</angle> <hub owner="{92f54126-a433-458e-80b7-67235e560334}"/> </connector> <connector> <position> - <x>961.271</x> - <y>343.812</y> + <x>875.271</x> + <y>408.812</y> </position> <angle>270</angle> <hub owner="{fee50b4d-969b-4b5f-8545-90ea8f8f7aec}"/> @@ -2335,8 +2419,8 @@ <connector-list> <connector> <position> - <x>625</x> - <y>352.906</y> + <x>566</x> + <y>344.906</y> </position> <angle>180</angle> <hub owner="{844766fc-c5af-4f61-b51b-d3f9393c60ca}"/> @@ -2368,8 +2452,8 @@ <connector-list> <connector> <position> - <x>481.427</x> - <y>400</y> + <x>496.427</x> + <y>369</y> </position> <angle>90</angle> <hub owner="{3d2d24a7-42f1-4c59-9cb3-a8d8478ac4a8}"/> @@ -2401,8 +2485,8 @@ <connector-list> <connector> <position> - <x>420.714</x> - <y>400</y> + <x>435.714</x> + <y>369</y> </position> <angle>90</angle> <hub owner="{3d2d24a7-42f1-4c59-9cb3-a8d8478ac4a8}"/> diff --git a/misc/database-layout.dump b/misc/database-layout.dump index d84af0d..6aa09cb 100644 --- a/misc/database-layout.dump +++ b/misc/database-layout.dump @@ -575,6 +575,21 @@ install_targets CREATE TABLE `install_targets` ( PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci +mirror_statuses CREATE TABLE `mirror_statuses` ( + `id` bigint(20) NOT NULL AUTO_INCREMENT, + `protocol` varchar(8) COLLATE utf8mb4_unicode_ci NOT NULL, + `url` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL, + `country` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, + `country_code` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, + `last_sync` bigint(20) NOT NULL, + `start` float NOT NULL, + `stop` float NOT NULL, + `isos` bit(1) NOT NULL, + `ipv4` bit(1) NOT NULL, + `ipv6` bit(1) NOT NULL, + `active` bit(1) NOT NULL, + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci package_sources CREATE TABLE `package_sources` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `pkgbase` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, |