added drop table, tests and fixed createCharacter