· 8 years ago · May 08, 2018, 03:22 AM
1DROP TABLE IF EXISTS `killers`;
2CREATE TABLE `killers`
3(
4`id` INT NOT NULL AUTO_INCREMENT,
5`death_id` INT NOT NULL,
6`final_hit` TINYINT(1) UNSIGNED NOT NULL DEFAULT FALSE,
7`unjustified` TINYINT(1) UNSIGNED NOT NULL DEFAULT FALSE,
8`war` INT NOT NULL DEFAULT 0,
9PRIMARY KEY (`id`),
10FOREIGN KEY (`death_id`) REFERENCES `player_deaths`(`id`) ON DELETE CASCADE
11) ENGINE = InnoDB;