summaryrefslogtreecommitdiff
path: root/misc
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2018-06-15 11:30:00 +0200
committerErich Eckner <git@eckner.net>2018-06-15 11:35:35 +0200
commit8a253e4c6d7ce231c6d600669e3b2ff8d94dfadd (patch)
tree1051e7794e462f9e0acd924ff81dd67ff9384ff3 /misc
parent981f18f8bb89708d9efa4b06dbb2402fa26821fa (diff)
downloadbuilder-8a253e4c6d7ce231c6d600669e3b2ff8d94dfadd.tar.xz
new table `mirror_statuses`
Diffstat (limited to 'misc')
-rw-r--r--misc/database-layout.dmf172
-rw-r--r--misc/database-layout.dump15
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,