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
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=InnoDBError:
Impossible d'ajouter des contraintes d'index externe