staff: Fix search to ignore spaces in Japanese names

1 files changed, 1 insertions, 0 deletions

diff --git a/util/sql/staff.sql b/util/sql/staff.sql
index cf452bcc..972765ea 100644
--- a/util/sql/staff.sql
+++ b/util/sql/staff.sql
@@ -59,6 +59,7 @@ ALTER TABLE vn_seiyuu           ADD FOREIGN KEY (vid)       REFERENCES vn_rev
 
 CREATE INDEX vn_staff_vid       ON vn_staff (vid);
 CREATE INDEX vn_staff_aid       ON vn_staff (aid);
+CREATE INDEX staff_alias_orig   ON staff_alias (translate(original,' ',''));
 
 CREATE TRIGGER hidlock_update             BEFORE UPDATE           ON staff         FOR EACH ROW WHEN (OLD.latest IS DISTINCT FROM NEW.latest) EXECUTE PROCEDURE update_hidlock();