Foreign key references on column definitions are ignored. Feature, not a bug — why?
By design MySQL has been less SQL standard compliant than other open source database (i.e PostgreSQL): I think this was an intented design choice in both cases and I think that for MySQL the road is still long even with all Oracle Corp. and MariaDB achievements in the last decade.