Merge branch 'pgsql_migrations'

* pgsql_migrations:
  Optimizing multipaste tables
  apikeys.created should be timestamp with default now()
  No column based encoding. Reverting dbforge migration
  Correcting bracket style for 'if'
  Migrations support for PostgreSQL

1 files changed, 18 insertions, 6 deletions

diff --git a/application/migrations/011_apikeys_add_access_level.php b/application/migrations/011_apikeys_add_access_level.php
index e0f39317b..2fdbc7271 100644
--- a/application/migrations/011_apikeys_add_access_level.php
+++ b/application/migrations/011_apikeys_add_access_level.php
@@ -5,15 +5,27 @@ class Migration_apikeys_add_access_level extends CI_Migration {
 
 	public function up()
 	{
-		$this->db->query("
-			alter table `apikeys` add `access_level` varchar(255) default 'apikey';
-		");
+		if ($this->db->dbdriver == 'postgre') {
+			$this->db->query('
+				alter table "apikeys" add "access_level" varchar(255) default \'apikey\'
+			');
+		} else {
+			$this->db->query("
+				alter table `apikeys` add `access_level` varchar(255) default 'apikey';
+			");
+		}
 	}
 
 	public function down()
 	{
-		$this->db->query("
-			alter table `apikeys` drop `access_level`;
-		");
+		if ($this->db->dbdriver == 'postgre') {
+			$this->db->query('
+				alter table "apikeys" drop "access_level"
+			');
+		} else {
+			$this->db->query('
+				alter table `apikeys` drop `access_level`
+			');
+		}
 	}
 }