Support for MySQL 5.5+

Use ENGINE instead of TYPE. TYPE was deprecated and ENGINE was added in
MySQL 4.0. TYPE was removed in MySQL 5.5.