summaryrefslogtreecommitdiff
path: root/misc/database-layout.dump
diff options
context:
space:
mode:
Diffstat (limited to 'misc/database-layout.dump')
-rw-r--r--misc/database-layout.dump4
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` (