Line surveys of irradiated protostars: Photo-destruction and evaporation