mysql - 不能添加外键约束，为什么？

Question

好吧，我在这里真的很沮丧，我似乎无法发现问题。

这就是问题所在，我正在尝试创建表 Vinter 和 Sommar，但是 MYSQL不允许我这样做，因为“错误代码:1215。无法添加外键约束".

代码如下:

CREATE TABLE Stuga(
stugaNr int unsigned AUTO_INCREMENT PRIMARY KEY,
stugaAdress char(60),
nrOfBeds int,
nrOfRooms int
);

DROP TABLE Customer;

CREATE TABLE Customer(
    customerNr int unsigned AUTO_INCREMENT primary key,
    lastName char(30),
    totalPassengers int
);

DROP TABLE Bokning;

CREATE TABLE Bokning(
    orderID int(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    stugaNr int UNSIGNED,
    customerNr int UNSIGNED,
    passengerNr int UNSIGNED,
    datum int,
    FOREIGN KEY (stugaNr) REFERENCES Stuga(stugaNr),
    FOREIGN KEY (customerNr) REFERENCES Customer(customerNr)
);

DROP TABLE Sommar;

CREATE TABLE Sommar(
    orderID int,
    totalPassengers int,
    sNr int primary key,
    benLangd int unsigned,
    huvudOmkrets int unsigned,
    cykelTyp char(30),
    FOREIGN KEY (orderID) REFERENCES Bokning(orderID)
);

DROP TABLE Vinter;

CREATE TABLE Vinter(
    orderID int,
    totalPassengers int,
    vNr int primary key,
    skidLangd int unsigned,
    stavLangd int unsigned,
    hjalm char(20),
    skoStorlek int unsigned,
    FOREIGN KEY (orderID) REFERENCES Bokning(orderID)
);

Answer 1

嗯，我发帖后才看到的。忘记在其他 orderID 上添加“int(6) UNSIGNED ”。

还是谢谢 :D