From b63a31f513db5274e85afc323d143292d8f3e88f Mon Sep 17 00:00:00 2001 From: XTZGZoReX Date: Fri, 6 Aug 2010 18:03:09 +0200 Subject: * Added outdoorpvp_template table (currently unused). * Added DISABLE_TYPE_OUTDOORPVP (5) which can disable outdoorpvp_template entries. --HG-- branch : trunk --- sql/base/world_database.sql | 24 ++++++++++++++++++++++++ sql/updates/9198_world_outdoorpvp_template.sql | 7 +++++++ 2 files changed, 31 insertions(+) create mode 100644 sql/updates/9198_world_outdoorpvp_template.sql (limited to 'sql') 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 @@ -3840,6 +3840,30 @@ LOCK TABLES `npc_vendor` WRITE; /*!40000 ALTER TABLE `npc_vendor` ENABLE KEYS */; 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'; -- cgit v1.2.3