Y64CK0tx

1/*
2SQLyog Enterprise - MySQL GUI v5.02
3Host - 5.1.41 : Database - skyfire_world
4*********************************************************************
5Server version : 5.1.41
6*/
7
8
9/*Table structure for table `battleground_template` */
10
11DROP TABLE IF EXISTS `battleground_template`;
12
13CREATE TABLE `battleground_template` (
14  `id` mediumint(8) unsigned NOT NULL,
15  `MinPlayersPerTeam` smallint(5) unsigned NOT NULL DEFAULT '0',
16  `MaxPlayersPerTeam` smallint(5) unsigned NOT NULL DEFAULT '0',
17  `MinLvl` tinyint(3) unsigned NOT NULL DEFAULT '0',
18  `MaxLvl` tinyint(3) unsigned NOT NULL DEFAULT '0',
19  `AllianceStartLoc` mediumint(8) unsigned NOT NULL,
20  `AllianceStartO` float NOT NULL,
21  `HordeStartLoc` mediumint(8) unsigned NOT NULL,
22  `HordeStartO` float NOT NULL,
23  `Weight` tinyint(2) unsigned NOT NULL DEFAULT '1',
24  `ScriptName` char(64) NOT NULL DEFAULT '',
25  `Comment` char(32) NOT NULL,
26  PRIMARY KEY (`id`)
27) ENGINE=MyISAM DEFAULT CHARSET=utf8;
28
29/*Data for the table `battleground_template` */
30
31insert into `battleground_template` values 
32
33(1,20,40,51,85,611,3.16312,610,0.715504,1,'','Alterac Valley'),
34
35(2,5,10,10,85,769,3.14159,770,0.151581,1,'','Warsong Gulch'),
36
37(3,8,15,20,85,890,3.91571,889,0.813671,1,'','Arathi Basin'),
38
39(7,8,15,61,85,1103,3.03123,1104,0.055761,1,'','Eye of The Storm'),
40
41(4,0,2,10,85,929,0,936,3.14159,1,'','Nagrand Arena'),
42
43(5,0,2,10,85,939,0,940,3.14159,1,'','Blades\'s Edge Arena'),
44
45(6,0,2,10,85,0,0,0,0,1,'','All Arena'),
46
47(8,0,2,10,85,1258,0,1259,3.14159,1,'','Ruins of Lordaeron'),
48
49(9,7,15,71,85,1367,0,1368,0,1,'','Strand of the Ancients'),
50
51(10,5,5,10,85,1362,0,1363,0,1,'','Dalaran Sewers'),
52
53(11,5,5,10,85,1364,0,1365,0,1,'','The Ring of Valor'),
54
55(30,20,40,71,85,1485,0,1486,3.16124,1,'','Isle of Conquest'),
56
57(32,10,10,0,85,0,0,0,0,1,'','Random battleground'),
58
59(108,10,10,1,85,1726,0,1727,0,1,'','Twin Peaks'),
60
61(120,5,5,1,85,1740,0,1739,0,1,'','The Battle for Gilneas');