INSERT INTO `outreach`.`followup_options` (`option`, `label`) VALUES ('six_week', 'six weeks'); ALTER TABLE `outreach`.`followup_options` ADD COLUMN `position` TINYINT UNSIGNED NOT NULL AFTER `label`; UPDATE `outreach`.`followup_options` SET `position`='1' WHERE `option`='zero_month'; UPDATE `outreach`.`followup_options` SET `position`='2' WHERE `option`='one_month'; UPDATE `outreach`.`followup_options` SET `position`='3' WHERE `option`='six_week'; UPDATE `outreach`.`followup_options` SET `position`='4' WHERE `option`='two_month'; UPDATE `outreach`.`followup_options` SET `position`='5' WHERE `option`='three_month'; UPDATE `outreach`.`followup_options` SET `position`='6' WHERE `option`='six_month'; UPDATE `outreach`.`followup_options` SET `position`='7' WHERE `option`='twelve_month'; UPDATE `outreach`.`followup_options` SET `position`='8' WHERE `option`='twenty_four_month'; UPDATE `outreach`.`followup_options` SET `position`='9' WHERE `option`='sixty_month'; UPDATE `outreach`.`followup_options` SET `position`='10' WHERE `option`='clinic_return'; UPDATE `outreach`.`followup_options` SET `position`='11' WHERE `option`='dead'; UPDATE `outreach`.`followup_options` SET `position`='12' WHERE `option`='other'; ALTER TABLE `outreach`.`followup_options` ADD UNIQUE INDEX `position` (`position`);