View | Details | Raw Unified
Collapse All | Expand All

(-) libs.old/libmythtv/datadirect.cpp (-6 / +6 lines)
 Lines 174-189    Link Here  
                                        QTime().secsTo(curr_schedule.duration));
                                        QTime().secsTo(curr_schedule.duration));

        
        query.prepare("INSERT INTO dd_schedule (programid,stationid,"
        query.prepare("INSERT INTO dd_schedule (programid,stationid,"

            

              
                      "scheduletime,duration,repeat,stereo,subtitled,hdtv,"

              
                      "scheduletime,duration,isrepeat,stereo,subtitled,hdtv,"

            

        
                      "closecaptioned,tvrating,partnumber,parttotal,endtime) "
                      "closecaptioned,tvrating,partnumber,parttotal,endtime) "

        
                      "VALUES(:PROGRAMID,:STATIONID,:TIME,:DURATION,"
                      "VALUES(:PROGRAMID,:STATIONID,:TIME,:DURATION,"

            

              
                      ":REPEAT,:STEREO,:SUBTITLED,:HDTV,:CLOSECAPTIONED,"

              
                      ":ISREPEAT,:STEREO,:SUBTITLED,:HDTV,:CLOSECAPTIONED,"

            

        
                      ":TVRATING,:PARTNUMBER,:PARTTOTAL,:ENDTIME);");
                      ":TVRATING,:PARTNUMBER,:PARTTOTAL,:ENDTIME);");

        
        query.bindValue(":PROGRAMID", curr_schedule.programid);
        query.bindValue(":PROGRAMID", curr_schedule.programid);

        
        query.bindValue(":STATIONID", curr_schedule.stationid);
        query.bindValue(":STATIONID", curr_schedule.stationid);

        
        query.bindValue(":TIME", curr_schedule.time);
        query.bindValue(":TIME", curr_schedule.time);

        
        query.bindValue(":DURATION", curr_schedule.duration);
        query.bindValue(":DURATION", curr_schedule.duration);

            

              
        query.bindValue(":REPEAT", curr_schedule.repeat);

              
        query.bindValue(":ISREPEAT", curr_schedule.repeat);

            

        
        query.bindValue(":STEREO", curr_schedule.stereo);
        query.bindValue(":STEREO", curr_schedule.stereo);

        
        query.bindValue(":SUBTITLED", curr_schedule.subtitled);
        query.bindValue(":SUBTITLED", curr_schedule.subtitled);

        
        query.bindValue(":HDTV", curr_schedule.hdtv);
        query.bindValue(":HDTV", curr_schedule.hdtv);

  

    

    

       Lines 414-420
       
    
  Link Here 
    

  

        
                       "syndicatedepisodenumber, tvrating, mpaarating, "
                       "syndicatedepisodenumber, tvrating, mpaarating, "

        
                       "programid) "
                       "programid) "

        
                       "SELECT chanid, scheduletime, endtime, title, "
                       "SELECT chanid, scheduletime, endtime, title, "

            

              
                       "subtitle, description, year, stars, repeat, stereo, "

              
                       "subtitle, description, year, stars, isrepeat, stereo, "

            

        
                       "subtitled, hdtv, closecaptioned, partnumber, "
                       "subtitled, hdtv, closecaptioned, partnumber, "

        
                       "parttotal, seriesid, originalairdate, showtype, "
                       "parttotal, seriesid, originalairdate, showtype, "

        
                       "category_type, colorcode, syndicatedepisodenumber, "
                       "category_type, colorcode, syndicatedepisodenumber, "

  

    

    

       Lines 617-623
       
    
  Link Here 
    

  

        
    createATempTable ("dd_v_station", table);
    createATempTable ("dd_v_station", table);

        

        
    table = "( programid char(12), stationid char(12), scheduletime datetime, "
    table = "( programid char(12), stationid char(12), scheduletime datetime, "

            

              
            "duration time, repeat bool, stereo bool, subtitled bool, "

              
            "duration time, isrepeat bool, stereo bool, subtitled bool, "

            

        
            "hdtv bool, closecaptioned bool, tvrating char(5), partnumber int, "
            "hdtv bool, closecaptioned bool, tvrating char(5), partnumber int, "

        
            "parttotal int, endtime datetime, INDEX progidx (programid) )";
            "parttotal int, endtime datetime, INDEX progidx (programid) )";

        
    createATempTable("dd_schedule", table); 
    createATempTable("dd_schedule", table); 

  

    

    

       Lines 635-641
       
    
  Link Here 
    

  

        
            "endtime datetime, title varchar(128), subtitle varchar(128), "
            "endtime datetime, title varchar(128), subtitle varchar(128), "

        
            "description text, category varchar(64), "
            "description text, category varchar(64), "

        
            "category_type varchar(64), airdate year, stars float unsigned, "
            "category_type varchar(64), airdate year, stars float unsigned, "

            

              
            "previouslyshown tinyint, repeat bool, stereo bool, "

              
            "previouslyshown tinyint, isrepeat bool, stereo bool, "

            

        
            "subtitled bool, hdtv bool,  closecaptioned bool, partnumber int, "
            "subtitled bool, hdtv bool,  closecaptioned bool, partnumber int, "

        
            "parttotal int, seriesid char(12), originalairdate date, "
            "parttotal int, seriesid char(12), originalairdate date, "

        
            "showtype varchar(30), colorcode varchar(20), "
            "showtype varchar(30), colorcode varchar(20), "