Monday, March 27, 2006

Prepare for rescan

Need to rescan channels because PBS stations changed and ABC audio is breaking up. Key values from channel table:

mysql> select chanid,channum,freqid,callsign,name,xmltvid,mplexid,serviceid,atscsrcid from channel where visible=1;
+--------+---------+--------+----------+-------------------------------+---------+---------+-----------+-----------+
| chanid | channum | freqid | callsign | name | xmltvid | mplexid | serviceid | atscsrcid |
+--------+---------+--------+----------+-------------------------------+---------+---------+-----------+-----------+
| 1070 | 92 | NULL | ENCORE | ENCORE | | 7 | 2 | 2 |
| 1071 | 111 | NULL | KNTV-HD | KNTV-HD | | 2 | 3 | 1 |
| 1072 | 73 | NULL | KGO-DT | KGO-DT | | 4 | 5 | 4 |
| 1025 | 25_1 | 58-1 | KCAHDT | KCAHDT (KCAH-DT) | 49856 | NULL | NULL | NULL |
| 1007 | 7_3 | 24-3 | KGODT3 | KGODT3 (KGO-DT3) | 49937 | NULL | NULL | NULL |
| 1069 | 91 | NULL | KQED-HD | KQED-HD | | 7 | 1 | 1 |
| 1030 | 21 | NULL | KTVUHD | KTVUHD | 19571 | 20 | 3 | 1 |
| 1034 | 5_1 | 29-1 | KPIXDT | KPIXDT (KPIX-DT) | 19572 | 6 | 1 | 1 |
| 1035 | 4_1 | 57-1 | KRONDT | KRONDT (KRON-DT) | 19573 | 21 | 3 | 2 |
| 1036 | 7_1 | 24-1 | KGODT | KGODT (KGO-DT) | 19574 | 4 | 3 | 1 |
| 1044 | 44_1 | 45-1 | KBHKDT | KBHKDT (KBHK-DT) | 19575 | 14 | 1 | 1 |
| 1037 | 4_2 | 57-2 | KRONDT2 | KRONDT2 (KRON-DT2) | 20547 | 21 | 4 | 3 |
| 1038 | 36_1 | 52-1 | KICUDT | KICUDT (KICU-DT) | 21650 | 19 | 3 | 1 |
| 1039 | 11_1 | 12-1 | KNTVDT | KNTVDT(KNTV-DT) | 21785 | 2 | 3 | 1 |
| 1040 | 20_1 | 19-1 | KBWBDT | KBWBDT (KBWB-DT) | 24343 | 3 | 3 | 1 |
| 1041 | 9_1 | 30-1 | KQEDDT | KQEDDT (KQED-DT) | 24344 | 7 | 5 | 5 |
| 1042 | 9_2 | 30-2 | KQEDDT2 | KQEDDT2 (KQED-DT2) | 30507 | 7 | 6 | 4 |
| 1043 | 7_2 | 24-2 | KGODT2 | KGODT2 (KGO-DT2) | 30833 | 4 | 4 | 2 |
| 1046 | 26_1 | 27-1 | KTSFDT | KTSFDT (KTSF-DT) | 31221 | 5 | 3 | 3 |
| 1047 | 9_5 | 30-5 | KQEDDT5 | KQEDDT5 (KQED-DT5) | 34116 | 7 | 7 | 5 |
| 1049 | 9_4 | 30-4 | KQEDDT4 | KQEDDT4 (KQED-DT4) | 34168 | 7 | 2 | 2 |
| 1050 | 9_3 | 30-3 | KQEDDT3 | KQEDDT3 KQED World (KQED-DT3) | 35278 | 8 | 3 | 3 |
| 1051 | 43_1 | 43-1 | KCSMDT | KCSMDT (KCSM-DT) | 35545 | 13 | 2 | 1 |
| 1056 | 54_1 | 50-1 | KTEHDT | KTEHDT (KTEH-DT) | 44690 | 17 | 1 | 1 |
| 1015 | 11_2 | 12-2 | KNTVDT2 | KNTVDT2 (KNTV-DT2) | 36151 | NULL | NULL | NULL |
| 1057 | 32_1 | 33-1 | KMTPDT | KMTPDT (KMTP-DT) | 47121 | NULL | NULL | NULL |
+--------+---------+--------+----------+-------------------------------+---------+---------+-----------+-----------+

List view:

