aboutsummaryrefslogtreecommitdiff
path: root/sql/base
diff options
context:
space:
mode:
authorleak <leakzx@googlemail.com>2011-04-08 21:14:30 +0200
committerleak <leakzx@googlemail.com>2011-04-08 21:14:30 +0200
commit7935c2f5c299f187c2d18d10e06864ea113c97c1 (patch)
treef892c760058e862d6463be460829d44adc1a1acb /sql/base
parent5f4337f7e9e11b7992a39a88969ba9f4502d00dc (diff)
Core/Arena: Move personalRating to arena_team_member
Diffstat (limited to 'sql/base')
-rw-r--r--sql/base/characters_database.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index fabd0308899..bca9371d571 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -167,6 +167,7 @@ CREATE TABLE `arena_team_member` (
`weekWins` smallint(5) unsigned NOT NULL DEFAULT '0',
`seasonGames` smallint(5) unsigned NOT NULL DEFAULT '0',
`seasonWins` smallint(5) unsigned NOT NULL DEFAULT '0',
+ `personalRating` smallint(5) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`arenateamid`,`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -374,7 +375,6 @@ DROP TABLE IF EXISTS `character_arena_stats`;
CREATE TABLE `character_arena_stats` (
`guid` int(10) NOT NULL,
`slot` tinyint(3) NOT NULL,
- `personalRating` smallint(5) NOT NULL,
`matchMakerRating` smallint(5) NOT NULL,
PRIMARY KEY (`guid`,`slot`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;