overleaf-cep/services/history-v1/storage/scripts/global-blobs-db-cleanup/02-set-global-flag.sql

UPDATE blobs
SET global = TRUE
WHERE hash_bytes IN (SELECT hash_bytes FROM global_blob_hashes);