The Sun isn't massive enough to supernova. It'll form a Red Giant when the H is consumed and swallow the Earth first. In the end, the Sun will become a [link|http://astrosun.tn.cornell.edu/courses/astro201/evol_sun.htm|black dwarf].
:-)
Cheers,
Scott.