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

[Chris Pinkham]

* 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