use provisioning;
set autocommit=0;

set @pid = 0;
select id into @pid from voip_preferences where attribute = "outbound_diversion";

DELETE FROM voip_preferences_enum
 WHERE preference_id = @pid AND value = 'npn';

commit;