misc/database-layout.dump: add some keys

1 files changed, 6 insertions, 1 deletions

diff --git a/misc/database-layout.dump b/misc/database-layout.dump
index 95336c8..698a158 100644
--- a/misc/database-layout.dump
+++ b/misc/database-layout.dump
@@ -551,6 +551,9 @@ binary_packages	CREATE TABLE `binary_packages` (
 	 UNIQUE KEY `file_name` (`pkgname`,`epoch`,`pkgver`,`pkgrel`,`sub_pkgrel`,`architecture`),
 	 UNIQUE KEY `content` (`build_assignment`,`sub_pkgrel`,`pkgname`,`architecture`),
 	 KEY `architecture` (`architecture`),
+	 KEY `epoch` (`epoch`),
+	 KEY `pkgver` (`pkgver`),
+	 KEY `pkgname` (`pkgname`),
 	 CONSTRAINT `binary_packages_ibfk_1` FOREIGN KEY (`architecture`) REFERENCES `architectures` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
 	 CONSTRAINT `binary_packages_ibfk_2` FOREIGN KEY (`build_assignment`) REFERENCES `build_assignments` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
@@ -888,7 +891,9 @@ versions	CREATE TABLE `versions` (
 	 `version` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 	 PRIMARY KEY (`id`),
 	 UNIQUE KEY `content` (`epoch`,`version`),
-	 KEY `order` (`order`)
+	 KEY `order` (`order`),
+	 KEY `epoch` (`epoch`),
+	 KEY `pkgver` (`version`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
 INSERT INTO `architectures` VALUES
   (1,'any'),