Rodar isso antes do proximo deploy e guardar o resultado

select concat('update friend_campaigns set market_chain_id = ', m.market_chain_id, ' where id = ',f.id,';')
from friend_campaigns f
join markets m on f.market_id = m.id