summaryrefslogtreecommitdiff
path: root/misc/database-layout.dump
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2019-08-06 10:14:27 +0200
committerErich Eckner <git@eckner.net>2019-08-06 10:14:27 +0200
commit1057764d68f13ad3f09d58c249fcee644a8d5850 (patch)
treec3d3e1fab41ff8fccfc6bbf0c7524b51cf0e50e7 /misc/database-layout.dump
parentc16825172d6c970deb565c0c885b66995381ddc4 (diff)
downloadbuilder-1057764d68f13ad3f09d58c249fcee644a8d5850.tar.xz
misc/database-layout.dump: optimize indices
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` (