[mythtv] Datadirect error with MySQL 5.0

[Nathan J. Robinson]

Is it possible to quote the word "repeat" using backquotes insite the
SQL statements in datadirect.cpp?  "repeat" is a reserved word in MySQL
5 and it's causing me to have to edit libmythtv and recompile everytime
a new version is released.
Thanks,
-Nathan

Here's the diff:

libs/libmythtv/datadirect.cpp
177c177
<
"scheduletime,duration,repeat,stereo,subtitled,hdtv,"
---
   >
"scheduletime,duration,`repeat`,stereo,subtitled,hdtv,"
417c417
<                        "subtitle, description, year, stars, repeat,
stereo, "
---
   >                        "subtitle, description, year, stars, `repeat`,
stereo, "
620c620
<             "duration time, repeat bool, stereo bool, subtitled bool, "
---
   >             "duration time, `repeat` bool, stereo bool, subtitled
bool, "
638c638
<             "previouslyshown tinyint, repeat bool, stereo bool, "
---
   >             "previouslyshown tinyint, `repeat` bool, stereo bool, "

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 5347 bytes
Desc: S/MIME Cryptographic Signature
Url : http://mythtv.org/pipermail/mythtv-dev/attachments/20060106/8de27030/smime.bin