summaryrefslogtreecommitdiff
path: root/util/updates/update_20180207.sql
diff options
context:
space:
mode:
Diffstat (limited to 'util/updates/update_20180207.sql')
-rw-r--r--util/updates/update_20180207.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/util/updates/update_20180207.sql b/util/updates/update_20180207.sql
new file mode 100644
index 00000000..99a8be59
--- /dev/null
+++ b/util/updates/update_20180207.sql
@@ -0,0 +1,3 @@
+-- Producer aliases are now separated by newline
+UPDATE producers SET alias = regexp_replace(alias, '\s*,\s*', E'\n', 'g');
+UPDATE producers_hist SET alias = regexp_replace(alias, '\s*,\s*', E'\n', 'g');