Baza

[BugaS]

Mam takie zapytanie:

CREATE TABLE IF NOT EXISTS `war_system_frags` (
`id` int(11) NOT NULL auto_increment,
`killer` INT NOT NULL,
`player` INT NOT NULL,
`guild` int(11) NOT NULL DEFAULT 0,
`level` int(11) NOT NULL DEFAULT 0,
`date` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
`war_id` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`id`),
FOREIGN KEY (`killer`) REFERENCES `players`(`id`) ON DELETE CASCADE,
FOREIGN KEY (`player`) REFERENCES `players`(`id`) ON DELETE CASCADE,
FOREIGN KEY (`guild`) REFERENCES `guilds`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

Legalnie kupiony system od Piotrka.

I bum bum i wanna u in my room:

#1005 - Can't create table 'bugas_ots.war_system_frags' (errno: 150)

 

[koob]

killers?

EDIT:
nie to, spalem jeszcze piszac tego posta

Sproboj jeszcze przed tym dac:

SET foreign_key_checks = 0;

 

[BugaS]

#1072 - Key column 'killers' doesn't exist in table

bump

 

[BugaS]

Somebody help!

 

[Your Master]

150 = Foreign key constraint is incorrectly formed

#1072 - Key column 'killers' doesn't exist in table
Yhy
Columna 'killers' nie istnieje w tabeli

Tylko, że ty ją tworzysz xD

 

[BugaS]

no wlasnie.

 

[Koroner]

Raczej tworzysz killer.

 

[BugaS]

killers?

EDIT:
nie to, spalem jeszcze piszac tego posta

Sproboj jeszcze przed tym dac:

SET foreign_key_checks = 0;

Dzieki! Rep