|
Lines 174-180
Link Here
|
| 174 |
QTime().secsTo(curr_schedule.duration)); |
174 |
QTime().secsTo(curr_schedule.duration)); |
| 175 |
|
175 |
|
| 176 |
query.prepare("INSERT INTO dd_schedule (programid,stationid," |
176 |
query.prepare("INSERT INTO dd_schedule (programid,stationid," |
| 177 |
"scheduletime,duration,repeat,stereo,subtitled,hdtv," |
177 |
"scheduletime,duration,`repeat`,stereo,subtitled,hdtv," |
| 178 |
"closecaptioned,tvrating,partnumber,parttotal,endtime) " |
178 |
"closecaptioned,tvrating,partnumber,parttotal,endtime) " |
| 179 |
"VALUES(:PROGRAMID,:STATIONID,:TIME,:DURATION," |
179 |
"VALUES(:PROGRAMID,:STATIONID,:TIME,:DURATION," |
| 180 |
":REPEAT,:STEREO,:SUBTITLED,:HDTV,:CLOSECAPTIONED," |
180 |
":REPEAT,:STEREO,:SUBTITLED,:HDTV,:CLOSECAPTIONED," |
|
Lines 414-420
Link Here
|
| 414 |
"syndicatedepisodenumber, tvrating, mpaarating, " |
414 |
"syndicatedepisodenumber, tvrating, mpaarating, " |
| 415 |
"programid) " |
415 |
"programid) " |
| 416 |
"SELECT chanid, scheduletime, endtime, title, " |
416 |
"SELECT chanid, scheduletime, endtime, title, " |
| 417 |
"subtitle, description, year, stars, repeat, stereo, " |
417 |
"subtitle, description, year, stars, `repeat`, stereo, " |
| 418 |
"subtitled, hdtv, closecaptioned, partnumber, " |
418 |
"subtitled, hdtv, closecaptioned, partnumber, " |
| 419 |
"parttotal, seriesid, originalairdate, showtype, " |
419 |
"parttotal, seriesid, originalairdate, showtype, " |
| 420 |
"category_type, colorcode, syndicatedepisodenumber, " |
420 |
"category_type, colorcode, syndicatedepisodenumber, " |
|
Lines 617-623
Link Here
|
| 617 |
createATempTable ("dd_v_station", table); |
617 |
createATempTable ("dd_v_station", table); |
| 618 |
|
618 |
|
| 619 |
table = "( programid char(12), stationid char(12), scheduletime datetime, " |
619 |
table = "( programid char(12), stationid char(12), scheduletime datetime, " |
| 620 |
"duration time, repeat bool, stereo bool, subtitled bool, " |
620 |
"duration time, `repeat` bool, stereo bool, subtitled bool, " |
| 621 |
"hdtv bool, closecaptioned bool, tvrating char(5), partnumber int, " |
621 |
"hdtv bool, closecaptioned bool, tvrating char(5), partnumber int, " |
| 622 |
"parttotal int, endtime datetime, INDEX progidx (programid) )"; |
622 |
"parttotal int, endtime datetime, INDEX progidx (programid) )"; |
| 623 |
createATempTable("dd_schedule", table); |
623 |
createATempTable("dd_schedule", table); |
|
Lines 635-641
Link Here
|
| 635 |
"endtime datetime, title varchar(128), subtitle varchar(128), " |
635 |
"endtime datetime, title varchar(128), subtitle varchar(128), " |
| 636 |
"description text, category varchar(64), " |
636 |
"description text, category varchar(64), " |
| 637 |
"category_type varchar(64), airdate year, stars float unsigned, " |
637 |
"category_type varchar(64), airdate year, stars float unsigned, " |
| 638 |
"previouslyshown tinyint, repeat bool, stereo bool, " |
638 |
"previouslyshown tinyint, `repeat` bool, stereo bool, " |
| 639 |
"subtitled bool, hdtv bool, closecaptioned bool, partnumber int, " |
639 |
"subtitled bool, hdtv bool, closecaptioned bool, partnumber int, " |
| 640 |
"parttotal int, seriesid char(12), originalairdate date, " |
640 |
"parttotal int, seriesid char(12), originalairdate date, " |
| 641 |
"showtype varchar(30), colorcode varchar(20), " |
641 |
"showtype varchar(30), colorcode varchar(20), " |
