SET autocommit=0;

USE provisioning

SELECT id FROM voip_preferences where attribute='language' INTO @pref_id;

UPDATE voip_usr_preferences SET value = 'en' WHERE value = 'ru' AND attribute_id = @pref_id;
UPDATE voip_dom_preferences SET value = 'en' WHERE value = 'ru' AND attribute_id = @pref_id;

DELETE FROM voip_preferences_enum WHERE preference_id=@pref_id AND value in ('ru');

commit;