added views and testing for mysql