-- Migrate Reservation.date from text to date
ALTER TABLE "Reservation"
  ALTER COLUMN date TYPE date USING date::date;

-- Migrate BusinessMetrics.date from text to date
ALTER TABLE "BusinessMetrics"
  ALTER COLUMN date TYPE date USING date::date;

-- Migrate WaitingList.preferredDate from text to date
ALTER TABLE "WaitingList"
  ALTER COLUMN "preferredDate" TYPE date USING "preferredDate"::date;
