*** mythtv-0.18.1/libs/libmythtv/datadirect.cpp	Sat Oct 22 00:31:51 2005
--- mythtv-0.18.1/libs/libmythtv/datadirect.cpp~	Sat Oct 22 00:40:25 2005
***************
*** 173,181 ****
          QDateTime endtime = curr_schedule.time.addSecs(
                                          QTime().secsTo(curr_schedule.duration));
  
          query.prepare("INSERT INTO dd_schedule (programid,stationid,"
!                       "scheduletime,duration,`repeat`,stereo,subtitled,hdtv,"
                        "closecaptioned,tvrating,partnumber,parttotal,endtime) "
                        "VALUES(:PROGRAMID,:STATIONID,:TIME,:DURATION,"
                        ":REPEAT,:STEREO,:SUBTITLED,:HDTV,:CLOSECAPTIONED,"
                        ":TVRATING,:PARTNUMBER,:PARTTOTAL,:ENDTIME);");
--- 173,181 ----
          QDateTime endtime = curr_schedule.time.addSecs(
                                          QTime().secsTo(curr_schedule.duration));
  
          query.prepare("INSERT INTO dd_schedule (programid,stationid,"
!                       "scheduletime,duration,repeat,stereo,subtitled,hdtv,"
                        "closecaptioned,tvrating,partnumber,parttotal,endtime) "
                        "VALUES(:PROGRAMID,:STATIONID,:TIME,:DURATION,"
                        ":REPEAT,:STEREO,:SUBTITLED,:HDTV,:CLOSECAPTIONED,"
                        ":TVRATING,:PARTNUMBER,:PARTTOTAL,:ENDTIME);");
***************
*** 413,421 ****
                         "originalairdate, showtype, category_type, colorcode, "
                         "syndicatedepisodenumber, tvrating, mpaarating, "
                         "programid) "
                         "SELECT chanid, scheduletime, endtime, title, "
!                        "subtitle, description, year, stars, `repeat`, stereo, "
                         "subtitled, hdtv, closecaptioned, partnumber, "
                         "parttotal, seriesid, originalairdate, showtype, "
                         "category_type, colorcode, syndicatedepisodenumber, "
                         "tvrating, mpaarating, dd_program.programid "
--- 413,421 ----
                         "originalairdate, showtype, category_type, colorcode, "
                         "syndicatedepisodenumber, tvrating, mpaarating, "
                         "programid) "
                         "SELECT chanid, scheduletime, endtime, title, "
!                        "subtitle, description, year, stars, repeat, stereo, "
                         "subtitled, hdtv, closecaptioned, partnumber, "
                         "parttotal, seriesid, originalairdate, showtype, "
                         "category_type, colorcode, syndicatedepisodenumber, "
                         "tvrating, mpaarating, dd_program.programid "
***************
*** 616,624 ****
              "channel char(5), channelMinor char(3) )"; 
      createATempTable ("dd_v_station", table);
  
      table = "( programid char(12), stationid char(12), scheduletime datetime, "
!             "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); 
  
--- 616,624 ----
              "channel char(5), channelMinor char(3) )"; 
      createATempTable ("dd_v_station", table);
  
      table = "( programid char(12), stationid char(12), scheduletime datetime, "
!             "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); 
  
***************
*** 634,642 ****
      table = "( chanid int unsigned NOT NULL, starttime datetime NOT NULL, "
              "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, "
              "subtitled bool, hdtv bool,  closecaptioned bool, partnumber int, "
              "parttotal int, seriesid char(12), originalairdate date, "
              "showtype varchar(30), colorcode varchar(20), "
              "syndicatedepisodenumber varchar(20), programid char(12), "
--- 634,642 ----
      table = "( chanid int unsigned NOT NULL, starttime datetime NOT NULL, "
              "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, "
              "subtitled bool, hdtv bool,  closecaptioned bool, partnumber int, "
              "parttotal int, seriesid char(12), originalairdate date, "
              "showtype varchar(30), colorcode varchar(20), "
              "syndicatedepisodenumber varchar(20), programid char(12), "