ozoramore

@silverpill
avatar and banner are done.

UPDATE actor_profile SET avatar=jsonb_build_object( 'url', avatar->'url', 'type', 'link', 'media_type', avatar->'media_type' ) WHERE avatar->>'url' IS NOT NULL;
UPDATE actor_profile SET banner=jsonb_build_object( 'url', banner->'url', 'type', 'link', 'media_type', banner->'media_type' ) WHERE banner->>'url' IS NOT NULL;

But emojis have a different structure, and I'm not great at SQL...

#mitra
I successfully completed the full migration to the proxy by running this command. (Of course, I did so at my own risk.)

UPDATE media_attachment SET media=jsonb_build_object( 'url', media->'url', 'type', 'link', 'media_type', media->'media_type' ) WHERE media->>'url' IS NOT NULL;
UPDATE emoji SET image=jsonb_build_object( 'url', image->'url', 'type', 'link', 'media_type', image->'media_type' ) WHERE image->>'url' IS NOT NULL;