From: Oleg Broytman Date: Wed, 10 May 2017 22:25:27 +0000 (+0300) Subject: TODO: more MySQL-specific fixes X-Git-Tag: 0.2.2~7 X-Git-Url: https://git.phdru.name/?p=sqlconvert.git;a=commitdiff_plain;h=8d8db254ec4dd4199864a69ce44768de4689f7f6 TODO: more MySQL-specific fixes [skip ci] --- diff --git a/TODO b/TODO index bd62d16..dba3442 100644 --- a/TODO +++ b/TODO @@ -3,6 +3,11 @@ Test at Travis and AppVeyor with Postgres. In SQLite/Postgres (non-MySQL) mode: + Replace AUTO_INCREMENT columns with INTEGER PRIMARY KEY for SQLite or + serial for Postgres. + + Remove CHARACTER SET, COLLATE and COMMENT from column definitions. + Remove table options like ENGINE, AUTO_INCREMENT, CHARSET, etc: CREATE TABLE name (column_definitions) table_options;