[mythtv] mc.sql patch

Joe mythtv-dev@snowman.net
Mon, 23 Dec 2002 06:49:02 -0700


There is a problem with mc.sql in the CVS version. Here is my fix.

--- mc.sql.orig 2002-12-23 06:45:46.000000000 -0700
+++ mc.sql      2002-12-23 06:45:49.000000000 -0700
@@ -48,7 +48,7 @@
     title VARCHAR(128) NULL,
     subtitle VARCHAR(128) NULL,
     description TEXT NULL,
-    profile INT UNSIGNED NOT NULL DEFAULT 0 REFERENCES 
recordingprofiles(id);
+    profile INT UNSIGNED NOT NULL DEFAULT 0 REFERENCES 
recordingprofiles(id),
     PRIMARY KEY (chanid, starttime),
     INDEX (endtime)
 );
@@ -58,7 +58,7 @@
     starttime TIME NOT NULL,
     endtime TIME NOT NULL,
     title VARCHAR(128) NULL,
-    profile INT UNSIGNED NOT NULL DEFAULT 0 REFERENCES 
recordingprofiles(id);
+    profile INT UNSIGNED NOT NULL DEFAULT 0 REFERENCES 
recordingprofiles(id),
     PRIMARY KEY(chanid, starttime),
     INDEX (endtime)
 );