X-Git-Url: http://git.squeep.com/?a=blobdiff_plain;f=priv%2Frepo%2Fmigrations%2F20190711042024_copy_muted_to_muted_notifications.exs;h=bbd50204416a1482bafa1ae55de3f8186c8ca1a8;hb=29ab1d9f8d7a73a3e2012eb480a927c3f5f63787;hp=b717cab2e8ec546c59b881d55c6781f0b9660ab8;hpb=25cffffaf1685ef02cd318bdbd99bb325d295458;p=akkoma diff --git a/priv/repo/migrations/20190711042024_copy_muted_to_muted_notifications.exs b/priv/repo/migrations/20190711042024_copy_muted_to_muted_notifications.exs index b717cab2e..bbd502044 100644 --- a/priv/repo/migrations/20190711042024_copy_muted_to_muted_notifications.exs +++ b/priv/repo/migrations/20190711042024_copy_muted_to_muted_notifications.exs @@ -1,8 +1,11 @@ defmodule Pleroma.Repo.Migrations.CopyMutedToMutedNotifications do use Ecto.Migration - alias Pleroma.User def change do - execute("update users set info = jsonb_set(info, '{muted_notifications}', info->'mutes', true) where local = true") + execute("update users set info = '{}' where info is null") + + execute( + "update users set info = safe_jsonb_set(info, '{muted_notifications}', info->'mutes', true) where local = true" + ) end end