[mythtv] channel.freqid too short for real frequencies

[J. Donavan Stanley]

Mark Spieth wrote:

> looking through and wanting to make a unique freq mapping to channel 
> numbers
> I noticed that the freq is only 5 chars long in the db. (channel table)
> since these numbers are in kHz this would require at least 6 chars for 
> terrestrial and
> cable and perhaps 7 for sat to reperesent numbers >= 100MHz == 100000kHz
> easy fix. whoever maintains the db consistency should do this one. 
> thus no patch is provided.
> temp fix is to use phpmyadmin or command line to change it explicitly 
> to VARCHAR(7)
> cheers mark


You're a little late:

----------------------------------------------------------------------------
Changes committed by ijr on Thu Aug 19 05:14:22 2004

Modified Files:
   in mythtv/libs/libmythtv:
        channel.cpp dbcheck.cpp 
Log Message:
Fix bug in initial input selection, pointed out by Andy McMullan.
Increase the size of freqid in the db.