fixed ddl for commit. unit tests.