summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorFlorian Pritz <bluewind@xinu.at>2014-04-15 11:01:01 +0200
committerFlorian Pritz <bluewind@xinu.at>2014-04-15 11:01:01 +0200
commitc64f4b6ce6f1d9c5d99eecd8b7bf23432e969ade (patch)
tree9613b98d1d60ee6d82b3cf5f66811a9566597fd9
parent33fcec4e103ff84845497db513ae0deb8658d96b (diff)
Use alter table to rename tables
For some strange reason using "rename table" causes an exception in system/database/DB_driver.php:query() because it trys to call num_rows() on a boolean. Using "alter table" works. According to the php manpage mysqli::query() it should return a boolean too, but whatever... Signed-off-by: Florian Pritz <bluewind@xinu.at>
-rw-r--r--application/migrations/007_repurpose_invitations.php4
1 files changed, 2 insertions, 2 deletions
diff --git a/application/migrations/007_repurpose_invitations.php b/application/migrations/007_repurpose_invitations.php
index 36d3007e8..d586c2829 100644
--- a/application/migrations/007_repurpose_invitations.php
+++ b/application/migrations/007_repurpose_invitations.php
@@ -17,7 +17,7 @@ class Migration_Repurpose_invitations extends CI_Migration {
");
$this->db->query("
- RENAME TABLE `invitations` TO `actions` ;
+ ALTER TABLE `invitations` RENAME `actions`;
");
}
@@ -25,7 +25,7 @@ class Migration_Repurpose_invitations extends CI_Migration {
public function down()
{
$this->db->query("
- RENAME TABLE `actions` TO `invitations` ;
+ ALTER TABLE `actions` RENAME `invitations`;
");
$this->db->query("