diff options
| -rw-r--r-- | sql/updates/9632_character_arena_team_member.sql | 2 | ||||
| -rw-r--r-- | sql/updates/9632_characters_arena_team_stats.sql | 1 | ||||
| -rw-r--r-- | sql/updates/9632_characters_character_arena_stats.sql | 7 |
3 files changed, 10 insertions, 0 deletions
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`) +); |