The p-process in supernovae