1 In SQLite/Postgres (non-MySQL) mode:
3 Replace AUTO_INCREMENT columns with INTEGER PRIMARY KEY for SQLite or
6 Change TINYINT to SMALLINT. Remove UNSIGNED.
7 For Postgres replace int with INTEGER.
9 Remove CHARACTER SET, COLLATE and COMMENT from column definitions.
11 Remove KEY and inde name from UNIQUE KEY:
12 UNIQUE KEY name (columns) -> UNIQUE (columns).
14 Change multicolumn PRIMARY KEY to UNIQUE.
16 Remove table options like ENGINE, AUTO_INCREMENT, CHARSET, etc:
17 CREATE TABLE name (column_definitions) table_options.
19 Remove LOCK/UNLOCK TABLES.
21 Convert KEY to CREATE INDEX; remove size limit:
22 KEY name ("COLUMN_NAME"(20)) -> CREATE INDEX name ON table ("COLUMN_NAME").