changes schema for visits table and moves the create into a const variable