misc/database-layout.dump: optimize indices

1 files changed, 2 insertions, 2 deletions

diff --git a/misc/database-layout.dump b/misc/database-layout.dump
index fb793ac..d4f4283 100644
--- a/misc/database-layout.dump
+++ b/misc/database-layout.dump
@@ -837,9 +837,9 @@ ssh_log	CREATE TABLE `ssh_log` (
 	 `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`),
+	 KEY `ssh_log_build_slave_date_idx` (`build_slave`,`date`),
+	 KEY `ssh_log_date_idx` (`date`),
 	 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` (