modify database schema in preparation for respository security and field type enforcement