Send patches - preferably formatted by git format-patch - to patches at archlinux32 dot org.
summaryrefslogtreecommitdiff
path: root/misc
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2019-07-15 12:15:34 +0200
committerErich Eckner <git@eckner.net>2019-07-15 12:15:34 +0200
commita80cb33621fbf37a64fe39b550ae25088588149c (patch)
tree129530d39e92f509e6963aaa2057f99e4b2dadca /misc
parent62695b4e92f953fd040697259ac7a5225696c576 (diff)
misc/database-layout: new columns "exit_code" and "duration" in "ssh_log"
Diffstat (limited to 'misc')
-rw-r--r--misc/database-layout.dmf38
-rw-r--r--misc/database-layout.dump3
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` (