summaryrefslogtreecommitdiff
path: root/misc
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2019-06-18 10:34:06 +0200
committerErich Eckner <git@eckner.net>2019-06-18 10:34:06 +0200
commit309a37a0c59471c3f1848493986ea0c1d887342d (patch)
treebe6dd539c397c886431071edbdc1d39d890e97e0 /misc
parent12d64e647adc61f986923c122972ca17380771da (diff)
downloadbuilder-309a37a0c59471c3f1848493986ea0c1d887342d.tar.xz
misc/database-layout.dump: add some keys
Diffstat (limited to 'misc')
-rw-r--r--misc/database-layout.dump7
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'),