diff options
-rw-r--r-- | ChangeLog | 1 | ||||
-rw-r--r-- | Makefile | 4 | ||||
-rw-r--r-- | lib/VNDBUtil.pm | 1 | ||||
-rw-r--r-- | util/updates/update_2.15.sql | 4 |
4 files changed, 10 insertions, 0 deletions
@@ -8,6 +8,7 @@ - Removed specific tags-by-user listing - Disable "Don't update last modified field" by default for mods - Make Multi not report posts + - Consider "senpai" and "sempai" the same in the VN search - API: Allow extra whitespace after "get .." command - API: Allow non-numbers as "clientver" for the login command - API: Added "image_nsfw" member to "get vn" @@ -154,3 +154,7 @@ update-2.14: all ${runpsql} < util/updates/update_2.14.sql $(multi-start) +update-2.15: all + $(multi-stop) + ${runpsql} < util/updates/update_2.15.sql + $(multi-start) diff --git a/lib/VNDBUtil.pm b/lib/VNDBUtil.pm index 36038d47..1d4fd003 100644 --- a/lib/VNDBUtil.pm +++ b/lib/VNDBUtil.pm @@ -203,6 +203,7 @@ sub normalize { )(?:edition|version|版|生産)//xg; # other common things s/fandisk/fandisc/g; + s/sempai/senpai/g; no utf8; return $_; } 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; + |