diff options
| -rw-r--r-- | application/migrations/014_deduplicate_file_storage.php | 12 | ||||
| -rw-r--r-- | application/migrations/015_actually_deduplicate_file_storage.php | 12 |
2 files changed, 12 insertions, 12 deletions
diff --git a/application/migrations/014_deduplicate_file_storage.php b/application/migrations/014_deduplicate_file_storage.php index a1ea4fab4..133fbbab7 100644 --- a/application/migrations/014_deduplicate_file_storage.php +++ b/application/migrations/014_deduplicate_file_storage.php @@ -40,18 +40,18 @@ class Migration_deduplicate_file_storage extends CI_Migration { // XXX: This query also exists in migration 15 $this->db->query(' - DELETE file_storage - FROM file_storage - LEFT OUTER JOIN files ON files.file_storage_id = file_storage.id - WHERE file_storage.id NOT IN ( + DELETE `'.$prefix.'file_storage` + FROM `'.$prefix.'file_storage` + LEFT OUTER JOIN `'.$prefix.'files` ON `'.$prefix.'files`.file_storage_id = `'.$prefix.'file_storage`.id + WHERE `'.$prefix.'file_storage`.id NOT IN ( SELECT min(x.id) FROM ( SELECT fs.id, fs.hash - FROM file_storage fs + FROM `'.$prefix.'file_storage` fs ) x GROUP BY x.hash ) - AND files.id IS NULL + AND `'.$prefix.'files`.id IS NULL '); $chunk = 500; diff --git a/application/migrations/015_actually_deduplicate_file_storage.php b/application/migrations/015_actually_deduplicate_file_storage.php index 8f2a51c74..2fea26dab 100644 --- a/application/migrations/015_actually_deduplicate_file_storage.php +++ b/application/migrations/015_actually_deduplicate_file_storage.php @@ -13,18 +13,18 @@ class Migration_actually_deduplicate_file_storage extends CI_Migration { } else { // XXX: This query also exists in migration 14 $this->db->query(' - DELETE file_storage - FROM file_storage - LEFT OUTER JOIN files ON files.file_storage_id = file_storage.id - WHERE file_storage.id NOT IN ( + DELETE `'.$prefix.'file_storage` + FROM `'.$prefix.'file_storage` + LEFT OUTER JOIN `'.$prefix.'files` ON `'.$prefix.'files`.file_storage_id = `'.$prefix.'file_storage`.id + WHERE `'.$prefix.'file_storage`.id NOT IN ( SELECT min(x.id) FROM ( SELECT fs.id, fs.hash - FROM file_storage fs + FROM `'.$prefix.'file_storage` fs ) x GROUP BY x.hash ) - AND files.id IS NULL + AND `'.$prefix.'files`.id IS NULL '); $chunk = 500; |