create procedures and table updates