updated create.sql && convert alias to lowerCase