diff options
author | Yorhel <git@yorhel.nl> | 2019-08-21 12:37:17 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2019-08-21 12:37:20 +0200 |
commit | 0e5d1bec9717d2f9344e7681465f21ff93706484 (patch) | |
tree | 78473838a057d91afd28ad14639bb71be05258b4 /util | |
parent | 04d9ec043e1b74fe421a7a0a7d9e1822d21bd7ff (diff) |
Remove protocol from l_dmm links
It's redundant, and normalization is actually easier when removed.
Diffstat (limited to 'util')
-rw-r--r-- | util/updates/update_20190821.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/util/updates/update_20190821.sql b/util/updates/update_20190821.sql index a4b657d7..0635bdb3 100644 --- a/util/updates/update_20190821.sql +++ b/util/updates/update_20190821.sql @@ -29,3 +29,7 @@ SELECT migrate_notes_to_itch(id) FROM releases WHERE NOT hidden AND l_itch = '' AND notes ~* '\s*(?:Also available|Available) (?:on|at|from) \[url=https?://([a-z0-9_-]+)\.itch\.io/([a-z0-9_-]+)\]\s*Itch(?:\.io)?\s*\.?\[/url\](?:\,?$|\.\s*)'; AND id NOT IN(59555, 65209, 60553); DROP FUNCTION migrate_notes_to_itch(integer); + + +UPDATE releases SET l_dmm = regexp_replace(l_dmm, 'https?://', '') where l_dmm <> ''; +UPDATE releases_hist SET l_dmm = regexp_replace(l_dmm, 'https?://', '') where l_dmm <> ''; |