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

6 lines
303 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%';