[patch] Proposed patch

mythtv.diff (text/plain), 2.34 KB, created by Steven Walter on 2005-11-07 04:46:45 UTC

--- mythtv-0.18.1/libs/libmythtv/datadirect.cpp	2005-05-04 15:40:07.000000000 -0400
+++ mythtv-0.18.1~/libs/libmythtv/datadirect.cpp	2005-11-07 07:19:09.000000000 -0500
@@ -174,7 +174,7 @@
                                         QTime().secsTo(curr_schedule.duration));
 
         query.prepare("INSERT INTO dd_schedule (programid,stationid,"
-                      "scheduletime,duration,repeat,stereo,subtitled,hdtv,"
+                      "scheduletime,duration,`repeat`,stereo,subtitled,hdtv,"
                       "closecaptioned,tvrating,partnumber,parttotal,endtime) "
                       "VALUES(:PROGRAMID,:STATIONID,:TIME,:DURATION,"
                       ":REPEAT,:STEREO,:SUBTITLED,:HDTV,:CLOSECAPTIONED,"
@@ -414,7 +414,7 @@
                        "syndicatedepisodenumber, tvrating, mpaarating, "
                        "programid) "
                        "SELECT chanid, scheduletime, endtime, title, "
-                       "subtitle, description, year, stars, repeat, stereo, "
+                       "subtitle, description, year, stars, `repeat`, stereo, "
                        "subtitled, hdtv, closecaptioned, partnumber, "
                        "parttotal, seriesid, originalairdate, showtype, "
                        "category_type, colorcode, syndicatedepisodenumber, "
@@ -617,7 +617,7 @@
     createATempTable ("dd_v_station", table);
 
     table = "( programid char(12), stationid char(12), scheduletime datetime, "
-            "duration time, repeat bool, stereo bool, subtitled bool, "
+            "duration time, `repeat` bool, stereo bool, subtitled bool, "
             "hdtv bool, closecaptioned bool, tvrating char(5), partnumber int, "
             "parttotal int, endtime datetime, INDEX progidx (programid) )";
     createATempTable("dd_schedule", table); 
@@ -635,7 +635,7 @@
             "endtime datetime, title varchar(128), subtitle varchar(128), "
             "description text, category varchar(64), "
             "category_type varchar(64), airdate year, stars float unsigned, "
-            "previouslyshown tinyint, repeat bool, stereo bool, "
+            "previouslyshown tinyint, `repeat` bool, stereo bool, "
             "subtitled bool, hdtv bool,  closecaptioned bool, partnumber int, "
             "parttotal int, seriesid char(12), originalairdate date, "
             "showtype varchar(30), colorcode varchar(20), "