Error 1005 mysql

Bonjour,

J'ai créé une BD pour un exercice mais quand je l'insere dans mon mysql il me donne une erreur qui me dit: ERROR 1005 (HY000) at line 28 Ne peut creer la table 'BD_COURSE.COURSE' (Errcode: 150) et comme je suis pas top en sql je voulais avoir votre avis Merci

DROP DATABASE IF EXISTS BD_COURSE;

CREATE DATABASE BD_COURSE;

USE BD_COURSE;

CREATE TABLE P
    (
    NP      INTEGER NOT NULL AUTO_INCREMENT,
    NomP    VARCHAR (30),
    Prenom VARCHAR(30),
    Numero   INTEGER,
    PRIMARY KEY(NP)
    )TYPE=INNODB;

INSERT INTO P VALUES (NULL, 'Martin', 'THOMAS ',100);
INSERT INTO P VALUES (NULL, 'Bernard', 'LUCAS ',101);
INSERT INTO P VALUES (NULL, 'Dubois', 'CAMILLE',102);
INSERT INTO P VALUES (NULL, 'Robert', 'MAXIME ',103);
INSERT INTO P VALUES (NULL, 'Richard', 'LAURA',104);
INSERT INTO P VALUES (NULL, 'Petit', 'VALENTIN ',105);
INSERT INTO P VALUES (NULL, 'Moreau', 'ANAIS',106);
INSERT INTO P VALUES (NULL, 'Simon', 'ROMAIN',107);
INSERT INTO P VALUES (NULL, 'Lefebvre', 'PAUL',108);
INSERT INTO P VALUES (NULL, 'Garcia', 'LISA',109);

CREATE TABLE COURSE
    (
    CO      INTEGER NOT NULL AUTO_INCREMENT,
    Classement    INTEGER,
    Num    INTEGER NOT NULL,
    PRIMARY KEY(CO,Num),
    FOREIGN KEY(Num) REFERENCES P(Numero)
    )TYPE=INNODB;

INSERT INTO COURSE VALUES (NULL,1,107);
INSERT INTO COURSE VALUES (NULL,2,109);
INSERT INTO COURSE VALUES (NULL,3,106);
INSERT INTO COURSE VALUES (NULL,4,101);
INSERT INTO COURSE VALUES (NULL,5,103);
INSERT INTO COURSE VALUES (NULL,6,102);
INSERT INTO COURSE VALUES (NULL,7,100);
INSERT INTO COURSE VALUES (NULL,8,105);
INSERT INTO COURSE VALUES (NULL,9,104);
INSERT INTO COURSE VALUES (NULL,10,108);