Scripts que devem ser executados depois do deploy da sprint 41 em produção

update msauthpersonaldata
set body = jsonb_set(body, '{profileImageBlobCache}', ('{"sasUri": "", "creationDate": "", "durationInHours": ""}')::jsonb)
where msauthpersonaldata.body -> 'profileImageBlobCache' is null;

update msclientscompanies
set body = jsonb_set(body, '{logoImageBlobCache}', ('{"sasUri": "", "creationDate": "", "durationInHours": ""}')::jsonb)
where msclientscompanies.body -> 'logoImageBlobCache' is null;

update msvacanciesfunnel
set body = jsonb_set(body, '{coverImageBlobCache}', ('{"sasUri": "", "creationDate": "", "durationInHours": ""}')::jsonb)
where msvacanciesfunnel.body -> 'coverImageBlobCache' is null;

update msadmissions
set body = jsonb_set(body, '{medicalExamScheduling, medicalExamSchedulingGuideFileBlobCache}', ('{"sasUri": "", "creationDate": "", "durationInHours": ""}')::jsonb)
where msadmissions.body -> 'medicalExamScheduling' -> 'medicalExamSchedulingGuideFileBlobCache' is null;

update msadmissions
set body = jsonb_set(body, '{accountOpeningLetter, openingLetterTemplateBlobCache}', ('{"sasUri": "", "creationDate": "", "durationInHours": ""}')::jsonb)
where msadmissions.body -> 'accountOpeningLetter' -> 'openingLetterTemplateBlobCache' is null;