sync

[dak.git] / init_pool.sql

diff --git a/init_pool.sql b/init_pool.sql
index 0423c068927b3137b8cebf96ffa9750d02b0190f..2eb3d2ec7cebd6313976c25144c30d89ebffffaf 100644 (file)
--- a/init_pool.sql
+++ b/init_pool.sql
@@ -150,4 +150,6 @@ CREATE INDEX bin_associations_bin ON bin_associations (bin);
 CREATE INDEX src_associations_source ON src_associations (source);
 CREATE INDEX source_maintainer ON source (maintainer);
 CREATE INDEX binaries_maintainer ON binaries (maintainer);
+CREATE INDEX binaries_fingerprint on binaries (sig_fpr);
+CREATE INDEX source_fingerprint on source (sig_fpr);
 CREATE INDEX dsc_files_file ON dsc_files (file);