Fix missing db prefix in migration0.9.0

Signed-off-by: Florian Pritz <bluewind@xinu.at>

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;