ALTER TABLE `xf_user_option`
ADD COLUMN `interaction_watch_state__conflict` ENUM('','watch_no_email','watch_email','watch_op_email') NOT NULL DEFAULT '' AFTER default_watch_state;
update xf_user_option
set interaction_watch_state__conflict = default_watch_state;
update xf_user_option
set default_watch_state = ''
where default_watch_state = 'watch_op_email';
ALTER TABLE `xf_user_option`
CHANGE COLUMN `interaction_watch_state` interaction_watch_state ENUM('','watch_no_email','watch_email','watch_op_email') NOT NULL DEFAULT '';
update xf_user_option
set creation_watch_state = interaction_watch_state__conflict, interaction_watch_state = interaction_watch_state__conflict
where interaction_watch_state__conflict = 'watch_op_email';
ALTER TABLE `xf_user_option`
DROP COLUMN `interaction_watch_state__conflict`;