Can't create table. InnoDB, problem z FOREIGN KEY? Opcje

[rafalp]

[SQL] pobierz, plaintext 
CREATE TABLE friends (
  FK_user_id BIGINT NOT NULL,
  FK_friend_id BIGINT NOT NULL,
  STATUS TINYINT UNSIGNED NULL DEFAULT 0,
 
  FOREIGN KEY(FK_user_id)
    REFERENCES users(user_id) ON DELETE CASCADE ON UPDATE CASCADE,
  FOREIGN KEY(FK_friend_id)
    REFERENCES users(user_id) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
[SQL] pobierz, plaintext 

#1005 - Can't create table '.\folder\friends.frm' (errno: 150)

Bez "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;" -działa.

Dodam że typy pól FK_user_id - user_id są takie same oraz z "PRIMARY KEY ( FK_user_id )" także nie działa

Ten post edytował rafalp 14.11.2008, 16:47:51