hi,
I've downloaded mysql-max-nt v.3.23.49, have setup InnoDB startup support. I
am now in the process of creating tables. When these are standard tables no
problem, eg:
create table test (id integer not null, primary key(id)) type=InnoDB;
works fine !
I have problems when I have tables with foreign keys. Here is my sql script:
CREATE TABLE answer
(
id_answer INTEGER NOT NULL,
text_answer VARCHAR (255),
id_evaluation INTEGER NOT NULL,
id_question INTEGER NOT NULL,
scale_answer INTEGER,
PRIMARY KEY(id_answer),
INDEX evaluation_ind (id_evaluation),
INDEX question_ind (id_question),
FOREIGN KEY (id_evaluation) REFERENCES evaluation (id_evaluation),
FOREIGN KEY (id_question) REFERENCES question (id_question)
) type=InnoDB;
There I end up with an error 1005 errno 150 I've seen in the doc that my
foreign key syntax might be wrong, but what is wrong ?? Note the same script
works fine without "type=InnoDB".
Any idea ??
Olivier
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
