fixing some error and adding parade.sql