-Test at Travis and AppVeyor with Postgres.
+In SQLite/Postgres (non-MySQL) mode:
+ In CREATE TABLE:
-In SQLite/Postgres (non-MySQL) mode:
+ Replace AUTO_INCREMENT columns with INTEGER PRIMARY KEY for SQLite or
+ serial for Postgres.
- 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.
- Change TINYINT to SMALLINT. Remove UNSIGNED.
- For Postgres replace int with INTEGER.
+ Remove CHARACTER SET, COLLATE and COMMENT from column definitions.
- Remove CHARACTER SET, COLLATE and COMMENT from column definitions.
+ Remove KEY and index name from UNIQUE KEY:
+ UNIQUE KEY name (columns) -> UNIQUE (columns).
- Remove KEY and inde name from UNIQUE KEY:
- UNIQUE KEY name (columns) -> UNIQUE (columns).
+ Change multicolumn PRIMARY KEY to UNIQUE.
- Change multicolumn PRIMARY KEY to UNIQUE.
+ Remove table options like ENGINE, AUTO_INCREMENT, CHARSET, etc:
+ CREATE TABLE name (column_definitions) table_options.
- 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.
- Convert KEY to CREATE INDEX; remove size limit:
- KEY name ("COLUMN_NAME"(20)) -> CREATE INDEX name ON table ("COLUMN_NAME").
+
+Installers.