| Subject: | use ENGINE instead of TYPE for storage engine name |
The TYPE keyword is deprecated since MySQL 4.0 and was dropped in 5.5.
Its synonym ENGINE should be used instead.
| Subject: | ENGINE_instead_of_TYPE.patch |
Index: DBIx-Migration-Directories-0.08/schema/mysql/0.01/100_schema_version.sql
===================================================================
--- DBIx-Migration-Directories-0.08.orig/schema/mysql/0.01/100_schema_version.sql 2008-11-18 20:41:54.000000000 +0100
+++ DBIx-Migration-Directories-0.08/schema/mysql/0.01/100_schema_version.sql 2013-02-06 11:48:08.948994465 +0100
@@ -1,4 +1,4 @@
CREATE TABLE migration_schema_version (
name VARCHAR(128) NOT NULL PRIMARY KEY,
version REAL NOT NULL
-) TYPE=InnoDB;
+) ENGINE=InnoDB;
Index: DBIx-Migration-Directories-0.08/schema/mysql/0.01/200_schema_log.sql
===================================================================
--- DBIx-Migration-Directories-0.08.orig/schema/mysql/0.01/200_schema_log.sql 2008-11-18 20:41:54.000000000 +0100
+++ DBIx-Migration-Directories-0.08/schema/mysql/0.01/200_schema_log.sql 2013-02-06 11:48:38.021875765 +0100
@@ -11,5 +11,5 @@ CREATE TABLE migration_schema_log (
REFERENCES migration_schema_version (name)
ON UPDATE CASCADE
ON DELETE CASCADE
-) TYPE=InnoDB;
+) ENGINE=InnoDB;