Mysql and FOREIGN KEY

[Micol lupen]

Hi to all,
I am a student, i am studing Mysql FOREIGN KEY for to
do a little progect, but i have this problem:
i create this table:
CREATE TABLE Cliente( codcliente VARCHAR(6) NOT NULL,
nome VARCHAR(10) NOT NULL,cognome VARCHAR(20) NOT
NULL, citta VARCHAR(10), indirizzo VARCHAR(20), tel
VARCHAR(7) NOT NULL, PRIMARY KEY
(codcliente))ENGINE=INNODB;

CREATE TABLE villaggio (idvillaggio INT
AUTO_INCREMENT, nome VARCHAR(15) NOT NULL, stato
VARCHAR(3) NOT NULL, descrizione VARCHAR(30),PRIMARY
KEY(idvillaggio)) ENGINE=INNODB;

but when i create this table:
CREATE TABLE offerta(idofferta INT
AUTO_INCREMENT,of_idvillaggio INT NOT NULL,
INDEX(of_idvillaggio),FOREIGN
KEY(of_idvillaggio),REFERENCES villaggio(idvillaggio)
ON UPDATE CASCADE ON DELETE RESTRICT)ENGINE=INNODB;

i have this error: REFERENCES error control manual 
p.s. table villaggio is father and table offerta is
children 

i see the manual but i don't see error, help me !!!

excuse me for my bad english
Best Regads
Antonio






	

	
		
___________________________________ 
L'email della prossima generazione? Puoi averla con la nuova Yahoo! Mail: 
http://it.docs.yahoo.com/nowyoucan.html