From 8a253e4c6d7ce231c6d600669e3b2ff8d94dfadd Mon Sep 17 00:00:00 2001
From: Erich Eckner <git@eckner.net>
Date: Fri, 15 Jun 2018 11:30:00 +0200
Subject: new table `mirror_statuses`

---
 misc/database-layout.dmf  | 172 ++++++++++++++++++++++++++++++++++------------
 misc/database-layout.dump |  15 ++++
 2 files changed, 143 insertions(+), 44 deletions(-)

(limited to 'misc')

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,
-- 
cgit v1.2.3-70-g09d2