consolidating code and updating route and my sql db creation doc