Ticket #7946: mvschema.patch2

Index: dbcheck.cpp
===================================================================
--- dbcheck.cpp (revision 23270)
+++ dbcheck.cpp (working copy)
@@ -88,7 +88,7 @@
     const QString lastMythDVDDBVersion = "1002";
     const QString lastMythVideoVersion = "1010";
 
-    const QString currentDatabaseVersion = "1032";
+    const QString currentDatabaseVersion = "1033";
 
     const QString OldMythVideoVersionName = "VideoDBSchemaVer";
     const QString OldMythDVDVersionName = "DVDDBSchemaVer";
@@ -1154,6 +1154,38 @@
             dbver = "1032";
         }
 
+        if (dbver == "1032")
+        {
+            const char *updates[] = {
+"CREATE TEMPORARY TABLE bad_videometadatacast"
+"       AS SELECT * FROM videometadatacast;",
+"CREATE TEMPORARY TABLE bad_videometadatagenre"
+"       AS SELECT * FROM videometadatagenre;",
+"CREATE TEMPORARY TABLE bad_videometadatacountry"
+"       AS SELECT * FROM videometadatacountry;",
+"TRUNCATE TABLE videometadatacast;",
+"TRUNCATE TABLE videometadatagenre;",
+"TRUNCATE TABLE videometadatacountry;",
+"INSERT videometadatacast SELECT idvideo,idcast"
+"            FROM bad_videometadatacast GROUP BY idvideo,idcast;",
+"INSERT videometadatagenre SELECT idvideo,idgenre"
+"            FROM bad_videometadatagenre GROUP BY idvideo,idgenre;",
+"INSERT videometadatacountry SELECT idvideo,idcountry"
+"            FROM bad_videometadatacountry GROUP BY idvideo,idcountry;",
+"DROP TEMPORARY TABLE bad_videometadatacast;",
+"DROP TEMPORARY TABLE bad_videometadatagenre;",
+"DROP TEMPORARY TABLE bad_videometadatacountry;",
+"ALTER TABLE videometadatacast ADD UNIQUE INDEX (`idvideo`,`idcast`);",
+"ALTER TABLE videometadatagenre ADD UNIQUE INDEX (`idvideo`,`idgenre`);",
+"ALTER TABLE videometadatacountry ADD UNIQUE INDEX (`idvideo`,`idcountry`);",
+NULL
+};
+
+            if (!performActualUpdate(updates, "1033", dbver,
+                                     MythVideoVersionName))
+                return false;
+        }
+
         return true;
     }
 }