diff options
| author | Duarte Duarte <dnpd.dd@gmail.com> | 2014-01-31 15:15:30 +0000 |
|---|---|---|
| committer | Duarte Duarte <dnpd.dd@gmail.com> | 2014-01-31 15:16:02 +0000 |
| commit | ad26d2efc3c58fd14639b30ea45991868884461d (patch) | |
| tree | ddd0e2d92a77716c51fd680c06a63cfbfb7cdd9f /sql | |
| parent | a242662ae6fd424928c3972de1232b43e7164457 (diff) | |
SQL: Fixed two issues with 2014_01_31_00_world_spell_custom_attr.sql
Engine should be MyISAM and not MRG_MyISAM
MySQL doesn't play nice with hex values so converted them to decimal
Closes #11537
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2014_01_31_00_world_spell_custom_attr.sql | 32 |
1 files changed, 16 insertions, 16 deletions
diff --git a/sql/updates/world/2014_01_31_00_world_spell_custom_attr.sql b/sql/updates/world/2014_01_31_00_world_spell_custom_attr.sql index 54c9d84c7a9..488b09dc54e 100644 --- a/sql/updates/world/2014_01_31_00_world_spell_custom_attr.sql +++ b/sql/updates/world/2014_01_31_00_world_spell_custom_attr.sql @@ -3,23 +3,23 @@ CREATE TABLE IF NOT EXISTS `spell_custom_attr` ( `entry` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'spell id', `attributes` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'SpellCustomAttributes', PRIMARY KEY (`entry`) -) ENGINE=MRG_MyISAM DEFAULT CHARSET=utf8 COMMENT='SpellInfo custom attributes'; +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='SpellInfo custom attributes'; -SET @SPELL_ATTR0_CU_ENCHANT_PROC = 0x00000001, - @SPELL_ATTR0_CU_CONE_BACK = 0x00000002, - @SPELL_ATTR0_CU_CONE_LINE = 0x00000004, - @SPELL_ATTR0_CU_SHARE_DAMAGE = 0x00000008, - @SPELL_ATTR0_CU_NO_INITIAL_THREAT = 0x00000010, - @SPELL_ATTR0_CU_AURA_CC = 0x00000040, - @SPELL_ATTR0_CU_DIRECT_DAMAGE = 0x00000100, - @SPELL_ATTR0_CU_CHARGE = 0x00000200, - @SPELL_ATTR0_CU_PICKPOCKET = 0x00000400, - @SPELL_ATTR0_CU_NEGATIVE_EFF0 = 0x00001000, - @SPELL_ATTR0_CU_NEGATIVE_EFF1 = 0x00002000, - @SPELL_ATTR0_CU_NEGATIVE_EFF2 = 0x00004000, - @SPELL_ATTR0_CU_IGNORE_ARMOR = 0x00008000, - @SPELL_ATTR0_CU_REQ_TARGET_FACING_CASTER = 0x00010000, - @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET = 0x00020000; +SET @SPELL_ATTR0_CU_ENCHANT_PROC = 1, + @SPELL_ATTR0_CU_CONE_BACK = 2, + @SPELL_ATTR0_CU_CONE_LINE = 4, + @SPELL_ATTR0_CU_SHARE_DAMAGE = 8, + @SPELL_ATTR0_CU_NO_INITIAL_THREAT = 16, + @SPELL_ATTR0_CU_AURA_CC = 64, + @SPELL_ATTR0_CU_DIRECT_DAMAGE = 256, + @SPELL_ATTR0_CU_CHARGE = 512, + @SPELL_ATTR0_CU_PICKPOCKET = 1024, + @SPELL_ATTR0_CU_NEGATIVE_EFF0 = 4096, + @SPELL_ATTR0_CU_NEGATIVE_EFF1 = 8192, + @SPELL_ATTR0_CU_NEGATIVE_EFF2 = 16384, + @SPELL_ATTR0_CU_IGNORE_ARMOR = 32768, + @SPELL_ATTR0_CU_REQ_TARGET_FACING_CASTER = 65536, + @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET = 131072; INSERT INTO `spell_custom_attr` (`entry`, `attributes`) VALUES (1776, @SPELL_ATTR0_CU_REQ_TARGET_FACING_CASTER), |