aboutsummaryrefslogtreecommitdiff
path: root/sql/base/world_database.sql
diff options
context:
space:
mode:
authorrunningnak3d <runningnak3d@gmail.com>2011-02-11 13:04:45 -0700
committerrunningnak3d <runningnak3d@gmail.com>2011-02-11 13:04:45 -0700
commit05e075ce0ec0b758bca9a183b3a401c620fd58a7 (patch)
tree2407211a570a2b9efb779578612c10fc67c4d4a1 /sql/base/world_database.sql
parente609d18588a7941353e356731c6a5a0aace14d8f (diff)
Core/Gossip: Remove support for `npc_gossip` table (DEPRECATED).
Diffstat (limited to 'sql/base/world_database.sql')
-rw-r--r--sql/base/world_database.sql28
1 files changed, 2 insertions, 26 deletions
diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql
index 5b558c9abcd..454a0adff74 100644
--- a/sql/base/world_database.sql
+++ b/sql/base/world_database.sql
@@ -566,11 +566,11 @@ INSERT INTO `command` VALUES
('reload all achievement',3,'Syntax: .reload all achievement\r\n\r\nReload achievement_reward, achievement_criteria_data tables.'),
('reload all area',3,'Syntax: .reload all area\r\n\r\nReload areatrigger_teleport, areatrigger_tavern, game_graveyard_zone tables.'),
('reload all eventai',3,'Syntax: .reload all eventai\r\n\r\nReload creature_ai_scripts, creature_ai_summons, creature_ai_texts tables.'),
-('reload all gossips',3,'Syntax: .reload all gossips\nReload gossip_menu, gossip_menu_option, gossip_scripts, npc_gossip, points_of_interest tables.'),
+('reload all gossips',3,'Syntax: .reload all gossips\nReload gossip_menu, gossip_menu_option, gossip_scripts, points_of_interest tables.'),
('reload all item',3,'Syntax: .reload all item\nReload page_text, item_enchantment_table tables.'),
('reload all locales',3,'Syntax: .reload all locales\r\n\r\nReload all `locales_*` tables with reload support added and that can be _safe_ reloaded.'),
('reload all loot',3,'Syntax: .reload all loot\r\n\r\nReload all `*_loot_template` tables. This can be slow operation with lags for server run.'),
-('reload all npc',3,'Syntax: .reload all npc\nReload npc_gossip, npc_option, npc_trainer, npc vendor, points of interest tables.'),
+('reload all npc',3,'Syntax: .reload all npc\nReload npc_option, npc_trainer, npc vendor, points of interest tables.'),
('reload all quest',3,'Syntax: .reload all quest\r\n\r\nReload all quest related tables if reload support added for this table and this table can be _safe_ reloaded.'),
('reload all scripts',3,'Syntax: .reload all scripts\nReload gameobject_scripts, event_scripts, quest_end_scripts, quest_start_scripts, spell_scripts, db_script_string, waypoint_scripts tables.'),
('reload all spell',3,'Syntax: .reload all spell\r\n\r\nReload all `spell_*` tables with reload support added and that can be _safe_ reloaded.'),
@@ -619,7 +619,6 @@ INSERT INTO `command` VALUES
('reload mail_level_reward',3,'Syntax: .reload mail_level_reward\nReload mail_level_reward table.'),
('reload mail_loot_template',3,'Syntax: .reload mail_loot_template\nReload mail_loot_template table.'),
('reload milling_loot_template',3,'Syntax: .reload milling_loot_template\nReload milling_loot_template table.'),
-('reload npc_gossip',3,'Syntax: .reload npc_gossip\nReload npc_gossip table.'),
('reload npc_trainer',3,'Syntax: .reload npc_trainer\nReload npc_trainer table.'),
('reload npc_vendor',3,'Syntax: .reload npc_vendor\nReload npc_vendor table.'),
('reload page_text',3,'Syntax: .reload page_text\nReload page_text table.'),
@@ -3778,29 +3777,6 @@ LOCK TABLES `milling_loot_template` WRITE;
UNLOCK TABLES;
--
--- Table structure for table `npc_gossip`
---
-
-DROP TABLE IF EXISTS `npc_gossip`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `npc_gossip` (
- `npc_guid` int(10) unsigned NOT NULL DEFAULT '0',
- `textid` mediumint(8) unsigned NOT NULL DEFAULT '0',
- PRIMARY KEY (`npc_guid`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `npc_gossip`
---
-
-LOCK TABLES `npc_gossip` WRITE;
-/*!40000 ALTER TABLE `npc_gossip` DISABLE KEYS */;
-/*!40000 ALTER TABLE `npc_gossip` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
-- Table structure for table `npc_spellclick_spells`
--