#[prefix]_ ersetzen!!!
UPDATE `[prefix]_modules` SET `version` = '1.14.0' WHERE `key` = 'war';
DROP TABLE IF EXISTS `[prefix]_war_access`, `[prefix]_war_accept`, `[prefix]_war_played`, `[prefix]_war_groups`, `[prefix]_war_enemy`, `[prefix]_war`, `[prefix]_maps`;
CREATE TABLE IF NOT EXISTS `[prefix]_war_groups` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`name` VARCHAR(32) NOT NULL,
`tag` VARCHAR(20) NOT NULL,
`image` VARCHAR(255) NOT NULL,
`desc` VARCHAR(255) NOT NULL,
`member` INT(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1;
CREATE TABLE IF NOT EXISTS `[prefix]_war_enemy` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`name` VARCHAR(150) NOT NULL,
`tag` VARCHAR(20) NOT NULL,
`homepage` VARCHAR(150) NOT NULL,
`image` VARCHAR(255) NOT NULL,
`contact_name` VARCHAR(50) NOT NULL,
`contact_email` VARCHAR(150) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1;
CREATE TABLE IF NOT EXISTS `[prefix]_war` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`enemy` INT(11) NOT NULL,
`group` INT(11) NOT NULL,
`time` DATETIME NOT NULL,
`maps` VARCHAR(255) NOT NULL,
`server` VARCHAR(255) NOT NULL,
`password` VARCHAR(255) NOT NULL,
`xonx` VARCHAR(50) NOT NULL,
`game` VARCHAR(255) NOT NULL,
`matchtype` VARCHAR(255) NOT NULL,
`report` TEXT NOT NULL,
`status` TINYINT(1) NOT NULL DEFAULT 0,
`show` TINYINT(1) NOT NULL DEFAULT 0,
`read_access` VARCHAR(255) NOT NULL DEFAULT '2,3',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1;
CREATE TABLE IF NOT EXISTS `[prefix]_war_played` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`war_id` INT(11) DEFAULT NULL,
`map` VARCHAR(255) NOT NULL DEFAULT "",
`group_points` MEDIUMINT(9) DEFAULT NULL,
`enemy_points` MEDIUMINT(9) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1;
CREATE TABLE IF NOT EXISTS `[prefix]_war_accept` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`war_id` INT(11) DEFAULT NULL,
`user_id` INT(11) DEFAULT NULL,
`accept` TINYINT(1) DEFAULT NULL,
`comment` MEDIUMTEXT NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1;
#Insert Backup-Data