aboutsummaryrefslogtreecommitdiff
path: root/sql/base
diff options
context:
space:
mode:
authorVincent-Michael <Vincent_Michael@gmx.de>2014-08-28 21:00:53 +0200
committerVincent-Michael <Vincent_Michael@gmx.de>2014-08-28 21:00:53 +0200
commit3a248fbfec34fe80170dfb8c50b971858fb1e488 (patch)
tree4bf46d335d77b77a7abfb5f84f00b2073c6b636b /sql/base
parentc0c708cf02631118eaab093c43ab8c0b88dcbae2 (diff)
parentd6dbe52e64b1e6421b34877acd14b6008de97fa5 (diff)
Merge branch 'master' of github.com:TrinityCore/TrinityCore into 4.3.4
Conflicts: src/server/game/Battlegrounds/BattlegroundScore.h
Diffstat (limited to 'sql/base')
-rw-r--r--sql/base/characters_database.sql62
1 files changed, 61 insertions, 1 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 452b5a05b70..f4969ee617e 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -2606,6 +2606,66 @@ LOCK TABLES `pool_quest_save` WRITE;
UNLOCK TABLES;
--
+-- Table structure for table `pvpstats_battlegrounds`
+--
+
+DROP TABLE IF EXISTS `pvpstats_battlegrounds`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `pvpstats_battlegrounds` (
+ `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
+ `winner_faction` tinyint(4) NOT NULL,
+ `bracket_id` tinyint(3) unsigned NOT NULL,
+ `type` tinyint(3) unsigned NOT NULL,
+ `date` datetime NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `pvpstats_battlegrounds`
+--
+
+LOCK TABLES `pvpstats_battlegrounds` WRITE;
+/*!40000 ALTER TABLE `pvpstats_battlegrounds` DISABLE KEYS */;
+/*!40000 ALTER TABLE `pvpstats_battlegrounds` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `pvpstats_players`
+--
+
+DROP TABLE IF EXISTS `pvpstats_players`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `pvpstats_players` (
+ `battleground_id` bigint(20) unsigned NOT NULL,
+ `character_guid` int(10) unsigned NOT NULL,
+ `score_killing_blows` mediumint(8) unsigned NOT NULL,
+ `score_deaths` mediumint(8) unsigned NOT NULL,
+ `score_honorable_kills` mediumint(8) unsigned NOT NULL,
+ `score_bonus_honor` mediumint(8) unsigned NOT NULL,
+ `score_damage_done` mediumint(8) unsigned NOT NULL,
+ `score_healing_done` mediumint(8) unsigned NOT NULL,
+ `attr_1` mediumint(8) unsigned NOT NULL DEFAULT '0',
+ `attr_2` mediumint(8) unsigned NOT NULL DEFAULT '0',
+ `attr_3` mediumint(8) unsigned NOT NULL DEFAULT '0',
+ `attr_4` mediumint(8) unsigned NOT NULL DEFAULT '0',
+ `attr_5` mediumint(8) unsigned NOT NULL DEFAULT '0',
+ PRIMARY KEY (`battleground_id`,`character_guid`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `pvpstats_players`
+--
+
+LOCK TABLES `pvpstats_players` WRITE;
+/*!40000 ALTER TABLE `pvpstats_players` DISABLE KEYS */;
+/*!40000 ALTER TABLE `pvpstats_players` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
-- Table structure for table `reserved_name`
--
@@ -2684,4 +2744,4 @@ UNLOCK TABLES;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2014-01-26 14:39:20
+-- Dump completed on 2014-08-28 15:30:47