Index: libs/libmythtv/dbcheck.cpp
===================================================================
--- libs/libmythtv/dbcheck.cpp (revision 24265)
+++ libs/libmythtv/dbcheck.cpp (working copy)
@@ -20,7 +20,7 @@
mythtv/bindings/python/MythTV/MythStatic.py
*/
/// This is the DB schema version expected by the running MythTV instance.
-
const QString currentDatabaseVersion =
"1254";
+
const QString currentDatabaseVersion =
"1255";
static bool UpdateDBVersionNumber
(const QString &newnumber
);
static bool performActualUpdate(
@@ -543,6 +543,11 @@
* versions.
*
*/
+// changed by m bennett 18/04/10
+//
+// if (dbver == "1254")
+// This inserts a table called dvdtranscodejobs which
+// allows transcode jobs to be resumed on an mtd failure
static bool doUpgradeTVDatabaseSchema(void)
{
QString dbver = gContext->GetSetting
("DBSchemaVer");
@@ -5177,8 +5182,37 @@
if (!performActualUpdate(updates, "1254", dbver))
return false;
}
+ // i did this
+ if (!UpdateDBVersionNumber("1254"))
+ return false;
+
+ dbver = "1254";
}
+ // This allows transcode jobs to be resumed on an mtd failure
+ if (dbver == "1254")
+ {
+ {
+ const char *updates[] = {
+ "CREATE TABLE IF NOT EXISTS dvdtranscodejobs ("
+ "jobindex int(11) NOT NULL, "
+ "final_dir_and_file varchar(255) NOT NULL, "
+ "getTrack int(11) NOT NULL, "
+ "getAudio int(11) NOT NULL, "
+ "getQuality int(11) NOT NULL, "
+ "getAC3 int(11) NOT NULL, "
+ "getSubTitle int(11) NOT NULL, "
+ "state int(11) NOT NULL, "
+ "backend varchar(255) NOT NULL, "
+ "PRIMARY KEY (jobindex), "
+ "KEY jobindex (jobindex));"
+ , NULL
+ };
+ if (!performActualUpdate(updates, "1255", dbver))
+ return false;
+ }
+ }
+
return true;
}