revised zpack to model and graph mysql. remaining issue with graph templates