2 files changed, 31 insertions, 0 deletions
diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql
index b354c82316c..8e769eb010e 100644
--- a/sql/base/world_database.sql
+++ b/sql/base/world_database.sql
@@ -3841,6 +3841,30 @@ LOCK TABLES `npc_vendor` WRITE;
 UNLOCK TABLES;
 
 --
+-- Table structure for table `outdoorpvp_template`
+--
+
+DROP TABLE IF EXISTS `outdoorpvp_template`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `outdoorpvp_template` (
+  `TypeId` tinyint(2) unsigned NOT NULL,
+  `ScriptName` char(64) NOT NULL DEFAULT '',
+  `comment` text,
+  PRIMARY KEY (`TypeId`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='OutdoorPvP Templates';
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `outdoorpvp_template`
+--
+
+LOCK TABLES `outdoorpvp_template` WRITE;
+/*!40000 ALTER TABLE `outdoorpvp_template` DISABLE KEYS */;
+/*!40000 ALTER TABLE `outdoorpvp_template` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
 -- Table structure for table `page_text`
 --
 
diff --git a/sql/updates/9198_world_outdoorpvp_template.sql b/sql/updates/9198_world_outdoorpvp_template.sql
new file mode 100644
index 00000000000..eb474227b9d
--- /dev/null
+++ b/sql/updates/9198_world_outdoorpvp_template.sql
@@ -0,0 +1,7 @@
+DROP TABLE IF EXISTS `outdoorpvp_template`;
+CREATE TABLE `outdoorpvp_template` (
+  `TypeId` tinyint(2) unsigned NOT NULL,
+  `ScriptName` char(64) NOT NULL DEFAULT '',
+  `comment` text,
+  PRIMARY KEY (`TypeId`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='OutdoorPvP Templates';