-- Up

UPDATE users
SET avatarSource = REPLACE(
    avatarSource,
    'https://dclu0bpcdglik.cloudfront.net/',
    'https://cdn.pronouns.page/'
)
WHERE avatarSource LIKE 'https://dclu0bpcdglik.cloudfront.net/%';

UPDATE profiles
SET card = REPLACE(
    card,
    'https://pronouns-page.s3.eu-west-1.amazonaws.com/',
    'https://cdn.pronouns.page/'
)
WHERE card LIKE 'https://pronouns-page.s3.eu-west-1.amazonaws.com/%';

UPDATE profiles
SET cardDark = REPLACE(
    cardDark,
    'https://pronouns-page.s3.eu-west-1.amazonaws.com/',
    'https://cdn.pronouns.page/'
)
WHERE cardDark LIKE 'https://pronouns-page.s3.eu-west-1.amazonaws.com/%';

-- Down

UPDATE users
SET avatarSource = REPLACE(
    avatarSource,
    'https://cdn.pronouns.page/',
    'https://dclu0bpcdglik.cloudfront.net/'
)
WHERE avatarSource LIKE 'https://cdn.pronouns.page/%';

UPDATE profiles
SET card = REPLACE(
    card,
    'https://cdn.pronouns.page/',
    'https://pronouns-page.s3.eu-west-1.amazonaws.com/'
)
WHERE card LIKE 'https://cdn.pronouns.page/%';

UPDATE profiles
SET cardDark = REPLACE(
    cardDark,
    'https://cdn.pronouns.page/',
    'https://pronouns-page.s3.eu-west-1.amazonaws.com/'
)
WHERE cardDark LIKE 'https://cdn.pronouns.page/%';
