diff options
| author | Erich Eckner <git@eckner.net> | 2019-07-15 12:15:34 +0200 |
|---|---|---|
| committer | Erich Eckner <git@eckner.net> | 2019-07-15 12:15:34 +0200 |
| commit | a80cb33621fbf37a64fe39b550ae25088588149c (patch) | |
| tree | 129530d39e92f509e6963aaa2057f99e4b2dadca /misc | |
| parent | 62695b4e92f953fd040697259ac7a5225696c576 (diff) | |
| download | builder-a80cb33621fbf37a64fe39b550ae25088588149c.tar.xz | |
misc/database-layout: new columns "exit_code" and "duration" in "ssh_log"
Diffstat (limited to 'misc')
| -rw-r--r-- | misc/database-layout.dmf | 38 | ||||
| -rw-r--r-- | 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` ( |