MySQL Forums
Forum List  »  InnoDB

Cannot resolve table name close to...
Posted by: Jacopo Moronato
Date: June 27, 2007 05:00PM

When trying to create this table:

CREATE TABLE Prenotazioni(
CodPrenotazione INT CHECK (CodPrenotazione>=0),
DataPrenotazione DATE NOT NULL,
TipoPagamento CHAR NOT NULL CHECK (TipoPagamento IN ('contanti','carta credito')),
NPostiPrenotati INT NOT NULL,
CodVolo INT NOT NULL,
CodFiscale CHAR(16) NOT NULL,
PRIMARY KEY (CodPrenotazione),
CONSTRAINT FOREIGN KEY (CodVolo)
REFERENCES Effettivi.CodiceVolo ,
CONSTRAINT FOREIGN KEY (CodFiscale)
REFERENCES Clienti.CodiceFiscale
)TYPE=INNODB;



command line returns an ERROR 1050 (HY000): Can't create table .... (errno:150).

"show engine innodb status" returns: error in foreign key constraint of table .../prenotazioni

CONSTRAINT FOREIGN KEY (CodVolo)
REFERENCES Effettivi.CodiceVolo ,
CONSTRAINT FOREIGN KEY (CodFiscale)
REFERENCES Clienti.CodiceFiscale
Cannot resolve table name close to:
,
CONSTRAINT FOREIGN KEY (CodFiscale)
REFERENCES Clienti.CodiceFiscale
)TYPE=INNODB;



What is the problem? Any suggestion?

Options: ReplyQuote


Subject
Views
Written By
Posted
Cannot resolve table name close to...
16195
June 27, 2007 05:00PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.