X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=dak%2Fdakdb%2Fupdate23.py;h=5fa8a64358be455ae63fc84307f6c3df82b9e4be;hb=1b64c8e3ac85284f8ecac62881390a402116898d;hp=708011cf5257f2b496a3be74541df96d105d75e1;hpb=7333364972038701fade2f7e9ccdd3a057e55606;p=dak.git

diff --git a/dak/dakdb/update23.py b/dak/dakdb/update23.py
index 708011cf..5fa8a643 100644
--- a/dak/dakdb/update23.py
+++ b/dak/dakdb/update23.py
@@ -227,6 +227,10 @@ $$ LANGUAGE plpythonu VOLATILE SECURITY DEFINER;
                       AFTER UPDATE ON override
                       FOR EACH ROW EXECUTE PROCEDURE update_contents_for_override();""")
 
+
+        c.execute( "CREATE INDEX ind_deb_contents_name ON deb_contents(package);");
+        c.execute( "CREATE INDEX ind_udeb_contents_name ON udeb_contents(package);");
+
         self.db.commit()
 
     except psycopg2.ProgrammingError, msg: