From 331e7dca60916e65188060ad2a612c8341b69453 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Fri, 15 Jun 2018 12:07:31 +0200 Subject: misc/database-layout.dump: more keys --- misc/database-layout.dump | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'misc') diff --git a/misc/database-layout.dump b/misc/database-layout.dump index 6aa09cb..a4eb3ff 100644 --- a/misc/database-layout.dump +++ b/misc/database-layout.dump @@ -588,7 +588,9 @@ mirror_statuses CREATE TABLE `mirror_statuses` ( `ipv4` bit(1) NOT NULL, `ipv6` bit(1) NOT NULL, `active` bit(1) NOT NULL, - PRIMARY KEY (`id`) + PRIMARY KEY (`id`), + KEY `url` (`url`), + KEY `start` (`start`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci package_sources CREATE TABLE `package_sources` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, -- cgit v1.2.3-54-g00ecf