add adopted status to sql