Open darknoon29 opened 7 years ago
Database MySQL Error ErrNo:1215 Query: CREATE TABLE ogspy_mod_user_config ( mod VARCHAR(50) NOT NULL, config VARCHAR(255) NOT NULL, user_id INT(10) NOT NULL, value VARCHAR(255) NOT NULL, PRIMARY KEY (mod, config, user_id), INDEX fk_user_userid (user_id), CONSTRAINT fk_user_userid FOREIGN KEY (user_id) REFERENCES ogspy_user (user_id) ) COLLATE='utf8_general_ci' ENGINE=InnoDB Error: Impossible d'ajouter des contraintes d'index externe
ogspy_mod_user_config
mod
config
user_id
value
fk_user_userid
ogspy_user
On supprime les contraintes.
darknoon29
commented
4 years ago darknoon29
commented
4 years ago
Database MySQL Error ErrNo:1215 Query: CREATE TABLE
ogspy_mod_user_config(modVARCHAR(50) NOT NULL,configVARCHAR(255) NOT NULL,user_idINT(10) NOT NULL,valueVARCHAR(255) NOT NULL, PRIMARY KEY (mod,config,user_id), INDEXfk_user_userid(user_id), CONSTRAINTfk_user_useridFOREIGN KEY (user_id) REFERENCESogspy_user(user_id) ) COLLATE='utf8_general_ci' ENGINE=InnoDB Error: Impossible d'ajouter des contraintes d'index externe