switches appGuide filetype to varchar