diff options
| author | Yorhel <git@yorhel.nl> | 2008-11-22 13:16:10 +0100 |
|---|---|---|
| committer | Yorhel <git@yorhel.nl> | 2008-11-22 13:16:10 +0100 |
| commit | 323f8d2b48ed76e9bfe0912ec0d78bbb3cfdf7f3 (patch) | |
| tree | f72ca71bd311c7c2d92d77743750228bfc9f7d01 /util | |
| parent | 413788b944e39ad87d5da236d007ce861ce6ba95 (diff) | |
Getting rid of \r altogether
Diffstat (limited to 'util')
| -rw-r--r-- | util/updates/update_2.0.sql | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/util/updates/update_2.0.sql b/util/updates/update_2.0.sql index e336adae..2f8edac4 100644 --- a/util/updates/update_2.0.sql +++ b/util/updates/update_2.0.sql @@ -58,3 +58,19 @@ UPDATE users SET ALTER TABLE users DROP COLUMN flags; + + +-- get rid of \r +UPDATE vn_rev + SET "desc" = translate("desc", E'\r', ''), + alias = translate(alias, E'\r', ''); +UPDATE releases_rev + SET notes = translate(notes, E'\r', ''); +UPDATE producers_rev + SET "desc" = translate("desc", E'\r', ''); +UPDATE changes + SET comments = translate(comments, E'\r', ''); +UPDATE threads_posts + SET msg = translate(msg, E'\r', ''); + + |