summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
Diffstat (limited to 'util')
-rw-r--r--util/updates/update_2.25.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/util/updates/update_2.25.sql b/util/updates/update_2.25.sql
index 138ec7a0..07275ae7 100644
--- a/util/updates/update_2.25.sql
+++ b/util/updates/update_2.25.sql
@@ -63,3 +63,7 @@ CREATE OR REPLACE FUNCTION strip_spoilers(t text) RETURNS text AS $$
-- The website doesn't require the [spoiler] tag to be closed, the outer replace catches that case.
SELECT regexp_replace(regexp_replace(t, '\[spoiler\].*?\[/spoiler\]', ' ', 'ig'), '\[spoiler\].*', ' ', 'i');
$$ LANGUAGE sql IMMUTABLE;
+
+
+-- Changes to search normalization
+UPDATE vn SET c_search = NULL;