[mythtv-users] mythweather database tables

[Paul Harrison]

Chuck Filson wrote:
> On May 11, 2009 11:37:19 am Greg Woods wrote:
>   
>> Can somebody send me a definition for the tables needed for Mythweather
>> as of SVN trunk 20509? I have been unable to set up Mythweather, and
>> traced it to the fact that the three weather-related tables are missing
>> from my database (resulting in "invalid response from database" errors
>> trying to configure it). I believe this is left over from a previous
>> restoration of a corrupted database, but I think it is likely that
>> Mythweather will work fine if I can just get the initial tables set up
>> for it.
>>
>> Thank you,
>>
>> --Greg
>>
>>     
>
> Give this a try
>
> http://www.gossamer-threads.com/lists/mythtv/users/335069#335069
>
> Chuck
>   

The method in the link will work or if you want to see the actual table
definitions there here:-
http://svn.mythtv.org/trac/browser/trunk/mythplugins/mythweather/mythweather/dbcheck.cpp#L77

Note MythWeather is the only part of Myth that requires MySql to use
INNODB tables.  Hopefully  one day some kind soul will make MythWeather
use the same table type as the rest of Myth :-)

Paul H.