update deprecated fns and altname sql considerations
add GPL
adds dependency declaration for ues