Support database table prefixes

This also cleans up some inconsistencies with quotes.

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

1 files changed, 10 insertions, 6 deletions

diff --git a/application/migrations/004_add_filesize.php b/application/migrations/004_add_filesize.php
index f2367937a..ca10e7dc3 100644
--- a/application/migrations/004_add_filesize.php
+++ b/application/migrations/004_add_filesize.php
@@ -5,28 +5,32 @@ class Migration_Add_filesize extends CI_Migration {
 
 	public function up()
 	{
+		$prefix = $this->db->dbprefix;
+
 		if ($this->db->dbdriver == 'postgre') {
 			$this->db->query('
-				ALTER TABLE "files"
+				ALTER TABLE "'.$prefix.'files"
 				ADD "filesize" integer NOT NULL
 			');
 		} else {
-			$this->db->query("
-				ALTER TABLE `files`
+			$this->db->query('
+				ALTER TABLE `'.$prefix.'files`
 				ADD `filesize` INT UNSIGNED NOT NULL
-			");
+			');
 		}
 	}
 
 	public function down()
 	{
+		$prefix = $this->db->dbprefix;
+
 		if ($this->db->dbdriver == 'postgre') {
 			$this->db->query('
-				ALTER TABLE "files" DROP "filesize"
+				ALTER TABLE "'.$prefix.'files" DROP "filesize"
 			');
 		} else {
 			$this->db->query('
-				ALTER TABLE `files` DROP `filesize`
+				ALTER TABLE `'.$prefix.'files` DROP `filesize`
 			');
 		}
 	}