summaryrefslogtreecommitdiff
path: root/misc
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2018-09-28 11:48:02 +0200
committerErich Eckner <git@eckner.net>2018-09-28 11:48:02 +0200
commita52c4adef7a061e48449b940e4444a017715b3aa (patch)
treecd98f80fc0ad22dbb53eab4954b9c12bada59bb7 /misc
parent6cc265f6ddbbb4f288fdfeae6933a1873e1e58ad (diff)
downloadbuilder-a52c4adef7a061e48449b940e4444a017715b3aa.tar.xz
misc/database-layout.dump: add a key on `ssh_logs`.`date`
Diffstat (limited to 'misc')
-rw-r--r--misc/database-layout.dump1
1 files changed, 1 insertions, 0 deletions
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` (