add ; at create.sql
refactor and delete unuseful codes