change tid column to text (closes #2392)