continuing to roll back or remove deprecated functions

removing all functions requiring significant restructuring due to schema
improvements and optimizations