changed db types to text where applicable