ALTER TABLE `inventory_items` 
CHANGE `dosage_form` `dosage` VARCHAR(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, 
CHANGE `dosage_units` `strength_units` VARCHAR(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, CHANGE `stock_strength` `strength` INT NOT NULL, CHANGE `stock_volume` `volume` INT NOT NULL, 
CHANGE `container_volume` `container` INT NOT NULL;
ALTER TABLE `inventory_items` ADD `strength_units` VARCHAR(250) NOT NULL AFTER `strength`;