From a52c4adef7a061e48449b940e4444a017715b3aa Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Fri, 28 Sep 2018 11:48:02 +0200 Subject: misc/database-layout.dump: add a key on `ssh_logs`.`date` --- misc/database-layout.dump | 1 + 1 file changed, 1 insertion(+) (limited to 'misc/database-layout.dump') diff --git a/misc/database-layout.dump b/misc/database-layout.dump index 9b80638..010fdfd 100644 --- a/misc/database-layout.dump +++ b/misc/database-layout.dump @@ -874,6 +874,7 @@ ssh_log CREATE TABLE `ssh_log` ( `parameters` text COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), KEY `build_slave` (`build_slave`), + KEY `date` (`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