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

19 lines
743 B

USE provisioning
SET autocommit=0;
UPDATE voip_sound_handles SET name='1-and' WHERE name='x1';
UPDATE voip_sound_handles SET name='2-and' WHERE name='x2';
UPDATE voip_sound_handles SET name='3-and' WHERE name='x3';
UPDATE voip_sound_handles SET name='4-and' WHERE name='x4';
UPDATE voip_sound_handles SET name='5-and' WHERE name='x5';
UPDATE voip_sound_handles SET name='6-and' WHERE name='x6';
UPDATE voip_sound_handles SET name='7-and' WHERE name='x7';
UPDATE voip_sound_handles SET name='8-and' WHERE name='x8';
UPDATE voip_sound_handles SET name='9-and' WHERE name='x9';
SELECT id FROM voip_sound_groups WHERE name='conference' INTO @grp_id;
INSERT INTO voip_sound_handles (name,group_id) VALUES ('conference_first', @grp_id);
commit;