summaryrefslogtreecommitdiffstats
path: root/application
diff options
context:
space:
mode:
authorPierre Schmitz <pierre@archlinux.de>2013-09-22 09:36:59 +0200
committerFlorian Pritz <bluewind@xinu.at>2013-09-22 11:02:29 +0200
commit8956c3aec70ccc98ce2aa95249fc0d1c70809284 (patch)
treea40f64ba55187b4dfe1a93c12f0c472afba7ef9e /application
parent2f374d188317a30ed51df9647ec1bdc0f36313de (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')
-rw-r--r--application/config/migration.php2
-rw-r--r--application/migrations/010_files_innodb.php16
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()
+ {
+ }
+}