series of unit tests and sql updates