diff options
| author | Florian Pritz <bluewind@xinu.at> | 2015-09-20 16:03:22 +0200 |
|---|---|---|
| committer | Florian Pritz <bluewind@xinu.at> | 2015-09-20 16:03:22 +0200 |
| commit | 7da9de48d2b3bbb0309d6311e4dc7d275d3bf26d (patch) | |
| tree | bc90956bccaad107255e350ed29cad242eede5cc /application/migrations/012_add_constraints.php | |
| parent | f149a0d1abb4a79b1d5de9ddb5963b2eab4b126d (diff) | |
| parent | e79c1c45dcd23dde1f4b072993829cc008f4858b (diff) | |
Merge branch 'postgres' into dev
Diffstat (limited to 'application/migrations/012_add_constraints.php')
| -rw-r--r-- | application/migrations/012_add_constraints.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/application/migrations/012_add_constraints.php b/application/migrations/012_add_constraints.php index 40a4540f6..a2569d54d 100644 --- a/application/migrations/012_add_constraints.php +++ b/application/migrations/012_add_constraints.php @@ -10,7 +10,7 @@ class Migration_add_constraints extends CI_Migration { if ($this->db->dbdriver == 'postgre') { $this->db->query('ALTER TABLE "'.$prefix.'users" ALTER COLUMN "referrer" TYPE integer'); $this->db->query('ALTER TABLE "'.$prefix.'users" ALTER COLUMN "referrer" DROP NOT NULL'); - $this->db->query('CREATE INDEX "users_referrer_idx" ON "'.$prefix.'users" ("referrer")'); + $this->db->query('CREATE INDEX "'.$prefix.'users_referrer_idx" ON "'.$prefix.'users" ("referrer")'); $this->db->query('UPDATE "'.$prefix.'users" SET "referrer" = NULL where "referrer" = 0'); $this->db->query(' ALTER TABLE "'.$prefix.'users" |