update phonetype set extringtone = 'no' where id=50;
update phonetype set extringtone = 'no' where id=51;
update phonetype set extringtone = 'no' where id=52;
update phonetype set extringtone = 'no' where id=53;
update phonetype set extringtone = 'no' where id=54;
update phonetype set extringtone = 'no' where id=55;
update phonetype set extringtone = 'no' where id=56;
update phonetype set extringtone = 'no' where id=57;
update phonetype set extringtone = 'no' where id=58;
update phonetype set extringtone = 'no' where id=59;
update phonetype set extringtone = 'no' where id=5000;
update phonetype set extringtone = 'no' where id=5001;
update phonetype set extringtone = 'no' where id=5002;
update phonetype set extringtone = 'no' where id=5003;
update phonetype set extringtone = 'no' where id=5004;
update phonetype set extringtone = 'no' where id=5005;
update phonetype set extringtone = 'no' where id=5006;
update phonetype set extringtone = 'no' where id=5007;
update phonetype set extringtone = 'no' where id=5008;
update phonetype set extringtone = 'no' where id=5009;


update phonetyperingtone set name = 'ringa' where phonetype>=50 and phonetype<=59 and name = 'ring10';
update phonetyperingtone set name = 'ringb' where phonetype>=50 and phonetype<=59 and name = 'ring11';
update phonetyperingtone set name = 'ringc' where phonetype>=50 and phonetype<=59 and name = 'ring12';

update phonetyperingtone set name = 'ringa' where phonetype>=5000 and phonetype<=5004 and name = 'ring10';
update phonetyperingtone set name = 'ringb' where phonetype>=5000 and phonetype<=5004 and name = 'ring11';
update phonetyperingtone set name = 'ringc' where phonetype>=5000 and phonetype<=5004 and name = 'ring12';

-- Polycom 670
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5001, 'ring1', 'Silent Ring');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5001, 'ring2', 'Low Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5001, 'ring3', 'Low Double Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5001, 'ring4', 'Medium Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5001, 'ring5', 'Medium Double Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5001, 'ring6', 'High Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5001, 'ring7', 'High Double Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5001, 'ring8', 'Highest Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5001, 'ring9', 'Highest Double Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5001, 'ringa', 'Beeble');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5001, 'ringb', 'Triplet');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5001, 'ringc', 'Ringback-style');

-- Polycom 450
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5004, 'ring1', 'Silent Ring');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5004, 'ring2', 'Low Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5004, 'ring3', 'Low Double Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5004, 'ring4', 'Medium Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5004, 'ring5', 'Medium Double Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5004, 'ring6', 'High Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5004, 'ring7', 'High Double Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5004, 'ring8', 'Highest Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5004, 'ring9', 'Highest Double Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5004, 'ringa', 'Beeble');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5004, 'ringb', 'Triplet');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5004, 'ringc', 'Ringback-style');

-- Polycom 321
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5005, 'ring1', 'Silent Ring');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5005, 'ring2', 'Low Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5005, 'ring3', 'Low Double Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5005, 'ring4', 'Medium Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5005, 'ring5', 'Medium Double Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5005, 'ring6', 'High Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5005, 'ring7', 'High Double Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5005, 'ring8', 'Highest Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5005, 'ring9', 'Highest Double Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5005, 'ringa', 'Beeble');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5005, 'ringb', 'Triplet');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5005, 'ringc', 'Ringback-style');

-- Polycom 331
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5006, 'ring1', 'Silent Ring');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5006, 'ring2', 'Low Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5006, 'ring3', 'Low Double Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5006, 'ring4', 'Medium Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5006, 'ring5', 'Medium Double Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5006, 'ring6', 'High Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5006, 'ring7', 'High Double Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5006, 'ring8', 'Highest Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5006, 'ring9', 'Highest Double Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5006, 'ringa', 'Beeble');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5006, 'ringb', 'Triplet');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5006, 'ringc', 'Ringback-style');

-- Polycom 560
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5007, 'ring1', 'Silent Ring');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5007, 'ring2', 'Low Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5007, 'ring3', 'Low Double Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5007, 'ring4', 'Medium Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5007, 'ring5', 'Medium Double Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5007, 'ring6', 'High Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5007, 'ring7', 'High Double Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5007, 'ring8', 'Highest Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5007, 'ring9', 'Highest Double Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5007, 'ringa', 'Beeble');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5007, 'ringb', 'Triplet');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5007, 'ringc', 'Ringback-style');

-- Polycom 335
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5008, 'ring1', 'Silent Ring');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5008, 'ring2', 'Low Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5008, 'ring3', 'Low Double Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5008, 'ring4', 'Medium Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5008, 'ring5', 'Medium Double Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5008, 'ring6', 'High Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5008, 'ring7', 'High Double Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5008, 'ring8', 'Highest Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5008, 'ring9', 'Highest Double Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5008, 'ringa', 'Beeble');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5008, 'ringb', 'Triplet');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5008, 'ringc', 'Ringback-style');

-- Polycom 1500
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5009, 'ring1', 'Silent Ring');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5009, 'ring2', 'Low Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5009, 'ring3', 'Low Double Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5009, 'ring4', 'Medium Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5009, 'ring5', 'Medium Double Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5009, 'ring6', 'High Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5009, 'ring7', 'High Double Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5009, 'ring8', 'Highest Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5009, 'ring9', 'Highest Double Trill');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5009, 'ringa', 'Beeble');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5009, 'ringb', 'Triplet');
INSERT INTO phonetyperingtone (phonetype, name, description) VALUES
 (5009, 'ringc', 'Ringback-style');
 

