#1215 - Cannot add foreign key constraint ERROR even though the columns are exactly the same
If games table is referring google_id from the parent table "players",then use below syntax (unless you are establishing Foreign key with "role" table as per your SQL statement):

ALTER TABLE
games ADD FOREIGN KEY(google_id) REFERENCES players(google_id);


Also, please check the DDL of role table(if exists)- datatype, width of column google_id and the mysql engine for both the tables.