Solved Importing SQL file, how fix and why happend? :/

[Xeikh]

SQL query:

CREATE TABLE `guild_kills` (

`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`guild_id` INT NOT NULL ,
`war_id` INT NOT NULL ,
`death_id` INT NOT NULL ,
FOREIGN KEY ( `guild_id` ) REFERENCES `guilds` ( `id` ) ON DELETE CASCADE ,
FOREIGN KEY ( `war_id` ) REFERENCES `guild_wars` ( `id` ) ON DELETE CASCADE ,
FOREIGN KEY ( `death_id` ) REFERENCES `player_deaths` ( `id` ) ON DELETE CASCADE
) ENGINE = INNODB;

MySQL said:

#1005 - Can't create table 'eterna.guild_kills' (errno: 150)

Can someone help please?

 

[Don Daniello]

Create tables `guilds`, `guild_wars` and `player_deaths` first.

 

[Xeikh]

ok, thanks!
Rep++

 

[Xeikh]

Create tables `guilds`, `guild_wars` and `player_deaths` first.

Ehmm sorry, again...

How i create em?... Please:$

Edit>

Whats the "code"? i know where add but not how to make the code...

And if im fine...

First: tables
after that i charge the sql schema file?

 

[Don Daniello]

Execute for each table
CREATE TABLE `find the name` (
...........
) ENGINE = INNODB;

 

[Xeikh]

._. still a lil confused, im a newbie in the sql stuff:$

Can please tell me like a kid, what to text? TT___TT

 

[Don Daniello]

Queries from that file, only excerpts which I mentioned.
If your database is empty (you have no accounts yet), you can dropping your database and creating it again as well and then trying again.

 

[Xeikh]

but the code that i have to use, how i write it? ._.

edit> sorry if im annoying:$ TT__TT

 

[Don Daniello]

Use phpmyadmin, no code...

 

[Xeikh]

Im using phpmyadmin but idk what to do ._.

this in the sql schema file:

CREATE TABLE `guilds`
(
`id` INT NOT NULL AUTO_INCREMENT,
`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
`name` VARCHAR(255) NOT NULL,
`ownerid` INT NOT NULL,
`creationdata` INT NOT NULL,
`checkdata` INT NOT NULL,
`motd` VARCHAR(255) NOT NULL,
`balance` INT UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY (`id`),
UNIQUE (`name`, `world_id`)
) ENGINE = InnoDB;

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;

CREATE TABLE `guild_kills`
(
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
`guild_id` INT NOT NULL,
`war_id` INT NOT NULL,
`death_id` INT NOT NULL,
FOREIGN KEY (`guild_id`) REFERENCES `guilds`(`id`) ON DELETE CASCADE,
FOREIGN KEY (`war_id`) REFERENCES `guild_wars`(`id`) ON DELETE CASCADE,
FOREIGN KEY (`death_id`) REFERENCES `player_deaths`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `guild_ranks`
(
`id` INT NOT NULL AUTO_INCREMENT,
`guild_id` INT NOT NULL,
`name` VARCHAR(255) NOT NULL,
`level` INT NOT NULL COMMENT '1 - leader, 2 - vice leader, 3 - member',
PRIMARY KEY (`id`),
FOREIGN KEY (`guild_id`) REFERENCES `guilds`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `guild_wars`
(
`id` INT NOT NULL AUTO_INCREMENT,
`guild_id` INT NOT NULL,
`enemy_id` INT NOT NULL,
`begin` BIGINT NOT NULL DEFAULT 0,
`end` BIGINT NOT NULL DEFAULT 0,
`frags` INT UNSIGNED NOT NULL DEFAULT 0,
`payment` BIGINT UNSIGNED NOT NULL DEFAULT 0,
`guild_kills` INT UNSIGNED NOT NULL DEFAULT 0,
`enemy_kills` INT UNSIGNED NOT NULL DEFAULT 0,
`status` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY (`id`), KEY `status` (`status`),
KEY `guild_id` (`guild_id`), KEY `enemy_id` (`enemy_id`),
FOREIGN KEY (`guild_id`) REFERENCES `guilds`(`id`) ON DELETE CASCADE,
FOREIGN KEY (`enemy_id`) REFERENCES `guilds`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB;

EDIT:

CREATE TABLE `player_deaths`
(
`id` INT NOT NULL AUTO_INCREMENT,
`player_id` INT NOT NULL,
`date` BIGINT UNSIGNED NOT NULL,
`level` INT UNSIGNED NOT NULL,
PRIMARY KEY (`id`), INDEX (`date`),
FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

 

[Don Daniello]

Just execute that code in PMA.

 

[Xeikh]

i did add table per table in required order. Thx anyways:3
rep+