aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorLiberate <none@none>2010-08-28 14:09:57 +0200
committerLiberate <none@none>2010-08-28 14:09:57 +0200
commit5433b992795efccb4c55bfe2c9bbfaddae7ddece (patch)
tree8c9838322416641a3a93c2b563759dfbaf3c9e5e
parent2228a8f8d9b46995f6e4644496d2c5cd507a51a2 (diff)
Add the sql of rfce5b5c218 to sql/base/characters_database.sql.
Thanks to bitherd for showing me this stupid mistake. --HG-- branch : trunk
-rw-r--r--sql/base/characters_database.sql26
1 files changed, 25 insertions, 1 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 234f93b7d6b..d2efb12900a 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -107,7 +107,6 @@ CREATE TABLE `arena_team_member` (
`wons_week` int(10) unsigned NOT NULL default '0',
`played_season` int(10) unsigned NOT NULL default '0',
`wons_season` int(10) unsigned NOT NULL default '0',
- `personal_rating` int(10) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`arenateamid`,`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -122,6 +121,31 @@ LOCK TABLES `arena_team_member` WRITE;
UNLOCK TABLES;
--
+-- Table structure for table `character_arena_stats`
+--
+
+DROP TABLE IF EXISTS `character_arena_stats`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+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`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `character_arena_stats`
+--
+
+LOCK TABLES `character_arena_stats` WRITE;
+/*!40000 ALTER TABLE `character_arena_stats` DISABLE KEYS */;
+/*!40000 ALTER TABLE `character_arena_stats` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
-- Table structure for table `arena_team_stats`
--