In SQLite/Postgres (non-MySQL) mode: In CREATE TABLE: Replace AUTO_INCREMENT columns with INTEGER PRIMARY KEY for SQLite or serial for Postgres. Change TINYINT to SMALLINT. Remove UNSIGNED. For Postgres replace int with INTEGER. Remove CHARACTER SET, COLLATE and COMMENT from column definitions. Remove KEY and index name from UNIQUE KEY: UNIQUE KEY name (columns) -> UNIQUE (columns). Change multicolumn PRIMARY KEY to UNIQUE. 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"). Remove LOCK/UNLOCK TABLES. Installers.