Did the Prophets before Mohammad (pbuh) drink?

he turned water into wine to do what? to make the color scheme better?