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`);