From ae3ab32ea5bf697a7b3f6d1fbc0740d7404d7c92 Mon Sep 17 00:00:00 2001 From: leak Date: Tue, 5 Apr 2011 21:54:28 +0200 Subject: Core/Arenas: Refactor arena code and db layout --- .../2011_04_05_00_characters_arena_team_misc.sql | 42 ++++++++++++++++++++++ 1 file changed, 42 insertions(+) create mode 100644 sql/updates/auth_char/2011_04_05_00_characters_arena_team_misc.sql (limited to 'sql/updates') diff --git a/sql/updates/auth_char/2011_04_05_00_characters_arena_team_misc.sql b/sql/updates/auth_char/2011_04_05_00_characters_arena_team_misc.sql new file mode 100644 index 00000000000..377d01ef59b --- /dev/null +++ b/sql/updates/auth_char/2011_04_05_00_characters_arena_team_misc.sql @@ -0,0 +1,42 @@ +-- Update arena_team table +ALTER TABLE `arena_team` +CHANGE `arenateamid` `arenaTeamId` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `captainguid` `captainGuid` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `BackgroundColor` `backgroundColor` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `EmblemStyle` `emblemStyle` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `EmblemColor` `emblemColor` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `BorderStyle` `borderStyle` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `BorderColor` `borderColor` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +ADD COLUMN `rating` SMALLINT(5) UNSIGNED NOT NULL AFTER `type`, +ADD COLUMN `seasonGames` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL AFTER `rating`, +ADD COLUMN `seasonWins` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL AFTER `seasonGames`, +ADD COLUMN `weekGames` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL AFTER `seasonWins`, +ADD COLUMN `weekWins` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL AFTER `weekGames`, +ADD COLUMN `rank` INT(10) UNSIGNED NOT NULL AFTER `weekWins`; + +-- Move data from arena_team_stats to new columns in arena_team +UPDATE `arena_team` a, `arena_team_stats` s SET +`a`.`rating` = `s`.`rating`, +`a`.`seasonGames` = `s`.`played`, +`a`.`seasonWins` = `s`.`wins2`, +`a`.`weekGames` = `s`.`games`, +`a`.`weekWins` = `s`.`wins`, +`a`.`rank` = `s`.`rank` +WHERE `a`.`arenaTeamId` = `s`.`arenateamid`; + +-- Remove arena_team_stats table +DROP TABLE `arena_team_stats`; + +-- Update arena_team_member table +ALTER TABLE `arena_team_member` +CHANGE `arenateamid` `arenaTeamId` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `played_week` `weekGames` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `wons_week` `weekWins` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `played_season` `seasonGames` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `wons_season` `seasonWins` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL, +ADD COLUMN `personalRating` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL AFTER `seasonWins`; + +-- Update character_arena_stats table +ALTER TABLE `character_arena_stats` +CHANGE `personal_rating` `personalRating` SMALLINT(5) NOT NULL, +CHANGE `matchmaker_rating` `matchMakerRating` SMALLINT(5) NOT NULL; -- cgit v1.2.3