# HG changeset patch
# User Pierre-Yves David <pierre-yves.david@octobus.net>
# Date 1513826942 -3600
# Node ID 24b72cbc486f06656b20040c91963ca90d630c6a
# Parent  c261eece1eab17c0932ba6d59b6996c05bcf8559
stablerange: add an sql index on subranges id too

This should speed up query that find super ranges.

diff -r c261eece1eab -r 24b72cbc486f hgext3rd/evolve/stablerangecache.py
--- a/hgext3rd/evolve/stablerangecache.py	Thu Dec 21 04:14:05 2017 +0100
+++ b/hgext3rd/evolve/stablerangecache.py	Thu Dec 21 04:29:02 2017 +0100
@@ -94,6 +94,7 @@
                               FOREIGN KEY (subrev, subidx) REFERENCES range(rev, idx)
     );""",
     "CREATE INDEX subranges_index ON subranges (suprev, supidx);",
+    "CREATE INDEX superranges_index ON subranges (subrev, subidx);",
     "CREATE INDEX range_index ON range (rev, idx);",
 ]
 _newmeta = "INSERT INTO meta (schemaversion, tiprev, tipnode) VALUES (?,?,?);"