[mythtv] [PATCH] Add transcoding support (final)

[Geoffrey Hausheer]

On Sun, 20 Apr 2003 10:30:17 -0400, "Isaac Richards ijr-at-po.cwru.edu
|mythtv/1.0-Allow|" <e6kbhbk35r0t at sneakemail.com> said:
 
> > 5) I noticed you didn't include the control to enable the transcoders in
> > mythfrontend (or the cvs.sql).  I'm just curious why not.
> 
> I need to talk with mdz 'bout stealing profile 3 like that -- I, at
> least, 
> already have that number used by something else.

Here is a better cvs.sql fix.  the profile # doesn't need to be '3' since
we always access it by name.
It is a bit messy, since update doesn't support multiple tables for mysql
< 4.04

------
CREATE TABLE IF NOT EXISTS transcoding (
    chanid INT NOT NULL,
    starttime TIMESTAMP,
    isdone INT UNSIGNED NOT NULL DEFAULT 0
);

INSERT INTO recordingprofiles (name,videocodec,audiocodec) VALUES
('Transco
de','MPEG-4','MP3');

CREATE TEMPORARY TABLE tempcodec SELECT codecparams.* FROM 
codecparams,recordingprofiles WHERE codecparams.profile =
recordingprofiles.id 
AND recordingprofiles.name = 'Default';

CREATE TEMPORARY TABLE tempcodec1 (
     profile INT UNSIGNED,
     name CHAR(128),
     value CHAR(128)
);

INSERT INTO tempcodec1 SELECT
recordingprofiles.id,tempcodec.name,tempcodec.value
    FROM recordingprofiles,tempcodec WHERE recordingprofiles.name =
    'Transcode';

INSERT INTO codecparams SELECT * FROM tempcodec1;
DROP TABLE tempcodec;
DROP TABLE tempcodec1;