minor update to sql management

added a new enum for handling devices in sql resultset.