1 files changed, 1 insertions, 0 deletions
diff --git a/initialize.sql b/initialize.sql
index 292c50b..436d34f 100644
--- a/initialize.sql
+++ b/initialize.sql
@@ -23,6 +23,7 @@ CREATE TABLE IF NOT EXISTS node(
 ) STRICT;
 
 CREATE INDEX IF NOT EXISTS node__sha1 ON node(sha1);
+CREATE INDEX IF NOT EXISTS node__parent ON node(parent);
 CREATE UNIQUE INDEX IF NOT EXISTS node__parent_name
 ON node(IFNULL(parent, 0), name);