From 1057764d68f13ad3f09d58c249fcee644a8d5850 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Tue, 6 Aug 2019 10:14:27 +0200 Subject: misc/database-layout.dump: optimize indices --- misc/database-layout.dump | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'misc') 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` ( -- cgit v1.2.3-70-g09d2