diff options
| author | Erich Eckner <git@eckner.net> | 2019-06-18 10:34:06 +0200 |
|---|---|---|
| committer | Erich Eckner <git@eckner.net> | 2019-06-18 10:34:06 +0200 |
| commit | 309a37a0c59471c3f1848493986ea0c1d887342d (patch) | |
| tree | be6dd539c397c886431071edbdc1d39d890e97e0 /misc | |
| parent | 12d64e647adc61f986923c122972ca17380771da (diff) | |
| download | builder-309a37a0c59471c3f1848493986ea0c1d887342d.tar.xz | |
misc/database-layout.dump: add some keys
Diffstat (limited to 'misc')
| -rw-r--r-- | misc/database-layout.dump | 7 |
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'), |