lemmy/migrations/2021-03-04-040229_clean_icon_urls/up.sql

30 lines
355 B
MySQL
Raw Permalink Normal View History

-- If these are not urls, it will crash the server
UPDATE
user_
SET
avatar = NULL
WHERE
avatar NOT LIKE 'http%';
UPDATE
user_
SET
banner = NULL
WHERE
banner NOT LIKE 'http%';
UPDATE
community
SET
icon = NULL
WHERE
icon NOT LIKE 'http%';
UPDATE
community
SET
banner = NULL
WHERE
banner NOT LIKE 'http%';