[mythtv] 0-7 to 0-8 sql , recordingprofiles

John mythtv-dev@snowman.net
Mon, 16 Dec 2002 10:52:42 -0500 (EST)


The 0-7-to-0-8.sql sets all profiles to 0 (CVS log says this is now default):

UPDATE allrecord SET profile = 0;
UPDATE singlerecord SET profile = 0;
UPDATE timeslotrecord SET profile = 0;

However the last two lines:

INSERT INTO recordingprofiles (name) VALUES ('Default');
INSERT INTO recordingprofiles (name) VALUES ('Live TV');

create entries with ids of 1 and 2

mysql>  select * from recordingprofiles;
+----+---------+------------+------------+
| id | name    | videocodec | audiocodec |
+----+---------+------------+------------+
|  1 | Default | NULL       | NULL       |
|  2 | Live TV | NULL       | NULL       |
+----+---------+------------+------------+
2 rows in set (0.00 sec)

Is this correct? or should the id for Default be 0 and Live TV 1?

Maybe:

INSERT INTO recordingprofiles (id,name) VALUES (0,'Default');
INSERT INTO recordingprofiles (id,name) VALUES (1,'Live TV');

John