diff options
| author | Yorhel <git@yorhel.nl> | 2018-02-07 09:29:32 +0100 |
|---|---|---|
| committer | Yorhel <git@yorhel.nl> | 2018-02-07 09:31:38 +0100 |
| commit | 3f3a4d9810bb2483a89442b85d438639f26ecb7e (patch) | |
| tree | 6e7dd501e4a761c89ffffcfe1d58c004a788b96a /util/updates | |
| parent | b0fbff7169b2d6c7176ae0648f323fd764139bfa (diff) | |
Use newline separation for producer aliases
For consistency with the VN & character alias fields. It's also less
ambiguous, as there are a few aliases that contain commas.
Diffstat (limited to 'util/updates')
| -rw-r--r-- | util/updates/update_20180207.sql | 3 |
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'); |