modified allinfo.sql