From 4b47c30641d31661c530e21dfd24a79b405736d2 Mon Sep 17 00:00:00 2001 From: "runningnak3d@mangos.zipwow.ano" Date: Mon, 15 Dec 2008 10:42:35 +0000 Subject: * Fix revent SQL commits * Fix EOL issues on all SQL files --HG-- branch : trunk --- sql/updates/176_world.sql | 64 +++++++++++++++++++++++------------------------ 1 file changed, 32 insertions(+), 32 deletions(-) (limited to 'sql/updates/176_world.sql') diff --git a/sql/updates/176_world.sql b/sql/updates/176_world.sql index 03c720d7ef5..12df2a083ca 100644 --- a/sql/updates/176_world.sql +++ b/sql/updates/176_world.sql @@ -1,32 +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'; +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