Added frontend/migrations/027_fix_innodb.py and
tko/migrations/021_fix_innodb.py to perform ALTER TABLE ...
ENGINE=InnoDB on tables missing it.
Signed-off-by: Mihai Rusu <dizzy@google.com>
git-svn-id: http://test.kernel.org/svn/autotest/trunk@2858 592f7852-d20e-0410-864c-8624ca9c26a4
diff --git a/tko/migrations/021_fix_innodb.py b/tko/migrations/021_fix_innodb.py
new file mode 100644
index 0000000..3656567
--- /dev/null
+++ b/tko/migrations/021_fix_innodb.py
@@ -0,0 +1,14 @@
+UP_SQL = """
+ALTER TABLE query_history ENGINE=InnoDB;
+ALTER TABLE test_labels ENGINE=InnoDB;
+ALTER TABLE test_labels_tests ENGINE=InnoDB;
+ALTER TABLE saved_queries ENGINE=InnoDB;
+ALTER TABLE embedded_graphing_queries ENGINE=InnoDB;
+"""
+
+def migrate_up(manager):
+ manager.execute_script(UP_SQL)
+
+
+def migrate_down(manager):
+ pass