moved all of the tests that didn't need to be SQL test to basic core test.