+ Remove table options like ENGINE, AUTO_INCREMENT, CHARSET, etc:
+ CREATE TABLE name (column_definitions) table_options.
+
+ Convert KEY to CREATE INDEX; remove size limit:
+ KEY name ("COLUMN_NAME"(20)) ->
+ CREATE INDEX name ON table ("COLUMN_NAME").