-- Add recommendmedicine_id to medicine_schedule (nullable for normal medicines)
ALTER TABLE `medicine_schedule`
  ADD COLUMN `recommendmedicine_id` INT NULL DEFAULT NULL AFTER `medicine_id`;
