Handle AUTOINCREMENT modification detection in revision auto-generation

Describe the use case
Unless I'm mistaken, toggling the autoincrement attribute of a table column is not detected by the revision auto-generation.

Databases / Backends / Drivers targeted
My usecase is for MySQL databases, but I guess it would be nice to have for any DB that supports this feature (although I'm not familiar with which DBs that would be).

Example Use
Migrate from

CREATE TABLE `FOO` (
  `ID` int(11) NOT NULL,
  PRIMARY KEY (`ID`)
);

to

CREATE TABLE `FOO` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`ID`)
);

would generate a difference in a migration script.

Have a nice day!

Start by reproducing the MySQL example in revision auto-generation, comparing a table whose column lacks AUTO_INCREMENT with one that includes it. Trace how the schema difference is detected and confirm that the generated migration represents toggling the autoincrement attribute.