started on integrating mysql. changed control to "devices"