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;
 }