From 7c9f6b4bc37eec7b94aaba1cd8912bd5c0054e2a Mon Sep 17 00:00:00 2001
From: win32 <none@none>
Date: Sun, 20 Dec 2009 13:35:08 +0200
Subject: Merge MaNGOS, Gossip System. Autor NoFantasy. * DB support required *
 Closes #859

--HG--
branch : trunk
---
 sql/world.sql | 170 ++++++++++++++++++++++++++++++++++++----------------------
 1 file changed, 105 insertions(+), 65 deletions(-)

(limited to 'sql/world.sql')

diff --git a/sql/world.sql b/sql/world.sql
index da84099a59e..3de75d0c3dc 100644
--- a/sql/world.sql
+++ b/sql/world.sql
@@ -503,6 +503,7 @@ CREATE TABLE `creature_template` (
   `name` char(100) NOT NULL default '0',
   `subname` char(100) default NULL,
   `IconName` char(100) default NULL,
+  `gossip_menu_id` mediumint(8) unsigned NOT NULL default '0',
   `minlevel` tinyint(3) unsigned NOT NULL default '1',
   `maxlevel` tinyint(3) unsigned NOT NULL default '1',
   `minhealth` int(10) unsigned NOT NULL default '0',
@@ -1170,6 +1171,80 @@ CREATE TABLE `gameobject_template` (
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Gameobject System';
 SET character_set_client = @saved_cs_client;
 
+--
+-- Table structure for table `gossip_menu`
+--
+
+DROP TABLE IF EXISTS `gossip_menu`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `gossip_menu` (
+  `entry` smallint(6) unsigned NOT NULL default '0',
+  `text_id` mediumint(8) unsigned NOT NULL default '0',
+  `cond_1` tinyint(3) unsigned NOT NULL default '0',
+  `cond_1_val_1` mediumint(8) unsigned NOT NULL default '0',
+  `cond_1_val_2` mediumint(8) unsigned NOT NULL default '0',
+  `cond_2` tinyint(3) unsigned NOT NULL default '0',
+  `cond_2_val_1` mediumint(8) unsigned NOT NULL default '0',
+  `cond_2_val_2` mediumint(8) unsigned NOT NULL default '0',
+  PRIMARY KEY (`entry`, `text_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Gossip System';
+SET character_set_client = @saved_cs_client;
+
+--
+-- Table structure for table `gossip_menu_option`
+--
+
+DROP TABLE IF EXISTS `gossip_menu_option`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `gossip_menu_option` (
+  `menu_id` smallint(6) unsigned NOT NULL default '0',
+  `id` smallint(6) unsigned NOT NULL default '0',
+  `option_icon` mediumint(8) unsigned NOT NULL default '0',
+  `option_text` text,
+  `option_id` tinyint(3) unsigned NOT NULL default '0',
+  `npc_option_npcflag` int(10) unsigned NOT NULL default '0',
+  `action_menu_id` mediumint(8) unsigned NOT NULL default '0',
+  `action_poi_id` mediumint(8) unsigned NOT NULL default '0',
+  `action_script_id` mediumint(8) unsigned NOT NULL default '0',
+  `box_coded` tinyint(3) unsigned NOT NULL default '0',
+  `box_money` int(11) unsigned NOT NULL default '0',
+  `box_text` text,
+  `cond_1` tinyint(3) unsigned NOT NULL default '0',
+  `cond_1_val_1` mediumint(8) unsigned NOT NULL default '0',
+  `cond_1_val_2` mediumint(8) unsigned NOT NULL default '0',
+  `cond_2` tinyint(3) unsigned NOT NULL default '0',
+  `cond_2_val_1` mediumint(8) unsigned NOT NULL default '0',
+  `cond_2_val_2` mediumint(8) unsigned NOT NULL default '0',
+  `cond_3` tinyint(3) unsigned NOT NULL default '0',
+  `cond_3_val_1` mediumint(8) unsigned NOT NULL default '0',
+  `cond_3_val_2` mediumint(8) unsigned NOT NULL default '0',
+  PRIMARY KEY (`menu_id`, `id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Gossip System';
+SET character_set_client = @saved_cs_client;
+
+--
+-- Table structure for table `gossip_scripts`
+--
+
+DROP TABLE IF EXISTS `gossip_scripts`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `gossip_scripts` (
+  `id` mediumint(8) unsigned NOT NULL default '0',
+  `delay` int(10) unsigned NOT NULL default '0',
+  `command` mediumint(8) unsigned NOT NULL default '0',
+  `datalong` mediumint(8) unsigned NOT NULL default '0',
+  `datalong2` int(10) unsigned NOT NULL default '0',
+  `dataint` int(11) NOT NULL default '0',
+  `x` float NOT NULL default '0',
+  `y` float NOT NULL default '0',
+  `z` float NOT NULL default '0',
+  `o` float NOT NULL default '0'
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Gossip System';
+SET character_set_client = @saved_cs_client;
+
 --
 -- Table structure for table `instance_template`
 --
@@ -1480,6 +1555,36 @@ CREATE TABLE `locales_gameobject` (
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 SET character_set_client = @saved_cs_client;
 
+--
+-- Table structure for table `locales_gossip_menu_option`
+--
+
+DROP TABLE IF EXISTS `locales_gossip_menu_option`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `locales_gossip_menu_option` (
+  `menu_id` smallint(6) unsigned NOT NULL default '0',
+  `id` smallint(6) unsigned NOT NULL default '0',
+  `option_text_loc1` text,
+  `option_text_loc2` text,
+  `option_text_loc3` text,
+  `option_text_loc4` text,
+  `option_text_loc5` text,
+  `option_text_loc6` text,
+  `option_text_loc7` text,
+  `option_text_loc8` text,
+  `box_text_loc1` text,
+  `box_text_loc2` text,
+  `box_text_loc3` text,
+  `box_text_loc4` text,
+  `box_text_loc5` text,
+  `box_text_loc6` text,
+  `box_text_loc7` text,
+  `box_text_loc8` text,
+  PRIMARY KEY  (`menu_id`, `id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+SET character_set_client = @saved_cs_client;
+
 --
 -- Table structure for table `locales_item`
 --
@@ -1509,35 +1614,6 @@ CREATE TABLE `locales_item` (
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 SET character_set_client = @saved_cs_client;
 
---
--- Table structure for table `locales_npc_option`
---
-
-DROP TABLE IF EXISTS `locales_npc_option`;
-SET @saved_cs_client     = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `locales_npc_option` (
-  `entry` mediumint(8) unsigned NOT NULL default '0',
-  `option_text_loc1` text,
-  `option_text_loc2` text,
-  `option_text_loc3` text,
-  `option_text_loc4` text,
-  `option_text_loc5` text,
-  `option_text_loc6` text,
-  `option_text_loc7` text,
-  `option_text_loc8` text,
-  `box_text_loc1` text,
-  `box_text_loc2` text,
-  `box_text_loc3` text,
-  `box_text_loc4` text,
-  `box_text_loc5` text,
-  `box_text_loc6` text,
-  `box_text_loc7` text,
-  `box_text_loc8` text,
-  PRIMARY KEY  (`entry`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-SET character_set_client = @saved_cs_client;
-
 --
 -- Table structure for table `locales_npc_text`
 --
@@ -1883,42 +1959,6 @@ CREATE TABLE `npc_gossip` (
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 SET character_set_client = @saved_cs_client;
 
---
--- Table structure for table `npc_gossip_textid`
---
-
-DROP TABLE IF EXISTS `npc_gossip_textid`;
-SET @saved_cs_client     = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `npc_gossip_textid` (
-  `zoneid` smallint(5) unsigned NOT NULL default '0',
-  `action` smallint(5) unsigned NOT NULL default '0',
-  `textid` mediumint(8) unsigned NOT NULL default '0',
-  KEY `zoneid` (`zoneid`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-SET character_set_client = @saved_cs_client;
-
---
--- Table structure for table `npc_option`
---
-
-DROP TABLE IF EXISTS `npc_option`;
-SET @saved_cs_client     = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `npc_option` (
-  `id` mediumint(8) unsigned NOT NULL default '0',
-  `gossip_id` mediumint(8) unsigned NOT NULL default '0',
-  `npcflag` int(10) unsigned NOT NULL default '0',
-  `icon` tinyint(3) unsigned NOT NULL default '0',
-  `action` mediumint(8) unsigned NOT NULL default '0',
-  `box_money` int(10) unsigned NOT NULL default '0',
-  `coded` tinyint(3) unsigned NOT NULL default '0',
-  `option_text` text,
-  `box_text` text,
-  PRIMARY KEY  (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-SET character_set_client = @saved_cs_client;
-
 --
 -- Table structure for table `npc_spellclick_spells`
 --
-- 
cgit v1.2.3

