2 files changed, 16 insertions, 14 deletions
diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql
index f0c2607a3d2..106851769ee 100644
--- a/sql/base/world_database.sql
+++ b/sql/base/world_database.sql
@@ -241,6 +241,7 @@ CREATE TABLE `battleground_template` (
   `AllianceStartO` float NOT NULL,
   `HordeStartLoc` mediumint(8) unsigned NOT NULL,
   `HordeStartO` float NOT NULL,
+  `Weight` tinyint(2) unsigned NOT NULL DEFAULT 1,
   `Comment` char(32) NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
@@ -252,20 +253,20 @@ CREATE TABLE `battleground_template` (
 
 LOCK TABLES `battleground_template` WRITE;
 /*!40000 ALTER TABLE `battleground_template` DISABLE KEYS */;
-INSERT INTO `battleground_template` (`id`,`MinPlayersPerTeam`,`MaxPlayersPerTeam`,`MinLvl`,`MaxLvl`,`AllianceStartLoc`,`AllianceStartO`,`HordeStartLoc`,`HordeStartO`) VALUES
-(1,20,40,51,80,611,2.72532,610,2.27452),
-(2,5,10,10,80,769,3.14159,770,3.14159),
-(3,8,15,20,80,890,3.40156,889,0.263892),
-(4,0,2,10,80,929,0,936,3.14159),
-(5,0,2,10,80,939,0,940,3.14159),
-(6,0,2,10,80,0,0,0,0),
-(7,8,15,61,80,1103,3.40156,1104,0.263892),
-(8,0,2,10,80,1258,0,1259,3.14159),
-(9,7,15,71,80,1367,0,1368,0),
-(10,5,5,10,80,1362,0,1363,0),
-(11,5,5,10,80,1364,0,1365,0),
-(30,20,40,71,80,1485,0,1486,0),
-(32,10,10,0,80,0,0,0,0);
+INSERT INTO `battleground_template` (`id`,`MinPlayersPerTeam`,`MaxPlayersPerTeam`,`MinLvl`,`MaxLvl`,`AllianceStartLoc`,`AllianceStartO`,`HordeStartLoc`,`HordeStartO`, `Weight`) VALUES
+(1,20,40,51,80,611,2.72532,610,2.27452,1),
+(2,5,10,10,80,769,3.14159,770,3.14159,1),
+(3,8,15,20,80,890,3.40156,889,0.263892,1),
+(4,0,2,10,80,929,0,936,3.14159,1),
+(5,0,2,10,80,939,0,940,3.14159,1),
+(6,0,2,10,80,0,0,0,0,1),
+(7,8,15,61,80,1103,3.40156,1104,0.263892,1),
+(8,0,2,10,80,1258,0,1259,3.14159,1),
+(9,7,15,71,80,1367,0,1368,0,1),
+(10,5,5,10,80,1362,0,1363,0,1),
+(11,5,5,10,80,1364,0,1365,0,1),
+(30,20,40,71,80,1485,0,1486,0,1),
+(32,10,10,0,80,0,0,0,0,1);
 /*!40000 ALTER TABLE `battleground_template` ENABLE KEYS */;
 UNLOCK TABLES;
 
diff --git a/sql/updates/9135_world_battleground_template.sql b/sql/updates/9135_world_battleground_template.sql
new file mode 100644
index 00000000000..cf66584e12b
--- /dev/null
+++ b/sql/updates/9135_world_battleground_template.sql
@@ -0,0 +1 @@
+ALTER TABLE `battleground_template` ADD `Weight` tinyint(2) UNSIGNED NOT NULL DEFAULT 1 AFTER `HordeStartO`;