summaryrefslogtreecommitdiffstats
path: root/application/migrations/011_apikeys_add_access_level.php
diff options
context:
space:
mode:
Diffstat (limited to 'application/migrations/011_apikeys_add_access_level.php')
-rw-r--r--application/migrations/011_apikeys_add_access_level.php30
1 files changed, 24 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..29a2f769b 100644
--- a/application/migrations/011_apikeys_add_access_level.php
+++ b/application/migrations/011_apikeys_add_access_level.php
@@ -5,15 +5,33 @@ 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`
+ ');
+ }
}
}