diff options
| author | Liberate <tbaart@gmail.com> | 2010-08-27 18:23:43 +0200 |
|---|---|---|
| committer | Liberate <tbaart@gmail.com> | 2010-08-27 18:23:43 +0200 |
| commit | 4d01ec84950514ad65bc7615188b391655ab3f6a (patch) | |
| tree | 3de0234e9eb6927ca41422c97cb997c3125cb4d3 | |
| parent | 5b5055a6dfc662bf6200059af4ea201618d61e13 (diff) | |
Rename sql files of rfce5b5c2182c to the correct revision number.
--HG--
branch : trunk
| -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`) +); |