merge w/ last upstream, cleantable use TRUNCATE, utility additions

merge w/ last upstream, cleantable use TRUNCATE, utility additions