rendered paste bodyIndex: 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