pomocy z baza danych.

[Karol94]

przy wgrywaniu bazy danych wyskakuje tai komunikat

zapytanie SQL:

CREATE TABLE  `guild_invites` (

 `player_id` INT NOT NULL DEFAULT 0,
 `guild_id` INT NOT NULL DEFAULT 0,
UNIQUE (
`player_id` ,
`guild_id`
),
FOREIGN KEY (  `player_id` ) REFERENCES  `players` (  `id` ) ON DELETE CASCADE ,
FOREIGN KEY (  `guild_id` ) REFERENCES  `guilds` (  `id` ) ON DELETE CASCADE
) ENGINE = INNODB;

MySQL zwrócił komunikat: Dokumentacja

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

 

[GOD TABI]

CREATE TABLE `guild_invites`
(
    `player_id` INT NOT NULL DEFAULT 0,
    `guild_id` INT NOT NULL DEFAULT 0,
    UNIQUE (`player_id`, `guild_id`),
    FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE,
    FOREIGN KEY (`guild_id`) REFERENCES `guilds`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

Zrób takie zapytanie.