YVLDep5v

1CREATE TABLE IF NOT EXISTS `guild_wars` (
2  `id` INT NOT NULL AUTO_INCREMENT,
3  `guild_id` INT NOT NULL,
4  `enemy_id` INT NOT NULL,
5  `begin` BIGINT NOT NULL DEFAULT '0',
6  `end` BIGINT NOT NULL DEFAULT '0',
7  `frags` INT UNSIGNED NOT NULL DEFAULT '0',
8  `payment` BIGINT UNSIGNED NOT NULL DEFAULT '0',
9  `guild_kills` INT UNSIGNED NOT NULL DEFAULT '0',
10  `enemy_kills` INT UNSIGNED NOT NULL DEFAULT '0',
11  `status` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
12  PRIMARY KEY (`id`),
13  KEY `status` (`status`),
14  KEY `guild_id` (`guild_id`),
15  KEY `enemy_id` (`enemy_id`)
16) ENGINE=InnoDB;
17
18ALTER TABLE `guild_wars`
19  ADD CONSTRAINT `guild_wars_ibfk_1` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE,
20  ADD CONSTRAINT `guild_wars_ibfk_2` FOREIGN KEY (`enemy_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE;
21
22ALTER TABLE `guilds` ADD `balance` BIGINT UNSIGNED NOT NULL AFTER `motd`;
23
24CREATE TABLE IF NOT EXISTS `guild_kills` (
25  `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
26  `guild_id` INT NOT NULL,
27  `war_id` INT NOT NULL,
28  `death_id` INT NOT NULL
29) ENGINE = InnoDB;
30
31ALTER TABLE `guild_kills`
32  ADD CONSTRAINT `guild_kills_ibfk_1` FOREIGN KEY (`war_id`) REFERENCES `guild_wars` (`id`) ON DELETE CASCADE,
33  ADD CONSTRAINT `guild_kills_ibfk_2` FOREIGN KEY (`death_id`) REFERENCES `player_deaths` (`id`) ON DELETE CASCADE,
34  ADD CONSTRAINT `guild_kills_ibfk_3` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE;
35
36ALTER TABLE `killers` ADD `war` INT NOT NULL DEFAULT 0;