if (dbver == "1141") { const QString updates[] = { "ALTER TABLE recordedmarkup DROP PRIMARY KEY, ADD PRIMARY KEY (chanid,starttime,type,mark);", "ALTER TABLE recordedmarkup ADD INDEX (type);", "CREATE TABLE IF NOT EXISTS recordedseek (" " chanid int(10) unsigned NOT NULL default '0'," " starttime datetime NOT NULL default '0000-00-00 00:00:00'," " mark bigint(20) NOT NULL default '0'," " offset varchar(32) default NULL," " type int(11) NOT NULL default '0'," " PRIMARY KEY (chanid,starttime,type)" ");"," "INSERT INTO recordedseek (chanid, starttime, mark, offset, type) SELECT" " chanid, starttime, mark, offset, type FROM recordedmarkup WHERE type in (6, 7, 9);", "ALTER TABLE recordedmarkup DROP INDEX (type);", "ALTER TABLE recordedmarkup DROP COLUMN offset;", "", };