update ddl and procedure