switched sql to MySQL, finished v1 for UI