[mythtv] [mythtv-commits] Ticket #1315: Move Bookmarks & Cutlist to Recordedmarkup
John P Poet
jppoet at gmail.com
Thu Mar 9 05:19:20 UTC 2006
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
More information about the mythtv-dev
mailing list