Guest User

MythTV Record

a guest
Dec 5th, 2013
30
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. mysql> select * from oldrecorded where title LIKE '%FOX%'\G
  2. *************************** 1. row ***************************
  3. chanid: 1002
  4. starttime: 2013-12-05 15:00:00
  5. endtime: 2013-12-05 16:00:00
  6. title: FOX2 News at 10AM
  7. subtitle:
  8. description:
  9. season: 0
  10. episode: 0
  11. category: News
  12. seriesid: EP01446781
  13. programid: SH014467810000
  14. inetref:
  15. findid: 0
  16. recordid: 349
  17. station: WJBK
  18. rectype: 1
  19. duplicate: 1
  20. recstatus: -3
  21. reactivate: 0
  22. generic: 0
  23. future: 0
  24. *************************** 2. row ***************************
  25. chanid: 1002
  26. starttime: 2013-12-05 16:00:00
  27. endtime: 2013-12-05 17:00:00
  28. title: FOX2 News: Live at 11am
  29. subtitle:
  30. description: Sherry Margolis.
  31. season: 0
  32. episode: 0
  33. category: News
  34. seriesid: EP00775315
  35. programid: SH007753150000
  36. inetref:
  37. findid: 0
  38. recordid: 350
  39. station: WJBK
  40. rectype: 1
  41. duplicate: 0
  42. recstatus: -2
  43. reactivate: 0
  44. generic: 0
  45. future: 0
  46. 2 rows in set (0.01 sec)
  47.  
  48. mysql> select * from recorded where recordid=350\G
  49. *************************** 1. row ***************************
  50. chanid: 1002
  51. starttime: 2013-12-05 16:00:01
  52. endtime: 2013-12-05 17:00:01
  53. title: FOX2 News: Live at 11am
  54. subtitle:
  55. description: Sherry Margolis.
  56. season: 0
  57. episode: 0
  58. category: News
  59. hostname: mythtv1.lan
  60. bookmark: 0
  61. editing: 0
  62. cutlist: 0
  63. autoexpire: 10000
  64. commflagged: 0
  65. recgroup: LiveTV
  66. recordid: 350
  67. seriesid: EP00775315
  68. programid: SH007753150000
  69. inetref:
  70. lastmodified: 2013-12-05 12:00:01
  71. filesize: 1411442524
  72. stars: 0
  73. previouslyshown: 1
  74. originalairdate: 2005-09-12
  75. preserve: 0
  76. findid: 0
  77. deletepending: 0
  78. transcoder: 0
  79. timestretch: 1
  80. recpriority: 0
  81. basename: 1002_20131205160001.mpg
  82. progstart: 2013-12-05 16:00:00
  83. progend: 2013-12-05 17:00:00
  84. playgroup: Default
  85. profile: Default
  86. duplicate: 0
  87. transcoded: 0
  88. watched: 0
  89. storagegroup: LiveTV
  90. bookmarkupdate: 0000-00-00 00:00:00
  91. *************************** 2. row ***************************
  92. chanid: 1002
  93. starttime: 2013-12-05 16:00:00
  94. endtime: 2013-12-05 17:00:30
  95. title: FOX2 News: Live at 11am
  96. subtitle:
  97. description: Sherry Margolis.
  98. season: 0
  99. episode: 0
  100. category: News
  101. hostname: mythtv1.lan
  102. bookmark: 0
  103. editing: 0
  104. cutlist: 0
  105. autoexpire: 1
  106. commflagged: 0
  107. recgroup: LiveTV
  108. recordid: 350
  109. seriesid: EP00775315
  110. programid: SH007753150000
  111. inetref:
  112. lastmodified: 2013-12-05 12:00:30
  113. filesize: 1431619436
  114. stars: 0
  115. previouslyshown: 1
  116. originalairdate: 2005-09-12
  117. preserve: 0
  118. findid: 0
  119. deletepending: 0
  120. transcoder: 0
  121. timestretch: 1
  122. recpriority: 0
  123. basename: 1002_20131205160000.mpg
  124. progstart: 2013-12-05 16:00:00
  125. progend: 2013-12-05 17:00:00
  126. playgroup: Default
  127. profile: Default
  128. duplicate: 0
  129. transcoded: 0
  130. watched: 0
  131. storagegroup: Default
  132. bookmarkupdate: 0000-00-00 00:00:00
  133. 2 rows in set (0.00 sec)
  134.  
  135. mysql>
RAW Paste Data