summaryrefslogtreecommitdiff
path: root/util/updates/update_2.12.sql
diff options
context:
space:
mode:
Diffstat (limited to 'util/updates/update_2.12.sql')
-rw-r--r--util/updates/update_2.12.sql20
1 files changed, 20 insertions, 0 deletions
diff --git a/util/updates/update_2.12.sql b/util/updates/update_2.12.sql
new file mode 100644
index 00000000..eea0ac5c
--- /dev/null
+++ b/util/updates/update_2.12.sql
@@ -0,0 +1,20 @@
+
+-- use newlines to separate aliases
+-- (note: this will go wrong with titles that contain a comma. Those have to be fixed manually)
+UPDATE vn_rev SET alias = trim(both ' ' from regexp_replace(alias, ' *, *', E'\n', 'g'));
+
+
+-- cache for search
+ALTER TABLE vn ADD COLUMN c_search text;
+
+\i util/sql/func.sql
+
+CREATE TRIGGER vn_vnsearch_notify AFTER UPDATE ON vn FOR EACH ROW EXECUTE PROCEDURE vn_vnsearch_notify();
+CREATE TRIGGER vn_vnsearch_notify AFTER UPDATE ON releases FOR EACH ROW EXECUTE PROCEDURE vn_vnsearch_notify();
+
+
+-- two new resolutions have been added, array indexes have changed
+UPDATE releases_rev SET resolution = resolution + 1 WHERE resolution >= 7;
+UPDATE releases_rev SET resolution = resolution + 1 WHERE resolution >= 11;
+
+