H21zzfJN

1CREATE TABLE IF NOT EXISTS `guild_kills` (
2  `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
3  `guild_id` INT NOT NULL,
4  `war_id` INT NOT NULL,
5  `death_id` INT NOT NULL
6) ENGINE = InnoDB;
7-------------------------------------------------------------------------------
8ALTER TABLE `guild_kills`
9  ADD CONSTRAINT `guild_kills_ibfk_1` FOREIGN KEY (`war_id`) REFERENCES `guild_wars` (`id`) ON DELETE CASCADE,
10  ADD CONSTRAINT `guild_kills_ibfk_2` FOREIGN KEY (`death_id`) REFERENCES `player_deaths` (`id`) ON DELETE CASCADE,
11  ADD CONSTRAINT `guild_kills_ibfk_3` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE;
12------------------------------------------------------------------------------------
13ALTER TABLE `killers` ADD `war` INT NOT NULL DEFAULT 0;