CREATE TABLE IF NOT EXISTS `medicines` (
  `id` INT AUTO_INCREMENT PRIMARY KEY,
  `medicine_name` VARCHAR(255) NOT NULL,
  `expiry_date` DATE NOT NULL,
  `added_on` TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);