TABLE METADATA - Add a table history, about STRUCTURE and queries that was done to change the structure (like GIT log)

hi guys, should be nice a tool or sql commands to see .frm history
what i'm talking about?
1)CREATE TABLE A (a int);
2)ALTER TABLE A add b int;
3)ALTER TABLE A drop a;

that information that could be nice to have
and maybe after this we could some tool like diff

diff table a.1 a.current
and it will create a query like:
)alter table a add b int, drop a;

something similar to git, but instead of checkout, just reproduce the diff query (queries) to update the current table from some point in time

second part is replication or export/import and merge
it's like merge in git, and push/pull

well it's a bit complicated but with this tool and git, i could have a full history of table inside database, instead inside some other file, and since it's inside database, i will never lost historical information

i don't know if this could be done with binlog or something similar, but could be nice this tool be a per table log, instead a "daemon" binlog

for first version just history could be nice, and at a second version the diff tool

some fields that i thik that are usefull
unique hash (like git), user, datetime, ddl command

well that's all thanks guys!