summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2010-12-14 12:30:26 +0100
committerYorhel <git@yorhel.nl>2010-12-14 12:30:26 +0100
commit442779dcbba94090616c8291c307626a4bd56448 (patch)
tree67872964d89fa3a0df14ea4591e934c14e4db43c /util
parent8b5b3736ad90358c4c4eb60aea429f5566553a85 (diff)
VNDBUtil: Consider "senpai" and "sempai" the same in the VN search
Diffstat (limited to 'util')
-rw-r--r--util/updates/update_2.15.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/util/updates/update_2.15.sql b/util/updates/update_2.15.sql
index 75961785..720254d0 100644
--- a/util/updates/update_2.15.sql
+++ b/util/updates/update_2.15.sql
@@ -5,3 +5,7 @@ ALTER TABLE tags_vn ADD COLUMN date timestamptz NOT NULL DEFAULT NOW();
-- this index is essential, quite often sorted on
CREATE INDEX tags_vn_date ON tags_vn (date);
+
+-- VNDBUtil::normalize() has been modified, so update search cache
+UPDATE vn SET c_search = NULL;
+