All pastes #250870 Raw Edit

Mine

public text v1 · immutable
#250870 ·published 2006-11-17 13:51 UTC
rendered paste body
Index: libs/libmythtv/dbcheck.cpp
===================================================================
--- libs/libmythtv/dbcheck.cpp	(revision 11768)
+++ libs/libmythtv/dbcheck.cpp	(working copy)
@@ -10,7 +10,7 @@
 #include "mythdbcon.h"
 
 /// This is the DB schema version expected by the running MythTV instance.
-const QString currentDatabaseVersion = "1167";
+const QString currentDatabaseVersion = "1168";
 
 static bool UpdateDBVersionNumber(const QString &newnumber);
 static bool performActualUpdate(const QString updates[], QString version,
@@ -2651,6 +2651,25 @@
             return false;
     }
 
+    if (dbver == "1167")
+    {
+        const QString updates[] = {
+"CREATE TABLE IF NOT EXISTS dvdbookmark ("
+"   serialid varchar(16) NOT NULL default '',"
+"   name varchar(32) default NULL,"
+"   title smallint(6) NOT NULL default 0,"
+"   audionum tinyint(4) NOT NULL default -1,"
+"   subtitlenum tinyint(4) NOT NULL default -1,"
+"   framenum bigint(20) NOT NULL default 0,"
+"   timestamp timestamp NOT NULL default "
+"   CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,"
+"   PRIMARY KEY (serialid));",
+"",
+};
+
+        if (!performActualUpdate(updates, "1168", dbver))
+            return false;
+    }
 //"ALTER TABLE cardinput DROP COLUMN preference;" in 0.22
 //"ALTER TABLE channel DROP COLUMN atscsrcid;" in 0.22
 //"ALTER TABLE recordedmarkup DROP COLUMN offset;" in 0.22