mysql> select chanid,channum,freqid,callsign,name,xmltvid,mplexid,serviceid,atscsrcid from channel where visible=1\G
*************************** 1. row ***************************
chanid: 1070
channum: 92
freqid: NULL
callsign: ENCORE
name: ENCORE
xmltvid:
mplexid: 7
serviceid: 2
atscsrcid: 2
*************************** 2. row ***************************
chanid: 1071
channum: 111
freqid: NULL
callsign: KNTV-HD
name: KNTV-HD
xmltvid:
mplexid: 2
serviceid: 3
atscsrcid: 1
*************************** 3. row ***************************
chanid: 1072
channum: 73
freqid: NULL
callsign: KGO-DT
name: KGO-DT
xmltvid:
mplexid: 4
serviceid: 5
atscsrcid: 4
*************************** 4. row ***************************
chanid: 1025
channum: 25_1
freqid: 58-1
callsign: KCAHDT
name: KCAHDT (KCAH-DT)
xmltvid: 49856
mplexid: NULL
serviceid: NULL
atscsrcid: NULL
*************************** 5. row ***************************
chanid: 1007
channum: 7_3
freqid: 24-3
callsign: KGODT3
name: KGODT3 (KGO-DT3)
xmltvid: 49937
mplexid: NULL
serviceid: NULL
atscsrcid: NULL
*************************** 6. row ***************************
chanid: 1069
channum: 91
freqid: NULL
callsign: KQED-HD
name: KQED-HD
xmltvid:
mplexid: 7
serviceid: 1
atscsrcid: 1
*************************** 7. row ***************************
chanid: 1030
channum: 21
freqid: NULL
callsign: KTVUHD
name: KTVUHD
xmltvid: 19571
mplexid: 20
serviceid: 3
atscsrcid: 1
*************************** 8. row ***************************
chanid: 1034
channum: 5_1
freqid: 29-1
callsign: KPIXDT
name: KPIXDT (KPIX-DT)
xmltvid: 19572
mplexid: 6
serviceid: 1
atscsrcid: 1
*************************** 9. row ***************************
chanid: 1035
channum: 4_1
freqid: 57-1
callsign: KRONDT
name: KRONDT (KRON-DT)
xmltvid: 19573
mplexid: 21
serviceid: 3
atscsrcid: 2
*************************** 10. row ***************************
chanid: 1036
channum: 7_1
freqid: 24-1
callsign: KGODT
name: KGODT (KGO-DT)
xmltvid: 19574
mplexid: 4
serviceid: 3
atscsrcid: 1
*************************** 11. row ***************************
chanid: 1044
channum: 44_1
freqid: 45-1
callsign: KBHKDT
name: KBHKDT (KBHK-DT)
xmltvid: 19575
mplexid: 14
serviceid: 1
atscsrcid: 1
*************************** 12. row ***************************
chanid: 1037
channum: 4_2
freqid: 57-2
callsign: KRONDT2
name: KRONDT2 (KRON-DT2)
xmltvid: 20547
mplexid: 21
serviceid: 4
atscsrcid: 3
*************************** 13. row ***************************
chanid: 1038
channum: 36_1
freqid: 52-1
callsign: KICUDT
name: KICUDT (KICU-DT)
xmltvid: 21650
mplexid: 19
serviceid: 3
atscsrcid: 1
*************************** 14. row ***************************
chanid: 1039
channum: 11_1
freqid: 12-1
callsign: KNTVDT
name: KNTVDT(KNTV-DT)
xmltvid: 21785
mplexid: 2
serviceid: 3
atscsrcid: 1
*************************** 15. row ***************************
chanid: 1040
channum: 20_1
freqid: 19-1
callsign: KBWBDT
name: KBWBDT (KBWB-DT)
xmltvid: 24343
mplexid: 3
serviceid: 3
atscsrcid: 1
*************************** 16. row ***************************
chanid: 1041
channum: 9_1
freqid: 30-1
callsign: KQEDDT
name: KQEDDT (KQED-DT)
xmltvid: 24344
mplexid: 7
serviceid: 5
atscsrcid: 5
*************************** 17. row ***************************
chanid: 1042
channum: 9_2
freqid: 30-2
callsign: KQEDDT2
name: KQEDDT2 (KQED-DT2)
xmltvid: 30507
mplexid: 7
serviceid: 6
atscsrcid: 4
*************************** 18. row ***************************
chanid: 1043
channum: 7_2
freqid: 24-2
callsign: KGODT2
name: KGODT2 (KGO-DT2)
xmltvid: 30833
mplexid: 4
serviceid: 4
atscsrcid: 2
*************************** 19. row ***************************
chanid: 1046
channum: 26_1
freqid: 27-1
callsign: KTSFDT
name: KTSFDT (KTSF-DT)
xmltvid: 31221
mplexid: 5
serviceid: 3
atscsrcid: 3
*************************** 20. row ***************************
chanid: 1047
channum: 9_5
freqid: 30-5
callsign: KQEDDT5
name: KQEDDT5 (KQED-DT5)
xmltvid: 34116
mplexid: 7
serviceid: 7
atscsrcid: 5
*************************** 21. row ***************************
chanid: 1049
channum: 9_4
freqid: 30-4
callsign: KQEDDT4
name: KQEDDT4 (KQED-DT4)
xmltvid: 34168
mplexid: 7
serviceid: 2
atscsrcid: 2
*************************** 22. row ***************************
chanid: 1050
channum: 9_3
freqid: 30-3
callsign: KQEDDT3
name: KQEDDT3 KQED World (KQED-DT3)
xmltvid: 35278
mplexid: 8
serviceid: 3
atscsrcid: 3
*************************** 23. row ***************************
chanid: 1051
channum: 43_1
freqid: 43-1
callsign: KCSMDT
name: KCSMDT (KCSM-DT)
xmltvid: 35545
mplexid: 13
serviceid: 2
atscsrcid: 1
*************************** 24. row ***************************
chanid: 1056
channum: 54_1
freqid: 50-1
callsign: KTEHDT
name: KTEHDT (KTEH-DT)
xmltvid: 44690
mplexid: 17
serviceid: 1
atscsrcid: 1
*************************** 25. row ***************************
chanid: 1015
channum: 11_2
freqid: 12-2
callsign: KNTVDT2
name: KNTVDT2 (KNTV-DT2)
xmltvid: 36151
mplexid: NULL
serviceid: NULL
atscsrcid: NULL
*************************** 26. row ***************************
chanid: 1057
channum: 32_1
freqid: 33-1
callsign: KMTPDT
name: KMTPDT (KMTP-DT)
xmltvid: 47121
mplexid: NULL
serviceid: NULL
atscsrcid: NULL
26 rows in set (0.00 sec)