ALTER TABLE heisenberg.medicine_dosage_type ADD medicine_number varchar(255) NULL;
ALTER TABLE heisenberg.medicine_dosage_type CHANGE medicine_number medicine_number varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL AFTER dosage_strength;
ALTER TABLE heisenberg.medicine_dosage_type MODIFY COLUMN medicine_number varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL;
ALTER TABLE heisenberg.medicine_dosage_type ADD UNIQUE (medicine_number);