From 62ed044d08425bd09053bda18d56113bd9f9a2ce Mon Sep 17 00:00:00 2001
From: KingPin <none@none>
Date: Wed, 5 Nov 2008 09:22:56 -0600
Subject: [svn] *** Source Mangos *** *Load npc_options at server startup, use
 cached data at creature gossip menu init. * Also new .reload table command
 added *Implement npc_option localization support, also store in DB
 BoxText/BoxMoney/Coded * Use characters.guid instead low guid value from
 characters.data in charcter enum data prepering for client. * Fixed crash at
 .pinfo command use from console. * Fixed windows ad.exe build *Creature
 related code and DB cleanups. * Rename 2 creature_template fields to more
 clean names and related code update also. * Use enum values instead raw
 values for type_flags, use halper functions instead code repeating. * Move
 tamed pet creating code to new function.

** Small code changes to make things compliant with above changes.
** Another rev with big changes so test away.

--HG--
branch : trunk
---
 sql/updates/176_world.sql | 32 ++++++++++++++++++++++++++++++++
 1 file changed, 32 insertions(+)
 create mode 100644 sql/updates/176_world.sql

(limited to 'sql/updates/176_world.sql')

diff --git a/sql/updates/176_world.sql b/sql/updates/176_world.sql
new file mode 100644
index 00000000000..03c720d7ef5
--- /dev/null
+++ b/sql/updates/176_world.sql
@@ -0,0 +1,32 @@
+ALTER TABLE `npc_option`
+  CHANGE COLUMN `id` `id` mediumint(8) unsigned NOT NULL default '0',
+  CHANGE COLUMN `gossip_id` `gossip_id` mediumint(8) unsigned NOT NULL default '0',
+  CHANGE COLUMN `action` `action` mediumint(8) unsigned NOT NULL default '0',
+  ADD COLUMN `box_money` int(10) unsigned NOT NULL default '0' AFTER `action`,
+  ADD COLUMN `coded` tinyint(3) unsigned NOT NULL default '0' AFTER `box_money`,
+  ADD COLUMN `box_text` text AFTER `option_text`;
+
+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;
+
+ALTER TABLE `creature_template`
+  CHANGE COLUMN `flags` `unit_flags` int(10) unsigned NOT NULL default '0',
+  CHANGE COLUMN `flag1` `type_flags` int(10) unsigned NOT NULL default '0';
-- 
cgit v1.2.3

