From 4d01ec84950514ad65bc7615188b391655ab3f6a Mon Sep 17 00:00:00 2001 From: Liberate Date: Fri, 27 Aug 2010 18:23:43 +0200 Subject: Rename sql files of rfce5b5c2182c to the correct revision number. --HG-- branch : trunk --- sql/updates/9632_character_arena_team_member.sql | 2 ++ sql/updates/9632_characters_arena_team_stats.sql | 1 + sql/updates/9632_characters_character_arena_stats.sql | 7 +++++++ 3 files changed, 10 insertions(+) create mode 100644 sql/updates/9632_character_arena_team_member.sql create mode 100644 sql/updates/9632_characters_arena_team_stats.sql create mode 100644 sql/updates/9632_characters_character_arena_stats.sql (limited to 'sql') diff --git a/sql/updates/9632_character_arena_team_member.sql b/sql/updates/9632_character_arena_team_member.sql new file mode 100644 index 00000000000..cc33ecbb78b --- /dev/null +++ b/sql/updates/9632_character_arena_team_member.sql @@ -0,0 +1,2 @@ +ALTER TABLE `arena_team_member` +DROP COLUMN `personal_rating`; diff --git a/sql/updates/9632_characters_arena_team_stats.sql b/sql/updates/9632_characters_arena_team_stats.sql new file mode 100644 index 00000000000..91d23b54912 --- /dev/null +++ b/sql/updates/9632_characters_arena_team_stats.sql @@ -0,0 +1 @@ +UPDATE `arena_team_stats` SET `rating`=0; diff --git a/sql/updates/9632_characters_character_arena_stats.sql b/sql/updates/9632_characters_character_arena_stats.sql new file mode 100644 index 00000000000..cb60e6d36fb --- /dev/null +++ b/sql/updates/9632_characters_character_arena_stats.sql @@ -0,0 +1,7 @@ +CREATE TABLE `character_arena_stats` ( +`guid` int(10) NOT NULL , +`slot` smallint(1) NOT NULL , +`personal_rating` int(10) NOT NULL , +`matchmaker_rating` int(10) NOT NULL , +PRIMARY KEY (`guid`, `slot`) +); -- cgit v1.2.3