Why is this create table statement failing?
Hi:
When I tried to create a table:
CREATE TABLE pt_lang ( meddra_version_no VARCHAR(6) NOT NULL, pt_id BIGINT NOT NULL, language_code VARCHAR(100) NOT NULL, pt VARCHAR(200) NOT NULL, update_user_id VARCHAR(100) NOT NULL, update_timestamp TIMESTAMP NOT NULL DEFAULT now(), CONSTRAINT xpkpt_lang PRIMARY KEY (meddra_version_no,language_code,pt_id), CONSTRAINT R_54 FOREIGN KEY (meddra_version_no, language_code) REFERENCES meddra_version_lang (meddra_version_no, language_code), CONSTRAINT R_55 FOREIGN KEY (meddra_version_no, pt_id) REFERENCES pt (meddra_version_no, pt_id) )
I get the following error message.
[ma-3.1.3][10.4.6-MariaDB]Can't create table `meddra`.`pt_lang` (errno: 121 "Duplicate key on write or update") Execution Failed!
Can someone tell me what I am doing wrong?
Answer Answered by Ian Gilfillan in this comment.
What is the definition of the other tables you're referencing?