diff options
author | Vincent-Michael <Vincent_Michael@gmx.de> | 2014-08-28 21:00:53 +0200 |
---|---|---|
committer | Vincent-Michael <Vincent_Michael@gmx.de> | 2014-08-28 21:00:53 +0200 |
commit | 3a248fbfec34fe80170dfb8c50b971858fb1e488 (patch) | |
tree | 4bf46d335d77b77a7abfb5f84f00b2073c6b636b /sql/base | |
parent | c0c708cf02631118eaab093c43ab8c0b88dcbae2 (diff) | |
parent | d6dbe52e64b1e6421b34877acd14b6008de97fa5 (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.sql | 62 |
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 |