Support database table prefixes

This also cleans up some inconsistencies with quotes.

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

1 files changed, 9 insertions, 5 deletions

diff --git a/application/migrations/006_add_username_index.php b/application/migrations/006_add_username_index.php
index 5b8c3584f..0e6dc7650 100644
--- a/application/migrations/006_add_username_index.php
+++ b/application/migrations/006_add_username_index.php
@@ -5,25 +5,29 @@ class Migration_Add_username_index extends CI_Migration {
 
 	public function up()
 	{
+		$prefix = $this->db->dbprefix;
+
 		if ($this->db->dbdriver == 'postgre') {
 			$this->db->query('
-				CREATE UNIQUE INDEX "users_username_idx" ON "users" ("username")
+				CREATE UNIQUE INDEX "users_username_idx" ON "'.$prefix.'users" ("username")
 			');
 		} else {
-			$this->db->query("
-				ALTER TABLE `users`
+			$this->db->query('
+				ALTER TABLE `'.$prefix.'users`
 				ADD UNIQUE `username` (`username`);
-			");
+			');
 		}
 	}
 
 	public function down()
 	{
+		$prefix = $this->db->dbprefix;
+
 		if ($this->db->dbdriver == 'postgre') {
 			$this->db->query('DROP INDEX "users_username_idx"');
 		} else {
 			$this->db->query("
-				ALTER TABLE `users`
+				ALTER TABLE `'.$prefix.'users`
 				DROP INDEX `username`;
 			");
 		}