diff options
author | Pierre Schmitz <pierre@archlinux.de> | 2013-09-22 09:36:59 +0200 |
---|---|---|
committer | Florian Pritz <bluewind@xinu.at> | 2013-09-22 11:02:29 +0200 |
commit | 8956c3aec70ccc98ce2aa95249fc0d1c70809284 (patch) | |
tree | a40f64ba55187b4dfe1a93c12f0c472afba7ef9e /application/migrations/010_files_innodb.php | |
parent | 2f374d188317a30ed51df9647ec1bdc0f36313de (diff) |
Use InnoDB for the files table
The files table was MyISAM even though all other tables were InnoDB.
We should avoid mixing types here (backups, transactions and performance).
Signed-off-by: Pierre Schmitz <pierre@archlinux.de>
Signed-off-by: Florian Pritz <bluewind@xinu.at>
Diffstat (limited to 'application/migrations/010_files_innodb.php')
-rw-r--r-- | application/migrations/010_files_innodb.php | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/application/migrations/010_files_innodb.php b/application/migrations/010_files_innodb.php new file mode 100644 index 000000000..b32f94724 --- /dev/null +++ b/application/migrations/010_files_innodb.php @@ -0,0 +1,16 @@ +<?php +defined('BASEPATH') OR exit('No direct script access allowed'); + +class Migration_files_innodb extends CI_Migration { + + public function up() + { + $this->db->query(" + ALTER TABLE `files` ENGINE = InnoDB; + "); + } + + public function down() + { + } +} |