You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
db-schema/db_scripts/diff/15081.down

10 lines
406 B

USE provisioning;
DELETE FROM voip_preferences WHERE attribute = 'force_strict_number_match';
SELECT id INTO @vpgid FROM voip_preference_groups WHERE name = 'Number Manipulations';
SELECT id INTO @new_vpgid FROM voip_preference_groups WHERE name = 'Call Blockings';
UPDATE voip_preferences SET voip_preference_groups_id=@new_vpgid WHERE attribute='clir_intrapbx'
AND voip_preference_groups_id=@vpgid;