From a80cb33621fbf37a64fe39b550ae25088588149c Mon Sep 17 00:00:00 2001
From: Erich Eckner <git@eckner.net>
Date: Mon, 15 Jul 2019 12:15:34 +0200
Subject: misc/database-layout: new columns "exit_code" and "duration" in
 "ssh_log"

---
 misc/database-layout.dmf  | 38 +++++++++++++++++++++++++-------------
 misc/database-layout.dump |  3 +++
 2 files changed, 28 insertions(+), 13 deletions(-)

diff --git a/misc/database-layout.dmf b/misc/database-layout.dmf
index ddcd1dd..e0d70e4 100644
--- a/misc/database-layout.dmf
+++ b/misc/database-layout.dmf
@@ -287,6 +287,18 @@
             <required>True</required>
             <primary-key>False</primary-key>
           </column>
+          <column>
+            <name>duration</name>
+            <data-type>MEDIUMINT</data-type>
+            <required>False</required>
+            <primary-key>False</primary-key>
+          </column>
+          <column>
+            <name>exit_code</name>
+            <data-type>MEDIUMINT</data-type>
+            <required>False</required>
+            <primary-key>False</primary-key>
+          </column>
         </column-list>
       </table>
     </item>
@@ -964,8 +976,8 @@
     </item>
     <item id="{a774fcb7-1193-4b57-947c-135212695915}" type="database-table">
       <position>
-        <x>-19</x>
-        <y>365</y>
+        <x>-22</x>
+        <y>374</y>
       </position>
       <table>
         <name>failed_builds</name>
@@ -1018,8 +1030,8 @@
     </item>
     <item id="{7b159780-7f39-45a7-9557-046874a57e43}" type="database-table">
       <position>
-        <x>-53</x>
-        <y>240</y>
+        <x>-43</x>
+        <y>267</y>
       </position>
       <table>
         <name>fail_reasons</name>
@@ -1850,7 +1862,7 @@
           <connector>
             <position>
               <x>59.5313</x>
-              <y>180.406</y>
+              <y>194.406</y>
             </position>
             <angle>0</angle>
             <hub owner="{5f12db03-a8bb-4467-bab6-a57e545b9081}"/>
@@ -2344,8 +2356,8 @@
         <connector-list>
           <connector>
             <position>
-              <x>82.1458</x>
-              <y>365</y>
+              <x>79.1458</x>
+              <y>374</y>
             </position>
             <angle>90</angle>
             <hub owner="{a774fcb7-1193-4b57-947c-135212695915}"/>
@@ -2377,8 +2389,8 @@
         <connector-list>
           <connector>
             <position>
-              <x>132.719</x>
-              <y>425.406</y>
+              <x>129.719</x>
+              <y>434.406</y>
             </position>
             <angle>0</angle>
             <hub owner="{a774fcb7-1193-4b57-947c-135212695915}"/>
@@ -2410,16 +2422,16 @@
         <connector-list>
           <connector>
             <position>
-              <x>31.5729</x>
-              <y>365</y>
+              <x>28.5729</x>
+              <y>374</y>
             </position>
             <angle>90</angle>
             <hub owner="{a774fcb7-1193-4b57-947c-135212695915}"/>
           </connector>
           <connector>
             <position>
-              <x>-5.0625</x>
-              <y>318.813</y>
+              <x>4.9375</x>
+              <y>345.813</y>
             </position>
             <angle>270</angle>
             <hub owner="{7b159780-7f39-45a7-9557-046874a57e43}"/>
diff --git a/misc/database-layout.dump b/misc/database-layout.dump
index 309e9e1..f952681 100644
--- a/misc/database-layout.dump
+++ b/misc/database-layout.dump
@@ -833,9 +833,12 @@ ssh_log	CREATE TABLE `ssh_log` (
 	 `build_slave` mediumint(9) DEFAULT NULL,
 	 `action` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
 	 `parameters` text COLLATE utf8mb4_unicode_ci NOT NULL,
+	 `exit_code` mediumint(9) DEFAULT NULL,
+	 `duration` mediumint(9) DEFAULT NULL,
 	 PRIMARY KEY (`id`),
 	 KEY `build_slave` (`build_slave`),
 	 KEY `date` (`date`),
+	 KEY `exit_code` (`exit_code`),
 	 CONSTRAINT `ssh_log_ibfk_1` FOREIGN KEY (`build_slave`) REFERENCES `build_slaves` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
 statistics	CREATE TABLE `statistics` (
-- 
cgit v1.2.3-70-g09d2