From ce2e58b6bcdef7616d5426f3310ab09cdea92f32 Mon Sep 17 00:00:00 2001
From: Přemysl Eric Janouch <p@janouch.name>
Date: Sun, 29 Dec 2024 13:41:07 +0100
Subject: Fix extremely slow removals

---
 initialize.sql | 1 +
 1 file changed, 1 insertion(+)

(limited to 'initialize.sql')

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);
 
-- 
cgit v1.2.3-70-g09d2

