[mythtv-users] Manually inserting "recorded programs" into the DB and commercial flagging

[Iohan Reyes]

I have a little bit of a background on mysql so I decided to poke around
in the mythconverg database.  I'm starting to understand how the tables
relate to one another, but am still learning.  My specific question and
the subject of this email is what table and which fields are absolutely
necessary to fill-in with information so that I can commercial flag an
mpeg file that was recorded from outside of mythtv?

Here's the scenario, I have recorded a few programs on my Tivo and
extracted them as mpeg files onto my MythTV box.  I have figured out how
to make them show up in the "Watch Recordings" list by inserting rows in
the 'recorded' table.  The reason I want them in "Watch Recordings"
instead of in "Watch Videos" are purely for convenience and less
confusion for other family members.  Now, the last step I would like to
accomplish is to commflag the mpeg files, but I'm not sure which other
tables need to be populated with what info to make this possible.