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 | |
| 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>
| -rw-r--r-- | application/config/migration.php | 2 | ||||
| -rw-r--r-- | application/migrations/010_files_innodb.php | 16 |
2 files changed, 17 insertions, 1 deletions
diff --git a/application/config/migration.php b/application/config/migration.php index 5fef0ad40..6cfd09a30 100644 --- a/application/config/migration.php +++ b/application/config/migration.php @@ -21,7 +21,7 @@ $config['migration_enabled'] = true; | be upgraded / downgraded to. | */ -$config['migration_version'] = 9; +$config['migration_version'] = 10; /* 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() + { + } +} |