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