[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