diff -r 5295d495a114 MySQL/Plugins/MySQLIndex.cpp
--- a/MySQL/Plugins/MySQLIndex.cpp
+++ b/MySQL/Plugins/MySQLIndex.cpp
@@ -503,7 +503,15 @@
     {
       DatabaseManager::CachedStatement lookupResourcesToDelete(
         STATEMENT_FROM_HERE, manager,
-        "CREATE TEMPORARY TABLE DeletedResources SELECT * FROM (SELECT internalId, resourceType, publicId FROM Resources WHERE internalId=${id} OR parentId=${id} OR parentId IN (SELECT internalId FROM Resources WHERE parentId=${id}) OR parentId IN (SELECT internalId FROM Resources WHERE parentId IN (SELECT internalId FROM Resources WHERE parentId=${id}))) AS t");
+        "CREATE TEMPORARY TABLE DeletedResources ("
+        "internalId BIGINT PRIMARY KEY, "
+        "resourceType INTEGER, "
+        "publicId VARCHAR(64)) "
+        "SELECT internalId, resourceType, publicId FROM Resources "
+        "WHERE internalId=${id} OR parentId=${id} "
+        "OR parentId IN (SELECT internalId FROM Resources WHERE parentId=${id}) "
+        "OR parentId IN (SELECT internalId FROM Resources WHERE parentId IN "
+        "(SELECT internalId FROM Resources WHERE parentId=${id}))");
       lookupResourcesToDelete.SetParameterType("id", ValueType_Integer64);

       Dictionary args;
diff -r 5295d495a114 MySQL/Plugins/PrepareIndex.sql
--- a/MySQL/Plugins/PrepareIndex.sql
+++ b/MySQL/Plugins/PrepareIndex.sql
@@ -105,7 +105,8 @@
        uncompressedSize BIGINT,        -- 3
        compressionType INTEGER,        -- 4
        uncompressedHash VARCHAR(40),   -- 5
-       compressedHash VARCHAR(40)      -- 6
+       compressedHash VARCHAR(40),     -- 6
+       PRIMARY KEY (`uuid`)
        -- revision INTEGER,          -- new in v 4.X, added in MySQLIndex::ConfigureDatabase
        -- customData LONGTEXT,       -- new in v 4.X, added in MySQLIndex::ConfigureDatabase
        );