refactored sqlite adapter to new schema, tests accordingly. sqlite-adapter-example updated as well.