Cannot resolve table name close to...
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?
Subject
Views
Written By
Posted
Cannot resolve table name close to...
16195
June 27, 2007 05:00PM
8531
July 27, 2007 01:44AM
6449
June 17, 2008 08:03PM
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.