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/13449.up

10 lines
354 B

USE provisioning;
SET AUTOCOMMIT=0;
UPDATE voip_peer_rules SET callee_pattern = REPLACE(callee_pattern, '^', '^sip:')
WHERE callee_pattern LIKE '^%' AND callee_pattern NOT LIKE '^sip:%';
UPDATE voip_peer_rules SET caller_pattern = REPLACE(caller_pattern, '^', '^sip:')
WHERE caller_pattern LIKE '^%' AND caller_pattern NOT LIKE '^sip:%';
COMMIT;