Erro ao criar tabela no MySQL

MySQL

08/09/2009

Pessoal, está aparecendo um erro que eu nunca vi aqui no meu MySQL e não faço ideia do que seja.

Olhem os creates:
CREATE  TABLE IF NOT EXISTS ´intercede´.´user´ (
  ´id´ INT NOT NULL AUTO_INCREMENT ,
  ´registered_on´ DATETIME NOT NULL ,
  ´updated_on´ DATETIME NOT NULL ,
  ´last_log´ DATETIME NOT NULL ,
  ´firstname´ VARCHAR(20) NOT NULL ,
  ´lastname´ VARCHAR(20) NOT NULL ,
  ´birth´ DATE NULL ,
  ´email´ VARCHAR(70) NOT NULL ,
  ´login´ VARCHAR(45) NOT NULL ,
  ´password´ CHAR(32) NOT NULL ,
  ´verified´ TINYINT(1) NOT NULL DEFAULT 0 ,
  ´blocked´ TINYINT(1) NOT NULL DEFAULT 0 ,
  PRIMARY KEY (´id´) ,
  UNIQUE INDEX ´unique_user´ (´email´ ASC, ´login´ ASC) )
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_unicode_ci;

CREATE  TABLE IF NOT EXISTS ´intercede´.´intercession´ (
  ´id´ INT NOT NULL AUTO_INCREMENT ,
  ´generated_on´ DATETIME NOT NULL ,
  ´from_user_id´ INT NOT NULL ,
  ´to_user_id´ INT NOT NULL ,
  ´week´ INT(2) NOT NULL ,
  ´year´ YEAR NOT NULL ,
  ´from_allow_dialog´ TINYINT(1) NOT NULL DEFAULT 1 ,
  ´to_allow_dialog´ TINYINT(1) NOT NULL DEFAULT 1 ,
  PRIMARY KEY (´id´) ,
  UNIQUE INDEX ´unique_intercession´ (´week´ ASC, ´year´ ASC) ,
  INDEX ´fk_intercession_user´ (´to_user_id´ ASC, ´from_user_id´ ASC) ,
  CONSTRAINT ´fk_intercession_user´
    FOREIGN KEY (´to_user_id´ , ´from_user_id´ )
    REFERENCES ´intercede´.´user´ (´id´ , ´id´ )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_unicode_ci;


O erro mostrado é:
[color=red:ca00b4e457]#1005 - Can´t create table ´./intercede/intercession.frm´[/color:ca00b4e457]

Será que alguem pode me ajudar?

Obrigado


Paulovitin

Paulovitin

Curtidas 0
POSTAR