The creator of 1960s TV show The Beverly Hillbillies, Paul Henning, has died in a California hospital, aged 93.