问由于外键约束，未能创建表

EN

CREATE TABLE Movies (
   movie_title VARCHAR(86), 
   imdb_id VARCHAR(9), 
   movie_id INT, 
   runtime INT, 
   budget INT, 
   revenue INT, 
   release_date DATE, 
   vote_count INT, 
   vote_average DOUBLE, 
   popularity DOUBLE, 
   language VARCHAR(2), 
   tagline VARCHAR(221), 
   overview TEXT(992), 
   PRIMARY KEY (movie_id), 
   FULLTEXT idx (overview)
);

CREATE TABLE Movie_Genre (
   movie_id INT,
   genre_id INT,
   PRIMARY KEY (movie_id, genre_id),
   FOREIGN KEY (movie_id) REFERENCES Movies(movie_id)
);

CREATE TABLE Genres (
   genre_id INT,
   genre_name VARCHAR(15),
   PRIMARY KEY (genre_id),
   FOREIGN KEY (genre_id) REFERENCES Movie_Genre(genre_id)
);

Failed to add the foreign key constraint. Missing index for constraint 'Genres_ibfk_1' in the referenced table 'Movie_Genre'