change tid column to text (closes #2393)