mirror of
https://gitlab.com/PronounsPage/PronounsPage.git
synced 2025-09-24 05:05:20 -04:00
52 lines
1.2 KiB
SQL
52 lines
1.2 KiB
SQL
-- 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/%';
|