summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--ChangeLog1
-rw-r--r--Makefile4
-rw-r--r--lib/VNDBUtil.pm1
-rw-r--r--util/updates/update_2.15.sql4
4 files changed, 10 insertions, 0 deletions
diff --git a/ChangeLog b/ChangeLog
index 1db77dc3..ff1ff8cb 100644
--- a/ChangeLog
+++ b/ChangeLog
@@ -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"
diff --git a/Makefile b/Makefile
index 333d5add..6c8b45bf 100644
--- a/Makefile
+++ b/Makefile
@@ -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;
+