diff options
author | morkt <> | 2015-01-17 10:45:41 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2015-01-17 10:45:41 +0100 |
commit | 5bc52fc618cf200e82d320987a6c6829cf67bf1d (patch) | |
tree | 971a2df28615d0f575dfbc0b7c66eb5ae73b273d /util | |
parent | 1cc4307e0097877f0e2a26c03c372651a4eb88f4 (diff) |
staff: Fix search to ignore spaces in Japanese names
Diffstat (limited to 'util')
-rw-r--r-- | util/sql/staff.sql | 1 |
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(); |