Le7m5y6g

1CREATE TABLE IF NOT EXISTS `guild_wars`
2(
3	`id` INT NOT NULL AUTO_INCREMENT,
4	`guild_id` INT NOT NULL,
5	`enemy_id` INT NOT NULL,
6	`begin` BIGINT NOT NULL DEFAULT 0,
7	`end` BIGINT NOT NULL DEFAULT 0,
8	`frags` INT UNSIGNED NOT NULL DEFAULT 0,
9	`payment` BIGINT UNSIGNED NOT NULL DEFAULT 0,
10	`guild_kills` INT UNSIGNED NOT NULL DEFAULT 0,
11	`enemy_kills` INT UNSIGNED NOT NULL DEFAULT 0,
12	`status` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
13	PRIMARY KEY (`id`), KEY `status` (`status`),
14	KEY `guild_id` (`guild_id`), KEY `enemy_id` (`enemy_id`),
15	FOREIGN KEY (`guild_id`) REFERENCES `guilds`(`id`) ON DELETE CASCADE,
16	FOREIGN KEY (`enemy_id`) REFERENCES `guilds`(`id`) ON DELETE CASCADE
17) ENGINE=InnoDB;