change channel column to varchar, add shortname, location, pick, search columns