made some changes to supervisor sql and began the ipgroup sql