[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)
);