[mythtv] [mythtv-commits] Ticket #1315: Move Bookmarks & Cutlist to Recordedmarkup

[John P Poet]

On 3/8/06, Chris Pinkham <cpinkham at bc2va.org> wrote:
> * On Wed Mar 08, 2006 at 09:13:48PM -0700, John P Poet wrote:
> > I can "reload" the original cutlist data back into the recorded table
> > without too much trouble.  After that, though, I am not sure what to
> > do next.  Should I try and force the dbver back to 1128, to trigger
> > the new conversion code?
>
> To reverse the effects of the upgrade so you can reload the data and
> then re-upgrade, you should be able to run the following SQL:
>
> ALTER TABLE recorded CHANGE cutlist cutlist text default "";
> ALTER TABLE recorded CHANGE bookmark bookmark varchar(128) default "";
> UPDATE settings SET data = '1128' WHERE value = 'DBSchemaVer';
>
> Then you can update the cutlist values from your backup and reupgrade
> the database.  Once you're upgraded, you should be able to run a
> query like this:
>
> SELECT chanid, startime, type, mark
>         FROM recordedmarkup
>         WHERE type IN ( 0, 1, 2 );
>
> and that will show all your bookmarks (type 2), and cutlists (1 == start
> of cut and 0 == end of cut).
>
> --
> Chris

You mean "Select chanid, starttime ..." ;-)

Actually, that was quite helpful.  Thank you.

I believe I have all of my cutlists back again.  The "indicator" on
the Watch Recordings screen is missing for all of my old episodes, but
if I try and edit the cutlist, my previous cuts show up.  After I exit
out of "editing", then the "indicator" shows.

Thanks,

John