summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2019-08-21 12:37:17 +0200
committerYorhel <git@yorhel.nl>2019-08-21 12:37:20 +0200
commit0e5d1bec9717d2f9344e7681465f21ff93706484 (patch)
tree78473838a057d91afd28ad14639bb71be05258b4 /util
parent04d9ec043e1b74fe421a7a0a7d9e1822d21bd7ff (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.sql4
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 <> '';