Remove duplicate entries from keybindings

Remove duplicate entries from keybindings:

patrick@myhostname:~/workspace/mythtv/packaging/deb/debian$ grep CYCLEAUDIOCHAN mythtv_0.27.0.sql | sed 's/)[,;](/)\n(/g' | tail -n +2 | awk ' { a[$0]++} ; END { for (i in a) print a[i] "\t" i } ' | sort | grep ^[^1]
2       ('TV Frontend','CYCLEAUDIOCHAN','Cycle audio channels','','OLDHOSTNAME')
2       ('TV Playback','BACK','Exit or return to DVD menu','','OLDHOSTNAME')
2       ('TV Playback','CYCLEAUDIOCHAN','Cycle audio channels','','OLDHOSTNAME')
2       ('TV Playback','NEXTRAWTEXT','Next Text track','','OLDHOSTNAME')
2       ('TV Playback','PREVRAWTEXT','Previous Text track','','OLDHOSTNAME')
2       ('TV Playback','SELECTRAWTEXT_0','Display Text Subtitle 1','','OLDHOSTNAME')
2       ('TV Playback','TOGGLERAWTEXT','Toggle Text Subtitles','','OLDHOSTNAME')
2       ('TV Playback','TOGGLETEXT','Toggle External Subtitles','','OLDHOSTNAME')
Remove duplicate entries from settings

Remove duplicate entries from settings:

patrick@myhostname:~/workspace/mythtv/packaging/deb/debian$ grep "INSERT INTO \`settings``" mythtv_0.27.0.sql | sed 's/)[,;](/)\n(/g' | tail -n +2 | awk ' { a[$0]++} ; END { for (i in a) print a[i] "\t" i } ' | sort | grep ^[^1]
2       ('BackendServerIP','127.0.0.1','OLDHOSTNAME')
2       ('BackendServerIP6','::1','OLDHOSTNAME')
2       ('BackendServerPort','6543','OLDHOSTNAME')
2       ('BackendStatusPort','6544','OLDHOSTNAME')
2       ('Country','US','OLDHOSTNAME')
2       ('DisableFirewireReset','0','OLDHOSTNAME')
2       ('JobAllowCommFlag','1','OLDHOSTNAME')
2       ('JobAllowTranscode','1','OLDHOSTNAME')
2       ('JobAllowUserJob1','0','OLDHOSTNAME')
2       ('JobAllowUserJob2','0','OLDHOSTNAME')
2       ('JobAllowUserJob3','0','OLDHOSTNAME')
2       ('JobAllowUserJob4','0','OLDHOSTNAME')
2       ('JobQueueCheckFrequency','60','OLDHOSTNAME')
2       ('JobQueueCPU','0','OLDHOSTNAME')
2       ('JobQueueMaxSimultaneousJobs','1','OLDHOSTNAME')
2       ('JobQueueWindowEnd','23:59','OLDHOSTNAME')
2       ('JobQueueWindowStart','00:00','OLDHOSTNAME')
2       ('MiscStatusScript','','OLDHOSTNAME')
2       ('MythFillFixProgramIDsHasRunOnce','1','OLDHOSTNAME')
Remove duplicate entries from keybindings

Remove duplicate entries from keybindings:

('TV Editing','SAVEMAP','Save cut list','','OLDHOSTNAME')
('TV Editing','SAVEMAP','Save cuts','','OLDHOSTNAME')