-- to run this channel altering script:
-- mysql -umythtv -p -h192.168.1.1 --database mythconverg < mythtv-rename-freeview.sql

-- Last updated 2012-03-21

-- Re-name the stations to have a T- prefix
update channel SET name='T-BBC ONE Scot'          WHERE name='BBC ONE Scot';
update channel SET name='T-BBC TWO Scot'          WHERE name='BBC TWO Scot';
update channel SET name='T-STV'                   WHERE name='STV';
update channel SET name='T-Channel 4'             WHERE name='Channel 4';
update channel SET name='T-Channel 5'             WHERE name='Channel 5';
update channel SET name='T-ITV2'                  WHERE name='ITV2';
update channel SET name='T-BBC THREE'             WHERE name='BBC THREE';
update channel SET name='T-BBC ALBA'              WHERE name='BBC ALBA';
update channel SET name='T-BBC FOUR'              WHERE name='BBC FOUR';
update channel SET name='T-ITV3'                  WHERE name='ITV3';
update channel SET name='T-Pick TV'               WHERE name='Pick TV';
update channel SET name='T-Yesterday'             WHERE name='Yesterday';
update channel SET name='T-Channel 4+1'           WHERE name='Channel 4+1';
update channel SET name='T-More 4'                WHERE name='More 4';
update channel SET name='T-Film4'                 WHERE name='Film4';
update channel SET name='T-QVC'                   WHERE name='QVC';
update channel SET name='T-G.O.L.D.'              WHERE name='G.O.L.D.';
update channel SET name='T-4Music'                WHERE name='4Music';
update channel SET name='T-Dave'                  WHERE name='Dave';
update channel SET name='T-Really'                WHERE name='Really';
update channel SET name='T-VIVA'                  WHERE name='VIVA';
update channel SET name='T-Ideal World'           WHERE name='Ideal World';
update channel SET name='T-Bid TV'                WHERE name='bid tv';
update channel SET name='T-ITV4'                  WHERE name='ITV4';
update channel SET name='T-Dave ja vu'            WHERE name='Dave ja vu';
update channel SET name='T-Home'                  WHERE name='Home';
update channel SET name='T-ITV2 +1'               WHERE name='ITV2 +1';
update channel SET name='T-E4'                    WHERE name='E4';
update channel SET name='T-E4+1'                  WHERE name='E4+1';
update channel SET name='T-5*'                    WHERE name='5*';
update channel SET name='T-5 USA'                 WHERE name='5USA';
update channel SET name='T-5 USA'                 WHERE name='5 USA';
update channel SET name='T-Big Deal'              WHERE name='Big Deal';
update channel SET name='T-STV+1'                 WHERE name='STV+1';
update channel SET name='T-Create & Craft'        WHERE name='Create & Craft';
update channel SET name='T-Price-Drop TV'         WHERE name='price-drop tv';
update channel SET name='T-Quest'                 WHERE name='QUEST';
update channel SET name='T-The Zone'              WHERE name='The Zone';
update channel SET name='T-Rocks & Co 1'          WHERE name='Rocks & Co 1';
update channel SET name='T-Gems TV'               WHERE name='Gems TV';
update channel SET name='T-Channel 5+1'           WHERE name='Channel 5+1';
update channel SET name='T-Lottery Xtra'          WHERE name='Lottery Xtra';
update channel SET name='T-Challenge'             WHERE name='Challenge';
update channel SET name='T-QVC Beauty'            WHERE name='QVC Beauty';
update channel SET name='T-Food Network'          WHERE name='Food Network';
update channel SET name='T-BBC One HD'            WHERE name='BBC One HD';
update channel SET name='T-STV HD'                WHERE name='STV HD';
update channel SET name='T-Channel 4 HD'          WHERE name='Channel 4 HD';
update channel SET name='T-BBC HD'                WHERE name='BBC HD';
update channel SET name='T-The Jewellery Channel' WHERE name='The Jewellery Channel';
update channel SET name='T-CBBC'                  WHERE name='CBBC Channel';
update channel SET name='T-CBeebies'              WHERE name='CBeebies';
update channel SET name='T-CITV'                  WHERE name='CITV';
update channel SET name='T-BBC NEWS'              WHERE name='BBC NEWS';
update channel SET name='T-BBC Parliament'        WHERE name='BBC Parliament';
update channel SET name='T-Sky News'              WHERE name='Sky News';
update channel SET name='T-Russia Today'          WHERE name='Russia Today';
update channel SET name='T-Community Channel'     WHERE name='COMMUNITY';
update channel SET name='T-Al Jazeera Eng'        WHERE name='Al Jazeera Eng';
update channel SET name='T-BBC Red Button'        WHERE name='BBC Red Button';
update channel SET name='T-Racing UK'             WHERE name='Racing UK';
update channel SET name='T-301'                   WHERE name='301';
update channel SET name='T-TOPUP Anytime1'        WHERE name='TOPUP Anytime1';
update channel SET name='T-TOPUP Anytime3'        WHERE name='TOPUP Anytime3';
update channel SET name='T-TOPUP Anytime5'        WHERE name='TOPUP Anytime5';
update channel SET name='T-TOPUP Anytime6'        WHERE name='TOPUP Anytime6';
update channel SET name='T-Television X'          WHERE name='Television X';
update channel SET name='T-ADULT smileTV2'        WHERE name='ADULT smileTV2';
update channel SET name='T-ADULT smileTV3'        WHERE name='ADULT smileTV3';
update channel SET name='T-ADULT Babestn'         WHERE name='ADULT Babestn';
update channel SET name='T-ADULT PARTY'           WHERE name='ADULT PARTY';
update channel SET name='T-ADULT Blue'            WHERE name='ADULT Blue';
update channel SET name='T-ADULT Babestn2'        WHERE name='ADULT Babestn2';
update channel SET name='T-ADULT Playboy'         WHERE name='ADULT Playboy';