update view and trans.sql