sql/updates/09763_01_mangos_battleground_template.sql

   1 ALTER TABLE db_version CHANGE COLUMN required_9761_01_mangos_mangos_string required_9763_01_mangos_battleground_template bit;
   2
   3 ALTER TABLE battleground_template
   4   DROP COLUMN MinLvl,
   5   DROP COLUMN MaxLvl;
   6
   7 DELETE FROM `battleground_template`;
   8 INSERT INTO `battleground_template` VALUES
   9 (1,40,40,611,2.72532,610,2.27452),
  10 (2,10,10,769,3.14159,770,3.14159),
  11 (3,15,15,890,3.40156,889,0.263892),
  12 (4,5,5,929,0,936,3.14159),
  13 (5,5,5,939,0,940,3.14159),
  14 (6,5,5,0,0,0,0),
  15 (7,15,15,1103,3.40156,1104,0.263892),
  16 (8,5,5,1258,0,1259,3.14159),
  17 (9,15,15,1367,0,1368,0),
  18 (10,5,5,1362,0,1363,0),
  19 (11,5,5,1364,0,1365,0),
  20 (30,40,40,1485,0,1486,0),
  21 (32,5,40,0,0,0,0);