From a19c6cd50f08d2ecf41c01ffdd3cb611f6e60875 Mon Sep 17 00:00:00 2001 From: Drahy Date: Fri, 8 May 2009 09:57:45 +0200 Subject: * Lost some sql files for sql coding style --HG-- branch : trunk --- sql/updates/3121_world_scripts.sql | 2 +- sql/updates/3148_mangos_7776_01_world_npc_spellclick_spells.sql | 4 ++-- 2 files changed, 3 insertions(+), 3 deletions(-) (limited to 'sql') diff --git a/sql/updates/3121_world_scripts.sql b/sql/updates/3121_world_scripts.sql index af79cbd0cfd..acd97805eb9 100644 --- a/sql/updates/3121_world_scripts.sql +++ b/sql/updates/3121_world_scripts.sql @@ -1 +1 @@ -UPDATE `creature_template` SET `ScriptName`='npc_dragonflayer_forge_master' WHERE `entry` = 24079; \ No newline at end of file +UPDATE `creature_template` SET `ScriptName`='npc_dragonflayer_forge_master' WHERE `entry` =24079; \ No newline at end of file diff --git a/sql/updates/3148_mangos_7776_01_world_npc_spellclick_spells.sql b/sql/updates/3148_mangos_7776_01_world_npc_spellclick_spells.sql index c8cd342a7f7..9fe7042bdd4 100644 --- a/sql/updates/3148_mangos_7776_01_world_npc_spellclick_spells.sql +++ b/sql/updates/3148_mangos_7776_01_world_npc_spellclick_spells.sql @@ -1,8 +1,8 @@ -ALTER TABLE db_version CHANGE COLUMN required_7720_01_mangos_mangos_string required_7776_01_mangos_npc_spellclick_spells bit; +/*ALTER TABLE db_version CHANGE COLUMN required_7720_01_mangos_mangos_string required_7776_01_mangos_npc_spellclick_spells bit;*/ CREATE TABLE `npc_spellclick_spells` ( `npc_entry` INT UNSIGNED NOT NULL COMMENT 'reference to creature_template', `spell_id` INT UNSIGNED NOT NULL COMMENT 'spell which should be casted ', `quest_id` INT UNSIGNED NOT NULL COMMENT 'reference to quest_template', `cast_flags` TINYINT UNSIGNED NOT NULL COMMENT 'first bit defines caster: 1=player, 0=creature; second bit defines target, same mapping as caster bit' -) ENGINE = MYISAM DEFAULT CHARSET=utf8; +) ENGINE = MYISAM DEFAULT CHARSET=utf8; \ No newline at end of file -- cgit v1.2.3