remove obsleted sql
modernize tests
actually have the tests running
enable travis-ci