Updated the MySQL schema definition to be inline with the PostgreSQL version