Player killers error (DB)

[vampirium]

plz help I have killings erro in mi data db

 

[Friizee]

add you database

CREATE TABLE `player_killers`
(
        `kill_id` INT NOT NULL,
        `player_id` INT NOT NULL,
        FOREIGN KEY (`kill_id`) REFERENCES `killers`(`id`) ON DELETE CASCADE,
        FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

 

[vampirium]

I have add to db and I have the same problem

says Unknoun colum war

 

[sn3ejk]

ALTER TABLE `killers` ADD `war` INT NOT NULL DEFAULT 0;

 

[vampirium]

who I do that

- - - Updated - - -

Now I have other problem Plz help mi I give reep

[23:3:08.170] mysql_real_query(): INSERT INTO `death_list` (`player_id`, `date`,
`level`, `killer_name`) VALUES ('777', '1344978188', '9', 'Gang Member. '); - M
YSQL ERROR: Duplicate entry '0' for key 'PRIMARY' (1062)

 

[Friizee]

sql

ALTER TABLE `death_list` MODIFY COLUMN `id` INT UNSIGNED NOT NULL AUTO_INCREMENT;