update the sql
add in some scripts for annotation processing