DB/SQL: No tabs nor CR line feeds

26 files changed, 252 insertions, 253 deletions

diff --git a/sql/old/2.4.3/00542_characters.sql b/sql/old/2.4.3/00542_characters.sql
index 4cc3bebea80..f03c03f900f 100644
--- a/sql/old/2.4.3/00542_characters.sql
+++ b/sql/old/2.4.3/00542_characters.sql
@@ -22,7 +22,7 @@ SET
 WHERE 
     `a`.`arenateamid` = `b`.`atid` AND 
     `a`.`guid` = `b`.`b_guid`;
-	
+
 UPDATE 
     `arena_team_member` AS `a`, 
     (SELECT
@@ -47,7 +47,7 @@ SET
 WHERE 
     `a`.`arenateamid` = `b`.`atid` AND 
     `a`.`guid` = `b`.`b_guid`;
-	
+
 UPDATE 
     `arena_team_member` AS `a`, 
     (SELECT
diff --git a/sql/old/2.4.3/00762_world.sql b/sql/old/2.4.3/00762_world.sql
index ce64e8c9065..ed7b2ab5241 100644
--- a/sql/old/2.4.3/00762_world.sql
+++ b/sql/old/2.4.3/00762_world.sql
@@ -1,6 +1,6 @@
 DROP TABLE IF EXISTS `transport_events`;
 CREATE TABLE `transport_events` (
- 	`entry` int(11) unsigned NOT NULL default '0',
-	`waypoint_id` int(11) unsigned NOT NULL default '0',	
-  `event_id` int(11) unsigned NOT NULL default '0'
+`entry` int(11) unsigned NOT NULL default '0',
+`waypoint_id` int(11) unsigned NOT NULL default '0',
+`event_id` int(11) unsigned NOT NULL default '0'
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
diff --git a/sql/old/2.4.3/00764_world_scripts.sql b/sql/old/2.4.3/00764_world_scripts.sql
index 52592cd8ad3..86e57979e41 100644
--- a/sql/old/2.4.3/00764_world_scripts.sql
+++ b/sql/old/2.4.3/00764_world_scripts.sql
@@ -118,6 +118,6 @@ INSERT INTO `script_texts` (`entry`,`content_default`,`sound`,`type`,`language`,
 (-1533106,'Your petty magics are no challenge to the might of the Scourge! ',14481,1,0,'kelthuzad SAY_SPECIAL1_MANA_DET'),
 (-1533107,'Enough! I grow tired of these distractions! ',14483,1,0,'kelthuzad SAY_SPECIAL3_MANA_DET'),
 (-1533108,'Fools, you have spread your powers too thin. Be free, my minions!',14482,1,0,'kelthuzad SAY_SPECIAL2_DISPELL');
-	
+
 UPDATE `script_texts` SET `sound`=8902 WHERE `entry`=-1533055;
 UPDATE `script_texts` SET `sound`=8901 WHERE `entry`=-1533056;
diff --git a/sql/old/3.0.9/00000_3.0.9_old.sql b/sql/old/3.0.9/00000_3.0.9_old.sql
index daa56fa6373..fa57faa3778 100644
--- a/sql/old/3.0.9/00000_3.0.9_old.sql
+++ b/sql/old/3.0.9/00000_3.0.9_old.sql
@@ -119,7 +119,7 @@ INSERT INTO `script_texts` (`entry`,`content_default`,`sound`,`type`,`language`,
 (-1533106,'Your petty magics are no challenge to the might of the Scourge! ',14481,1,0,'kelthuzad SAY_SPECIAL1_MANA_DET'),
 (-1533107,'Enough! I grow tired of these distractions! ',14483,1,0,'kelthuzad SAY_SPECIAL3_MANA_DET'),
 (-1533108,'Fools, you have spread your powers too thin. Be free, my minions!',14482,1,0,'kelthuzad SAY_SPECIAL2_DISPELL');
-	
+
 UPDATE `script_texts` SET `sound`=8902 WHERE `entry`=-1533055;
 UPDATE `script_texts` SET `sound`=8901 WHERE `entry`=-1533056;
 
diff --git a/sql/old/3.0.9/03637_world_spell.sql b/sql/old/3.0.9/03637_world_spell.sql
index c2fe66a5df1..97cfaf55e90 100644
--- a/sql/old/3.0.9/03637_world_spell.sql
+++ b/sql/old/3.0.9/03637_world_spell.sql
@@ -4,4 +4,4 @@ INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES
 
 DELETE FROM `spell_proc_event` WHERE `entry`=56816;
 INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES
-(56816,	0x00,	0,	0x00000000,	0x00000000,	0x00000000,	0x00000000,	0x00000030,	0,	0,	0); -- Rune Strike
+(56816, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000030, 0, 0, 0); -- Rune Strike
diff --git a/sql/old/3.0.9/03801_world_spell.sql b/sql/old/3.0.9/03801_world_spell.sql
index 8fabcad1c58..4656c66f2aa 100644
--- a/sql/old/3.0.9/03801_world_spell.sql
+++ b/sql/old/3.0.9/03801_world_spell.sql
@@ -1,6 +1,6 @@
 DELETE FROM `spell_proc_event` WHERE `entry` IN (44544, 60503, 36032);
 INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES
-(36032,	0x00,	3,	0x00000800,	0x00008000,	0x00000000,	0x00000000,	0x00000000,	0,	0,	0); -- Arcane Blast
+(36032, 0x00, 3, 0x00000800, 0x00008000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0); -- Arcane Blast
 
 DELETE FROM `spell_affect` WHERE `entry` IN (44544);
 INSERT INTO `spell_affect` (`entry`, `effectId`, `SpellClassMask0`, `SpellClassMask1`, `SpellClassMask2`) VALUES
diff --git a/sql/old/3.0.9/03899_world_spell_proc_event.sql b/sql/old/3.0.9/03899_world_spell_proc_event.sql
index bc8b159bd9a..4dfa2e3011a 100644
--- a/sql/old/3.0.9/03899_world_spell_proc_event.sql
+++ b/sql/old/3.0.9/03899_world_spell_proc_event.sql
@@ -1,4 +1,4 @@
 DELETE FROM `spell_proc_event` WHERE `entry` IN (18096, 18073);
 INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES
-(18096,	0x00,	5,	0x00000060,	0x00800080,	0x00000000,	0x00000000,	0x00000000,	0,	0,	0), -- Pyroclasm (Rank 1)
-(18073,	0x00,	5,	0x00000060,	0x00800080,	0x00000000,	0x00000000,	0x00000000,	0,	0,	0); -- Pyroclasm (Rank 2)
+(18096, 0x00, 5, 0x00000060, 0x00800080, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Pyroclasm (Rank 1)
+(18073, 0x00, 5, 0x00000060, 0x00800080, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0); -- Pyroclasm (Rank 2)
diff --git a/sql/old/3.0.9/03903_world_spell_proc_event.sql b/sql/old/3.0.9/03903_world_spell_proc_event.sql
index ab534ece0a8..e3e85dce1d9 100644
--- a/sql/old/3.0.9/03903_world_spell_proc_event.sql
+++ b/sql/old/3.0.9/03903_world_spell_proc_event.sql
@@ -1,3 +1,3 @@
 DELETE FROM `spell_proc_event` WHERE `entry` IN (56249);
 INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES
-(56249,	0x00,	5,	0x00000000,	0x00000000,	0x00000400,	0x00000000,	0x00000000,	0,	0,	0); -- Glyph of Felhunter
+(56249, 0x00, 5, 0x00000000, 0x00000000, 0x00000400, 0x00000000, 0x00000000, 0, 0, 0); -- Glyph of Felhunter
diff --git a/sql/old/3.0.9/805_world_scripts.sql b/sql/old/3.0.9/805_world_scripts.sql
index be57e9c1574..cfeeea149f5 100644
--- a/sql/old/3.0.9/805_world_scripts.sql
+++ b/sql/old/3.0.9/805_world_scripts.sql
@@ -118,6 +118,6 @@ INSERT INTO `script_texts` (`entry`,`content_default`,`sound`,`type`,`language`,
 (-1533106,'Your petty magics are no challenge to the might of the Scourge! ',14481,1,0,'kelthuzad SAY_SPECIAL1_MANA_DET'),
 (-1533107,'Enough! I grow tired of these distractions! ',14483,1,0,'kelthuzad SAY_SPECIAL3_MANA_DET'),
 (-1533108,'Fools, you have spread your powers too thin. Be free, my minions!',14482,1,0,'kelthuzad SAY_SPECIAL2_DISPELL');
-	
+
 UPDATE `script_texts` SET `sound`=8902 WHERE `entry`=-1533055;
 UPDATE `script_texts` SET `sound`=8901 WHERE `entry`=-1533056;
diff --git a/sql/old/3.1.3/03920_characters_309-313_converter.sql b/sql/old/3.1.3/03920_characters_309-313_converter.sql
index 1a711f3a027..c5aa5ee9b0e 100644
--- a/sql/old/3.1.3/03920_characters_309-313_converter.sql
+++ b/sql/old/3.1.3/03920_characters_309-313_converter.sql
@@ -30,34 +30,34 @@ CREATE TABLE `character_equipmentsets` (
 UPDATE characters SET data = REPLACE(data,'  ',' ');
 UPDATE characters SET data = CONCAT(TRIM(data),' ');
 UPDATE `characters` SET `data` = CONCAT(
-	SUBSTRING_INDEX(`data`, ' ', 257 + 1), ' ',
-	SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 1), ' ', -261 + 260 - 1), ' ',
-	SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18 + 1), ' ', -261 - 18 + 260 + 18 - 1), ' ',
-	SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*2 + 1), ' ', -261 - 18*2 + 260 + 18*2 - 1), ' ',
-	SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*3 + 1), ' ', -261 - 18*3 + 260 + 18*3 - 1), ' ',
-	SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*4 + 1), ' ', -261 - 18*4 + 260 + 18*4 - 1), ' ',
-	SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*5 + 1), ' ', -261 - 18*5 + 260 + 18*5 - 1), ' ',
-	SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*6 + 1), ' ', -261 - 18*6 + 260 + 18*6 - 1), ' ',
-	SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*7 + 1), ' ', -261 - 18*7 + 260 + 18*7 - 1), ' ',
-	SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*8 + 1), ' ', -261 - 18*8 + 260 + 18*8 - 1), ' ',
-	SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*9 + 1), ' ', -261 - 18*9 + 260 + 18*9 - 1), ' ',
-	SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*10 + 1), ' ', -261 - 18*10 + 260 + 18*10 - 1), ' ',
-	SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*11 + 1), ' ', -261 - 18*11 + 260 + 18*11 - 1), ' ',
-	SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*12 + 1), ' ', -261 - 18*12 + 260 + 18*12 - 1), ' ',
-	SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*13 + 1), ' ', -261 - 18*13 + 260 + 18*13 - 1), ' ',
-	SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*14 + 1), ' ', -261 - 18*14 + 260 + 18*14 - 1), ' ',
-	SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*15 + 1), ' ', -261 - 18*15 + 260 + 18*15 - 1), ' ',
-	SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*16 + 1), ' ', -261 - 18*16 + 260 + 18*16 - 1), ' ',
-	SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*17 + 1), ' ', -261 - 18*17 + 260 + 18*17 - 1), ' ',
-	SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*18 + 1), ' ', -261 - 18*18 + 260 + 18*18 - 1), ' ',
-	SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 837 + 1), ' ', -837 + 600 - 1), ' ',
-	SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 937 + 1), ' ', -937 + 874 - 1), ' ',
-	SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1007 + 1), ' ', -1007 + 1002 - 1), ' ',
-	'0 0 ',
-	SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1688 + 1), ' ', -1688 + 1008 - 1), ' ',
-	SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1696 + 1), ' ', -1696 + 1691 - 1), ' ',
-	SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1700 + 1), ' ', -1700 + 1699 - 1), ' '
-	)
+    SUBSTRING_INDEX(`data`, ' ', 257 + 1), ' ',
+    SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 1), ' ', -261 + 260 - 1), ' ',
+    SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18 + 1), ' ', -261 - 18 + 260 + 18 - 1), ' ',
+    SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*2 + 1), ' ', -261 - 18*2 + 260 + 18*2 - 1), ' ',
+    SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*3 + 1), ' ', -261 - 18*3 + 260 + 18*3 - 1), ' ',
+    SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*4 + 1), ' ', -261 - 18*4 + 260 + 18*4 - 1), ' ',
+    SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*5 + 1), ' ', -261 - 18*5 + 260 + 18*5 - 1), ' ',
+    SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*6 + 1), ' ', -261 - 18*6 + 260 + 18*6 - 1), ' ',
+    SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*7 + 1), ' ', -261 - 18*7 + 260 + 18*7 - 1), ' ',
+    SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*8 + 1), ' ', -261 - 18*8 + 260 + 18*8 - 1), ' ',
+    SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*9 + 1), ' ', -261 - 18*9 + 260 + 18*9 - 1), ' ',
+    SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*10 + 1), ' ', -261 - 18*10 + 260 + 18*10 - 1), ' ',
+    SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*11 + 1), ' ', -261 - 18*11 + 260 + 18*11 - 1), ' ',
+    SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*12 + 1), ' ', -261 - 18*12 + 260 + 18*12 - 1), ' ',
+    SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*13 + 1), ' ', -261 - 18*13 + 260 + 18*13 - 1), ' ',
+    SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*14 + 1), ' ', -261 - 18*14 + 260 + 18*14 - 1), ' ',
+    SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*15 + 1), ' ', -261 - 18*15 + 260 + 18*15 - 1), ' ',
+    SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*16 + 1), ' ', -261 - 18*16 + 260 + 18*16 - 1), ' ',
+    SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*17 + 1), ' ', -261 - 18*17 + 260 + 18*17 - 1), ' ',
+    SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 261 + 18*18 + 1), ' ', -261 - 18*18 + 260 + 18*18 - 1), ' ',
+    SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 837 + 1), ' ', -837 + 600 - 1), ' ',
+    SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 937 + 1), ' ', -937 + 874 - 1), ' ',
+    SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1007 + 1), ' ', -1007 + 1002 - 1), ' ',
+    '0 0 ',
+    SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1688 + 1), ' ', -1688 + 1008 - 1), ' ',
+    SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1696 + 1), ' ', -1696 + 1691 - 1), ' ',
+    SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1700 + 1), ' ', -1700 + 1699 - 1), ' '
+    )
 WHERE length(SUBSTRING_INDEX(data, ' ', 1700)) < length(data) and length(SUBSTRING_INDEX(data, ' ', 1701)) >= length(data);
 UPDATE characters SET data = REPLACE(data,'  ',' ');
 UPDATE characters SET data = CONCAT(TRIM(data),' ');
diff --git a/sql/old/3.1.3/03927_world_spell_proc_event.sql b/sql/old/3.1.3/03927_world_spell_proc_event.sql
index 526afb8c48c..cac8696c8de 100644
--- a/sql/old/3.1.3/03927_world_spell_proc_event.sql
+++ b/sql/old/3.1.3/03927_world_spell_proc_event.sql
@@ -1,5 +1,5 @@
 DELETE FROM `spell_proc_event` WHERE `entry` IN (59088, 59089, 58388, 56374);
 INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES
-(59088,	0x00,	4,	0x00000000,	0x00000002,	0x00000000,	0x00004000,	0x00000000,	0,	0,	0), -- Improved Spell Reflection
-(59089,	0x00,	4,	0x00000000,	0x00000002,	0x00000000,	0x00004000,	0x00000000,	0,	0,	0), -- Improved Spell Reflection
-(56374,	0x00,	3,	0x00000000,	0x00004000,	0x00000000,	0x00004000,	0x00000000,	0,	0,	0); -- Glyph of icy veins
+(59088, 0x00, 4, 0x00000000, 0x00000002, 0x00000000, 0x00004000, 0x00000000, 0, 0, 0), -- Improved Spell Reflection
+(59089, 0x00, 4, 0x00000000, 0x00000002, 0x00000000, 0x00004000, 0x00000000, 0, 0, 0), -- Improved Spell Reflection
+(56374, 0x00, 3, 0x00000000, 0x00004000, 0x00000000, 0x00004000, 0x00000000, 0, 0, 0); -- Glyph of icy veins
diff --git a/sql/old/3.1.3/03943_world_spell_proc_event.sql b/sql/old/3.1.3/03943_world_spell_proc_event.sql
index 7d4c96caefe..7c49aee9e22 100644
--- a/sql/old/3.1.3/03943_world_spell_proc_event.sql
+++ b/sql/old/3.1.3/03943_world_spell_proc_event.sql
@@ -1,6 +1,6 @@
 DELETE FROM `spell_proc_event` WHERE `entry` IN (52610);
 INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES
-(52610,	0x00,	7,	0x80000000,	0x00000000,	0x00000000,	0x00004000,	0x00000000,	0,	0,	0); -- Savage roar
+(52610, 0x00, 7, 0x80000000, 0x00000000, 0x00000000, 0x00004000, 0x00000000, 0, 0, 0); -- Savage roar
 
 DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (52610, -52610);
 INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES
diff --git a/sql/old/3.1.3/03947_world_spell_proc_event.sql b/sql/old/3.1.3/03947_world_spell_proc_event.sql
index 6859fc95049..e2aa900ecb6 100644
--- a/sql/old/3.1.3/03947_world_spell_proc_event.sql
+++ b/sql/old/3.1.3/03947_world_spell_proc_event.sql
@@ -1,3 +1,3 @@
 DELETE FROM `spell_proc_event` WHERE `entry` IN (53397);
 INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES
-(53397,	0x00,	0,	0x00000000,	0x00000000,	0x00000000,	0x00000000,	0x00000002,	0,	0,	0); -- Invigoration
+(53397, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0, 0, 0); -- Invigoration
diff --git a/sql/old/3.1.3/03951_world_spell_proc_event.sql b/sql/old/3.1.3/03951_world_spell_proc_event.sql
index ec0d9d960d7..bc0be3eb9d5 100644
--- a/sql/old/3.1.3/03951_world_spell_proc_event.sql
+++ b/sql/old/3.1.3/03951_world_spell_proc_event.sql
@@ -1,3 +1,3 @@
 DELETE FROM `spell_proc_event` WHERE `entry` IN (53646);
 INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES
-(53646,	0x00,	0,	0x00000000,	0x00000000,	0x00000000,	0x00000000,	0x00000002,	0,	0,	0); -- Demonic Pact
+(53646, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0, 0, 0); -- Demonic Pact
diff --git a/sql/old/3.1.3/03969_world_spell_proc_event.sql b/sql/old/3.1.3/03969_world_spell_proc_event.sql
index bca25a6ebe0..e79367c5039 100644
--- a/sql/old/3.1.3/03969_world_spell_proc_event.sql
+++ b/sql/old/3.1.3/03969_world_spell_proc_event.sql
@@ -1,10 +1,10 @@
 DELETE FROM `spell_proc_event` WHERE `entry` IN (35553, 35552, 35551, 35550, 35541);
 INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES
-(35553,	0x00,	0,	0x00000000,	0x00000000,	0x00000000,	0x00800000,	0x00000000,	0,	0,	0), -- Combat Potency
-(35552,	0x00,	0,	0x00000000,	0x00000000,	0x00000000,	0x00800000,	0x00000000,	0,	0,	0), -- Combat Potency
-(35551,	0x00,	0,	0x00000000,	0x00000000,	0x00000000,	0x00800000,	0x00000000,	0,	0,	0), -- Combat Potency
-(35550,	0x00,	0,	0x00000000,	0x00000000,	0x00000000,	0x00800000,	0x00000000,	0,	0,	0), -- Combat Potency
-(35541,	0x00,	0,	0x00000000,	0x00000000,	0x00000000,	0x00800000,	0x00000000,	0,	0,	0); -- Combat Potency
+(35553, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00800000, 0x00000000, 0, 0, 0), -- Combat Potency
+(35552, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00800000, 0x00000000, 0, 0, 0), -- Combat Potency
+(35551, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00800000, 0x00000000, 0, 0, 0), -- Combat Potency
+(35550, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00800000, 0x00000000, 0, 0, 0), -- Combat Potency
+(35541, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00800000, 0x00000000, 0, 0, 0); -- Combat Potency
 
 DELETE FROM `spell_proc_event` WHERE `entry` IN (20375, 50781, 51414, 54695, 54838, 54841, 55747, 57352, 58442, 58444, 58901, 59345, 60061, 60063, 60066, 60221, 60301, 60306, 60317, 60436, 60473, 60482, 60487, 60490, 60519, 60537, 38347, 34320, 33297, 38299, 59630, 61356);
 INSERT INTO `spell_proc_event`(`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`)  VALUES
diff --git a/sql/old/3.1.3/05177_characters.sql b/sql/old/3.1.3/05177_characters.sql
index 6b8f85ac527..0e36a2c1841 100644
--- a/sql/old/3.1.3/05177_characters.sql
+++ b/sql/old/3.1.3/05177_characters.sql
@@ -1,8 +1,8 @@
 ALTER TABLE `auctionhousebot`
-	  CHANGE COLUMN `maxstackgrey`  `maxstackgrey` int(11) default '0' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.',
-	  CHANGE COLUMN `maxstackwhite`  `maxstackwhite` int(11) default '0' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.',
-	  CHANGE COLUMN `maxstackgreen`  `maxstackgreen` int(11) default '0' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.',
-	  CHANGE COLUMN `maxstackblue`  `maxstackblue` int(11) default '0' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.',
-	  CHANGE COLUMN `maxstackpurple`  `maxstackpurple` int(11) default '0' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.',
-	  CHANGE COLUMN `maxstackorange`  `maxstackorange` int(11) default '0' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.',
-	  CHANGE COLUMN `maxstackyellow`  `maxstackyellow` int(11) default '0' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.';
+    CHANGE COLUMN `maxstackgrey`  `maxstackgrey` int(11) default '0' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.',
+    CHANGE COLUMN `maxstackwhite`  `maxstackwhite` int(11) default '0' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.',
+    CHANGE COLUMN `maxstackgreen`  `maxstackgreen` int(11) default '0' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.',
+    CHANGE COLUMN `maxstackblue`  `maxstackblue` int(11) default '0' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.',
+    CHANGE COLUMN `maxstackpurple`  `maxstackpurple` int(11) default '0' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.',
+    CHANGE COLUMN `maxstackorange`  `maxstackorange` int(11) default '0' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.',
+    CHANGE COLUMN `maxstackyellow`  `maxstackyellow` int(11) default '0' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.';
diff --git a/sql/old/3.1.3/05410_world_spell_dbc.sql b/sql/old/3.1.3/05410_world_spell_dbc.sql
index 31f648dcad4..5c5d34d4f1e 100644
--- a/sql/old/3.1.3/05410_world_spell_dbc.sql
+++ b/sql/old/3.1.3/05410_world_spell_dbc.sql
@@ -1,101 +1,101 @@
 DROP TABLE IF EXISTS `spell_dbc`;
 CREATE TABLE `spell_dbc` (
-	`Id` INT UNSIGNED NOT NULL,
-	`Dispel` TINYINT UNSIGNED NOT NULL DEFAULT 0,
-	`Mechanic` TINYINT UNSIGNED NOT NULL DEFAULT 0,
-	`Attributes` INT UNSIGNED NOT NULL DEFAULT 0,
-	`AttributesEx` INT UNSIGNED NOT NULL DEFAULT 0,
-	`AttributesEx2` INT UNSIGNED NOT NULL DEFAULT 0,
-	`AttributesEx3` INT UNSIGNED NOT NULL DEFAULT 0,
-	`AttributesEx4` INT UNSIGNED NOT NULL DEFAULT 0,
-	`AttributesEx5` INT UNSIGNED NOT NULL DEFAULT 0,
-	`Targets` INT UNSIGNED NOT NULL DEFAULT 0,
-	`CastingTimeIndex` TINYINT UNSIGNED NOT NULL DEFAULT 1,
-	`AuraInterruptFlags` INT UNSIGNED NOT NULL DEFAULT 0,
-	`ProcFlags` INT UNSIGNED NOT NULL DEFAULT 0,
-	`ProcChance` TINYINT UNSIGNED NOT NULL DEFAULT 0,
-	`ProcCharges` TINYINT UNSIGNED NOT NULL DEFAULT 0,
-	`MaxLevel` TINYINT UNSIGNED NOT NULL DEFAULT 0,
-	`BaseLevel` TINYINT UNSIGNED NOT NULL DEFAULT 0,
-	`SpellLevel` TINYINT UNSIGNED NOT NULL DEFAULT 0,
-	`DurationIndex` SMALLINT UNSIGNED NOT NULL DEFAULT 0,
-	`RangeIndex` TINYINT UNSIGNED NOT NULL DEFAULT 1,
-	`StackAmount` TINYINT UNSIGNED NOT NULL DEFAULT 0,
-	`EquippedItemClass` INT NOT NULL DEFAULT -1,
-	`EquippedItemSubClassMask` INT NOT NULL DEFAULT 0 DEFAULT 0,
-	`EquippedItemInventoryTypeMask` INT NOT NULL DEFAULT 0 DEFAULT 0,
-	`Effect1` TINYINT UNSIGNED NOT NULL DEFAULT 0,
-	`Effect2` TINYINT UNSIGNED NOT NULL DEFAULT 0,
-	`Effect3` TINYINT UNSIGNED NOT NULL DEFAULT 0,
-	`EffectDieSides1` INT NOT NULL DEFAULT 0,
-	`EffectDieSides2` INT NOT NULL DEFAULT 0,
-	`EffectDieSides3` INT NOT NULL DEFAULT 0,
-	`EffectBaseDice1` INT NOT NULL DEFAULT 0,
-	`EffectBaseDice2` INT NOT NULL DEFAULT 0,
-	`EffectBaseDice3` INT NOT NULL DEFAULT 0,
-	`EffectDicePerLevel1` FLOAT NOT NULL DEFAULT 0,
-	`EffectDicePerLevel2` FLOAT NOT NULL DEFAULT 0,
-	`EffectDicePerLevel3` FLOAT NOT NULL DEFAULT 0,
-	`EffectRealPointsPerLevel1` FLOAT NOT NULL DEFAULT 0,
-	`EffectRealPointsPerLevel2` FLOAT NOT NULL DEFAULT 0,
-	`EffectRealPointsPerLevel3` FLOAT NOT NULL DEFAULT 0,
-	`EffectBasePoints1` INT NOT NULL DEFAULT 0,
-	`EffectBasePoints2` INT NOT NULL DEFAULT 0,
-	`EffectBasePoints3` INT NOT NULL DEFAULT 0,
-	`EffectMechanic1` TINYINT UNSIGNED NOT NULL DEFAULT 0,
-	`EffectMechanic2` TINYINT UNSIGNED NOT NULL DEFAULT 0,
-	`EffectMechanic3` TINYINT UNSIGNED NOT NULL DEFAULT 0,
-	`EffectImplicitTargetA1` TINYINT UNSIGNED NOT NULL DEFAULT 0,
-	`EffectImplicitTargetA2` TINYINT UNSIGNED NOT NULL DEFAULT 0,
-	`EffectImplicitTargetA3` TINYINT UNSIGNED NOT NULL DEFAULT 0,
-	`EffectImplicitTargetB1` TINYINT UNSIGNED NOT NULL DEFAULT 0,
-	`EffectImplicitTargetB2` TINYINT UNSIGNED NOT NULL DEFAULT 0,
-	`EffectImplicitTargetB3` TINYINT UNSIGNED NOT NULL DEFAULT 0,
-	`EffectRadiusIndex1` TINYINT UNSIGNED NOT NULL DEFAULT 0,
-	`EffectRadiusIndex2` TINYINT UNSIGNED NOT NULL DEFAULT 0,
-	`EffectRadiusIndex3` TINYINT UNSIGNED NOT NULL DEFAULT 0,
-	`EffectApplyAuraName1` SMALLINT UNSIGNED NOT NULL DEFAULT 0,
-	`EffectApplyAuraName2` SMALLINT UNSIGNED NOT NULL DEFAULT 0,
-	`EffectApplyAuraName3` SMALLINT UNSIGNED NOT NULL DEFAULT 0,
-	`EffectAmplitude1` INT NOT NULL DEFAULT 0,
-	`EffectAmplitude2` INT NOT NULL DEFAULT 0,
-	`EffectAmplitude3` INT NOT NULL DEFAULT 0,
-	`EffectMultipleValue1` FLOAT NOT NULL DEFAULT 0,
-	`EffectMultipleValue2` FLOAT NOT NULL DEFAULT 0,
-	`EffectMultipleValue3` FLOAT NOT NULL DEFAULT 0,
-	`EffectMiscValue1` INT NOT NULL DEFAULT 0,
-	`EffectMiscValue2` INT NOT NULL DEFAULT 0,
-	`EffectMiscValue3` INT NOT NULL DEFAULT 0,
-	`EffectMiscValueB1` INT NOT NULL DEFAULT 0,
-	`EffectMiscValueB2` INT NOT NULL DEFAULT 0,
-	`EffectMiscValueB3` INT NOT NULL DEFAULT 0,
-	`EffectTriggerSpell1` INT UNSIGNED NOT NULL DEFAULT 0,
-	`EffectTriggerSpell2` INT UNSIGNED NOT NULL DEFAULT 0,
-	`EffectTriggerSpell3` INT UNSIGNED NOT NULL DEFAULT 0,
-	`EffectSpellClassMaskA1` INT UNSIGNED NOT NULL DEFAULT 0,
-	`EffectSpellClassMaskA2` INT UNSIGNED NOT NULL DEFAULT 0,
-	`EffectSpellClassMaskA3` INT UNSIGNED NOT NULL DEFAULT 0,
-	`EffectSpellClassMaskB1` INT UNSIGNED NOT NULL DEFAULT 0,
-	`EffectSpellClassMaskB2` INT UNSIGNED NOT NULL DEFAULT 0,
-	`EffectSpellClassMaskB3` INT UNSIGNED NOT NULL DEFAULT 0,
-	`EffectSpellClassMaskC1` INT UNSIGNED NOT NULL DEFAULT 0,
-	`EffectSpellClassMaskC2` INT UNSIGNED NOT NULL DEFAULT 0,
-	`EffectSpellClassMaskC3` INT UNSIGNED NOT NULL DEFAULT 0,
-	`MaxTargetLevel` TINYINT UNSIGNED NOT NULL DEFAULT 0,
-	`SpellFamilyName` TINYINT UNSIGNED NOT NULL DEFAULT 0,
-	`SpellFamilyFlags1` INT UNSIGNED NOT NULL DEFAULT 0,
-	`SpellFamilyFlags2` INT UNSIGNED NOT NULL DEFAULT 0,
-	`SpellFamilyFlags3` INT UNSIGNED NOT NULL DEFAULT 0,
-	`MaxAffectedTargets` TINYINT UNSIGNED NOT NULL DEFAULT 0,
-	`DmgClass` TINYINT UNSIGNED NOT NULL DEFAULT 0,
-	`PreventionType` TINYINT UNSIGNED NOT NULL DEFAULT 0,
-	`DmgMultiplier1` FLOAT NOT NULL DEFAULT 0,
-	`DmgMultiplier2` FLOAT NOT NULL DEFAULT 0,
-	`DmgMultiplier3` FLOAT NOT NULL DEFAULT 0,
-	`AreaGroupId` INT NOT NULL DEFAULT 0,
-	`SchoolMask` INT UNSIGNED NOT NULL DEFAULT 0,
-	`Comment` TEXT NOT NULL,
-	PRIMARY KEY (`id`)
+    `Id` INT UNSIGNED NOT NULL,
+    `Dispel` TINYINT UNSIGNED NOT NULL DEFAULT 0,
+    `Mechanic` TINYINT UNSIGNED NOT NULL DEFAULT 0,
+    `Attributes` INT UNSIGNED NOT NULL DEFAULT 0,
+    `AttributesEx` INT UNSIGNED NOT NULL DEFAULT 0,
+    `AttributesEx2` INT UNSIGNED NOT NULL DEFAULT 0,
+    `AttributesEx3` INT UNSIGNED NOT NULL DEFAULT 0,
+    `AttributesEx4` INT UNSIGNED NOT NULL DEFAULT 0,
+    `AttributesEx5` INT UNSIGNED NOT NULL DEFAULT 0,
+    `Targets` INT UNSIGNED NOT NULL DEFAULT 0,
+    `CastingTimeIndex` TINYINT UNSIGNED NOT NULL DEFAULT 1,
+    `AuraInterruptFlags` INT UNSIGNED NOT NULL DEFAULT 0,
+    `ProcFlags` INT UNSIGNED NOT NULL DEFAULT 0,
+    `ProcChance` TINYINT UNSIGNED NOT NULL DEFAULT 0,
+    `ProcCharges` TINYINT UNSIGNED NOT NULL DEFAULT 0,
+    `MaxLevel` TINYINT UNSIGNED NOT NULL DEFAULT 0,
+    `BaseLevel` TINYINT UNSIGNED NOT NULL DEFAULT 0,
+    `SpellLevel` TINYINT UNSIGNED NOT NULL DEFAULT 0,
+    `DurationIndex` SMALLINT UNSIGNED NOT NULL DEFAULT 0,
+    `RangeIndex` TINYINT UNSIGNED NOT NULL DEFAULT 1,
+    `StackAmount` TINYINT UNSIGNED NOT NULL DEFAULT 0,
+    `EquippedItemClass` INT NOT NULL DEFAULT -1,
+    `EquippedItemSubClassMask` INT NOT NULL DEFAULT 0 DEFAULT 0,
+    `EquippedItemInventoryTypeMask` INT NOT NULL DEFAULT 0 DEFAULT 0,
+    `Effect1` TINYINT UNSIGNED NOT NULL DEFAULT 0,
+    `Effect2` TINYINT UNSIGNED NOT NULL DEFAULT 0,
+    `Effect3` TINYINT UNSIGNED NOT NULL DEFAULT 0,
+    `EffectDieSides1` INT NOT NULL DEFAULT 0,
+    `EffectDieSides2` INT NOT NULL DEFAULT 0,
+    `EffectDieSides3` INT NOT NULL DEFAULT 0,
+    `EffectBaseDice1` INT NOT NULL DEFAULT 0,
+    `EffectBaseDice2` INT NOT NULL DEFAULT 0,
+    `EffectBaseDice3` INT NOT NULL DEFAULT 0,
+    `EffectDicePerLevel1` FLOAT NOT NULL DEFAULT 0,
+    `EffectDicePerLevel2` FLOAT NOT NULL DEFAULT 0,
+    `EffectDicePerLevel3` FLOAT NOT NULL DEFAULT 0,
+    `EffectRealPointsPerLevel1` FLOAT NOT NULL DEFAULT 0,
+    `EffectRealPointsPerLevel2` FLOAT NOT NULL DEFAULT 0,
+    `EffectRealPointsPerLevel3` FLOAT NOT NULL DEFAULT 0,
+    `EffectBasePoints1` INT NOT NULL DEFAULT 0,
+    `EffectBasePoints2` INT NOT NULL DEFAULT 0,
+    `EffectBasePoints3` INT NOT NULL DEFAULT 0,
+    `EffectMechanic1` TINYINT UNSIGNED NOT NULL DEFAULT 0,
+    `EffectMechanic2` TINYINT UNSIGNED NOT NULL DEFAULT 0,
+    `EffectMechanic3` TINYINT UNSIGNED NOT NULL DEFAULT 0,
+    `EffectImplicitTargetA1` TINYINT UNSIGNED NOT NULL DEFAULT 0,
+    `EffectImplicitTargetA2` TINYINT UNSIGNED NOT NULL DEFAULT 0,
+    `EffectImplicitTargetA3` TINYINT UNSIGNED NOT NULL DEFAULT 0,
+    `EffectImplicitTargetB1` TINYINT UNSIGNED NOT NULL DEFAULT 0,
+    `EffectImplicitTargetB2` TINYINT UNSIGNED NOT NULL DEFAULT 0,
+    `EffectImplicitTargetB3` TINYINT UNSIGNED NOT NULL DEFAULT 0,
+    `EffectRadiusIndex1` TINYINT UNSIGNED NOT NULL DEFAULT 0,
+    `EffectRadiusIndex2` TINYINT UNSIGNED NOT NULL DEFAULT 0,
+    `EffectRadiusIndex3` TINYINT UNSIGNED NOT NULL DEFAULT 0,
+    `EffectApplyAuraName1` SMALLINT UNSIGNED NOT NULL DEFAULT 0,
+    `EffectApplyAuraName2` SMALLINT UNSIGNED NOT NULL DEFAULT 0,
+    `EffectApplyAuraName3` SMALLINT UNSIGNED NOT NULL DEFAULT 0,
+    `EffectAmplitude1` INT NOT NULL DEFAULT 0,
+    `EffectAmplitude2` INT NOT NULL DEFAULT 0,
+    `EffectAmplitude3` INT NOT NULL DEFAULT 0,
+    `EffectMultipleValue1` FLOAT NOT NULL DEFAULT 0,
+    `EffectMultipleValue2` FLOAT NOT NULL DEFAULT 0,
+    `EffectMultipleValue3` FLOAT NOT NULL DEFAULT 0,
+    `EffectMiscValue1` INT NOT NULL DEFAULT 0,
+    `EffectMiscValue2` INT NOT NULL DEFAULT 0,
+    `EffectMiscValue3` INT NOT NULL DEFAULT 0,
+    `EffectMiscValueB1` INT NOT NULL DEFAULT 0,
+    `EffectMiscValueB2` INT NOT NULL DEFAULT 0,
+    `EffectMiscValueB3` INT NOT NULL DEFAULT 0,
+    `EffectTriggerSpell1` INT UNSIGNED NOT NULL DEFAULT 0,
+    `EffectTriggerSpell2` INT UNSIGNED NOT NULL DEFAULT 0,
+    `EffectTriggerSpell3` INT UNSIGNED NOT NULL DEFAULT 0,
+    `EffectSpellClassMaskA1` INT UNSIGNED NOT NULL DEFAULT 0,
+    `EffectSpellClassMaskA2` INT UNSIGNED NOT NULL DEFAULT 0,
+    `EffectSpellClassMaskA3` INT UNSIGNED NOT NULL DEFAULT 0,
+    `EffectSpellClassMaskB1` INT UNSIGNED NOT NULL DEFAULT 0,
+    `EffectSpellClassMaskB2` INT UNSIGNED NOT NULL DEFAULT 0,
+    `EffectSpellClassMaskB3` INT UNSIGNED NOT NULL DEFAULT 0,
+    `EffectSpellClassMaskC1` INT UNSIGNED NOT NULL DEFAULT 0,
+    `EffectSpellClassMaskC2` INT UNSIGNED NOT NULL DEFAULT 0,
+    `EffectSpellClassMaskC3` INT UNSIGNED NOT NULL DEFAULT 0,
+    `MaxTargetLevel` TINYINT UNSIGNED NOT NULL DEFAULT 0,
+    `SpellFamilyName` TINYINT UNSIGNED NOT NULL DEFAULT 0,
+    `SpellFamilyFlags1` INT UNSIGNED NOT NULL DEFAULT 0,
+    `SpellFamilyFlags2` INT UNSIGNED NOT NULL DEFAULT 0,
+    `SpellFamilyFlags3` INT UNSIGNED NOT NULL DEFAULT 0,
+    `MaxAffectedTargets` TINYINT UNSIGNED NOT NULL DEFAULT 0,
+    `DmgClass` TINYINT UNSIGNED NOT NULL DEFAULT 0,
+    `PreventionType` TINYINT UNSIGNED NOT NULL DEFAULT 0,
+    `DmgMultiplier1` FLOAT NOT NULL DEFAULT 0,
+    `DmgMultiplier2` FLOAT NOT NULL DEFAULT 0,
+    `DmgMultiplier3` FLOAT NOT NULL DEFAULT 0,
+    `AreaGroupId` INT NOT NULL DEFAULT 0,
+    `SchoolMask` INT UNSIGNED NOT NULL DEFAULT 0,
+    `Comment` TEXT NOT NULL,
+    PRIMARY KEY (`id`)
 )ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Custom spell.dbc entries';
 
 INSERT INTO `spell_dbc` (`Id`, `DurationIndex`, `Effect1`, `EffectImplicitTargetA1`, `EffectApplyAuraName1`, `Comment`) VALUES (62388, 21, 6, 1, 4, 'Demonic Circle: Teleport(48020) - casterAuraSpell');
diff --git a/sql/old/3.2.2a/06932_characters_character_aura.sql b/sql/old/3.2.2a/06932_characters_character_aura.sql
index 9cf36f0143c..0629d89ffa8 100644
--- a/sql/old/3.2.2a/06932_characters_character_aura.sql
+++ b/sql/old/3.2.2a/06932_characters_character_aura.sql
@@ -1,5 +1,5 @@
 ALTER TABLE `character_aura` 
-	ADD COLUMN `base_amount0` INT(11) NOT NULL DEFAULT '0' AFTER `amount2`,
-	ADD COLUMN `base_amount1` INT(11) NOT NULL DEFAULT '0' AFTER `base_amount0`,
-	ADD COLUMN `base_amount2` INT(11) NOT NULL DEFAULT '0' AFTER `base_amount1`,
-	ADD COLUMN `recalculate_mask` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `effect_mask`;
+    ADD COLUMN `base_amount0` INT(11) NOT NULL DEFAULT '0' AFTER `amount2`,
+    ADD COLUMN `base_amount1` INT(11) NOT NULL DEFAULT '0' AFTER `base_amount0`,
+    ADD COLUMN `base_amount2` INT(11) NOT NULL DEFAULT '0' AFTER `base_amount1`,
+    ADD COLUMN `recalculate_mask` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `effect_mask`;
diff --git a/sql/old/3.2.2a/06932_characters_pet_aura.sql b/sql/old/3.2.2a/06932_characters_pet_aura.sql
index fe386e7a85b..90df4e858c9 100644
--- a/sql/old/3.2.2a/06932_characters_pet_aura.sql
+++ b/sql/old/3.2.2a/06932_characters_pet_aura.sql
@@ -1,5 +1,5 @@
 ALTER TABLE `pet_aura` DROP PRIMARY KEY,
-	ADD COLUMN `base_amount0` INT(11) NOT NULL DEFAULT '0' AFTER `amount2`,
-	ADD COLUMN `base_amount1` INT(11) NOT NULL DEFAULT '0' AFTER `base_amount0`,
-	ADD COLUMN `base_amount2` INT(11) NOT NULL DEFAULT '0' AFTER `base_amount1`,
-	ADD COLUMN `recalculate_mask` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `effect_mask`;
+    ADD COLUMN `base_amount0` INT(11) NOT NULL DEFAULT '0' AFTER `amount2`,
+    ADD COLUMN `base_amount1` INT(11) NOT NULL DEFAULT '0' AFTER `base_amount0`,
+    ADD COLUMN `base_amount2` INT(11) NOT NULL DEFAULT '0' AFTER `base_amount1`,
+    ADD COLUMN `recalculate_mask` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `effect_mask`;
diff --git a/sql/old/3.3.2/07332_characters_characters.sql b/sql/old/3.3.2/07332_characters_characters.sql
index 6db1a7d0946..8c21a623b8a 100644
--- a/sql/old/3.3.2/07332_characters_characters.sql
+++ b/sql/old/3.3.2/07332_characters_characters.sql
@@ -1,60 +1,60 @@
 UPDATE characters SET data = REPLACE(data,'  ',' ');
 UPDATE characters SET data = CONCAT(TRIM(data),' ');
 UPDATE `characters` SET `data` = CONCAT(
-	SUBSTRING_INDEX(`data`, ' ', 161 + 1), ' ',
-	'0 ',
-	SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 1), ' ', -165 + 162 - 1), ' ',
-	'0 ',
-	SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4 + 1), ' ', -165 - 4 + 162 + 4 - 1), ' ',
-	'0 ',
-	SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*2 + 1), ' ', -165 - 4*2 + 162 + 4*2 - 1), ' ',
-	'0 ',
-	SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*3 + 1), ' ', -165 - 4*3 + 162 + 4*3 - 1), ' ',
-	'0 ',
-	SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*4 + 1), ' ', -165 - 4*4 + 162 + 4*4 - 1), ' ',
-	'0 ',
-	SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*5 + 1), ' ', -165 - 4*5 + 162 + 4*5 - 1), ' ',
-	'0 ',
-	SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*6 + 1), ' ', -165 - 4*6 + 162 + 4*6 - 1), ' ',
-	'0 ',
-	SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*7 + 1), ' ', -165 - 4*7 + 162 + 4*7 - 1), ' ',
-	'0 ',
-	SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*8 + 1), ' ', -165 - 4*8 + 162 + 4*8 - 1), ' ',
-	'0 ',
-	SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*9 + 1), ' ', -165 - 4*9 + 162 + 4*9 - 1), ' ',
-	'0 ',
-	SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*10 + 1), ' ', -165 - 4*10 + 162 + 4*10 - 1), ' ',
-	'0 ',
-	SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*11 + 1), ' ', -165 - 4*11 + 162 + 4*11 - 1), ' ',
-	'0 ',
-	SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*12 + 1), ' ', -165 - 4*12 + 162 + 4*12 - 1), ' ',
-	'0 ',
-	SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*13 + 1), ' ', -165 - 4*13 + 162 + 4*13 - 1), ' ',
-	'0 ',
-	SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*14 + 1), ' ', -165 - 4*14 + 162 + 4*14 - 1), ' ',
-	'0 ',
-	SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*15 + 1), ' ', -165 - 4*15 + 162 + 4*15 - 1), ' ',
-	'0 ',
-	SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*16 + 1), ' ', -165 - 4*16 + 162 + 4*16 - 1), ' ',
-	'0 ',
-	SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*17 + 1), ' ', -165 - 4*17 + 162 + 4*17 - 1), ' ',
-	'0 ',
-	SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*18 + 1), ' ', -165 - 4*18 + 162 + 4*18 - 1), ' ',
-	'0 ',
-	SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*19 + 1), ' ', -165 - 4*19 + 162 + 4*19 - 1), ' ',
-	'0 ',
-	SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*20 + 1), ' ', -165 - 4*20 + 162 + 4*20 - 1), ' ',
-	'0 ',
-	SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*21 + 1), ' ', -165 - 4*21 + 162 + 4*21 - 1), ' ',
-	'0 ',
-	SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*22 + 1), ' ', -165 - 4*22 + 162 + 4*22 - 1), ' ',
-	'0 ',
-	SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*23 + 1), ' ', -165 - 4*23 + 162 + 4*23 - 1), ' ',
-	'0 ',
-	SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 298 + 1), ' ', -298 + 162 + 4*24 - 1), ' ',
-	'0 ',
-	SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1300 + 1), ' ', -1300 + 299 - 1), ' '	
-	)
+    SUBSTRING_INDEX(`data`, ' ', 161 + 1), ' ',
+    '0 ',
+    SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 1), ' ', -165 + 162 - 1), ' ',
+    '0 ',
+    SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4 + 1), ' ', -165 - 4 + 162 + 4 - 1), ' ',
+    '0 ',
+    SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*2 + 1), ' ', -165 - 4*2 + 162 + 4*2 - 1), ' ',
+    '0 ',
+    SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*3 + 1), ' ', -165 - 4*3 + 162 + 4*3 - 1), ' ',
+    '0 ',
+    SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*4 + 1), ' ', -165 - 4*4 + 162 + 4*4 - 1), ' ',
+    '0 ',
+    SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*5 + 1), ' ', -165 - 4*5 + 162 + 4*5 - 1), ' ',
+    '0 ',
+    SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*6 + 1), ' ', -165 - 4*6 + 162 + 4*6 - 1), ' ',
+    '0 ',
+    SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*7 + 1), ' ', -165 - 4*7 + 162 + 4*7 - 1), ' ',
+    '0 ',
+    SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*8 + 1), ' ', -165 - 4*8 + 162 + 4*8 - 1), ' ',
+    '0 ',
+    SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*9 + 1), ' ', -165 - 4*9 + 162 + 4*9 - 1), ' ',
+    '0 ',
+    SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*10 + 1), ' ', -165 - 4*10 + 162 + 4*10 - 1), ' ',
+    '0 ',
+    SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*11 + 1), ' ', -165 - 4*11 + 162 + 4*11 - 1), ' ',
+    '0 ',
+    SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*12 + 1), ' ', -165 - 4*12 + 162 + 4*12 - 1), ' ',
+    '0 ',
+    SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*13 + 1), ' ', -165 - 4*13 + 162 + 4*13 - 1), ' ',
+    '0 ',
+    SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*14 + 1), ' ', -165 - 4*14 + 162 + 4*14 - 1), ' ',
+    '0 ',
+    SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*15 + 1), ' ', -165 - 4*15 + 162 + 4*15 - 1), ' ',
+    '0 ',
+    SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*16 + 1), ' ', -165 - 4*16 + 162 + 4*16 - 1), ' ',
+    '0 ',
+    SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*17 + 1), ' ', -165 - 4*17 + 162 + 4*17 - 1), ' ',
+    '0 ',
+    SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*18 + 1), ' ', -165 - 4*18 + 162 + 4*18 - 1), ' ',
+    '0 ',
+    SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*19 + 1), ' ', -165 - 4*19 + 162 + 4*19 - 1), ' ',
+    '0 ',
+    SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*20 + 1), ' ', -165 - 4*20 + 162 + 4*20 - 1), ' ',
+    '0 ',
+    SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*21 + 1), ' ', -165 - 4*21 + 162 + 4*21 - 1), ' ',
+    '0 ',
+    SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*22 + 1), ' ', -165 - 4*22 + 162 + 4*22 - 1), ' ',
+    '0 ',
+    SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 165 + 4*23 + 1), ' ', -165 - 4*23 + 162 + 4*23 - 1), ' ',
+    '0 ',
+    SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 298 + 1), ' ', -298 + 162 + 4*24 - 1), ' ',
+    '0 ',
+    SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1300 + 1), ' ', -1300 + 299 - 1), ' '
+    )
 WHERE length(SUBSTRING_INDEX(data, ' ', 1300)) < length(data) and length(SUBSTRING_INDEX(data, ' ', 1300+1)) >= length(data);
 UPDATE characters SET data = REPLACE(data,'  ',' ');
 UPDATE characters SET data = CONCAT(TRIM(data),' ');
diff --git a/sql/old/3.3.3a/07893_characters_item_instance.sql b/sql/old/3.3.3a/07893_characters_item_instance.sql
index 3dea7f98e27..9eeef845f40 100644
--- a/sql/old/3.3.3a/07893_characters_item_instance.sql
+++ b/sql/old/3.3.3a/07893_characters_item_instance.sql
@@ -2,8 +2,8 @@ UPDATE item_instance SET data = REPLACE(data,'  ',' ');
 UPDATE item_instance SET data = CONCAT(TRIM(data),' ');
 
 UPDATE `item_instance` SET `data` = CONCAT(
-	SUBSTRING_INDEX(`data`, ' ', 59 + 1), ' ',
-	SUBSTRING_INDEX(`data`, ' ', -3 -1), '0 ')
+    SUBSTRING_INDEX(`data`, ' ', 59 + 1), ' ',
+    SUBSTRING_INDEX(`data`, ' ', -3 -1), '0 ')
 WHERE length(SUBSTRING_INDEX(data, ' ', 64)) < length(data) and length(SUBSTRING_INDEX(data, ' ', 64+1)) >= length(data);
 
 UPDATE item_instance SET data = REPLACE(data,'  ',' ');
diff --git a/sql/old/3.3.3a/07923_characters_characters.sql b/sql/old/3.3.3a/07923_characters_characters.sql
index a9fe4880731..b871727a490 100644
--- a/sql/old/3.3.3a/07923_characters_characters.sql
+++ b/sql/old/3.3.3a/07923_characters_characters.sql
@@ -1,2 +1 @@
-ALTER TABLE characters
- 	  ADD COLUMN `actionBars` tinyint(3) UNSIGNED NOT NULL default '0' AFTER knownTitles;
+ALTER TABLE `characters` ADD COLUMN `actionBars` tinyint(3) UNSIGNED NOT NULL default '0' AFTER `knownTitles`;
diff --git a/sql/old/3.3.5a/09560_world_spell_proc_event.sql b/sql/old/3.3.5a/09560_world_spell_proc_event.sql
index 07779e9e50d..cc9ca570d4f 100644
--- a/sql/old/3.3.5a/09560_world_spell_proc_event.sql
+++ b/sql/old/3.3.5a/09560_world_spell_proc_event.sql
@@ -1,3 +1,3 @@
 DELETE FROM `spell_proc_event` WHERE `entry`=70854;
 INSERT INTO `spell_proc_event` VALUES 
-( 70854, 0x00,   4, 0x00000000, 0x00000010, 0x00000000, 0x00000000, 0x00000000,   0,   0,   0); -- 	Item - Warrior T10 Melee 2P Bonus
\ No newline at end of file
+(70854, 0x00, 4, 0x00000000, 0x00000010, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0); -- Item - Warrior T10 Melee 2P Bonus
diff --git a/sql/old/3.3.5a/09712_world_spell_threat.sql b/sql/old/3.3.5a/09712_world_spell_threat.sql
index b66444ee913..06c5892fb40 100644
--- a/sql/old/3.3.5a/09712_world_spell_threat.sql
+++ b/sql/old/3.3.5a/09712_world_spell_threat.sql
@@ -1,14 +1,14 @@
 -- Battle Shout
 DELETE FROM `spell_threat` WHERE `entry` IN (6673,5242,6192,11549,11550,11551,2048,47436);
 INSERT INTO `spell_threat`(`entry`,`Threat`) VALUES
-(6673,1), 	-- Rank 1
-(5242,12),	-- Rank 2
-(6192,22),	-- Rank 3
-(11549,32), 	-- Rank 4
-(11550,42), 	-- Rank 5
-(11551,52), 	-- Rank 6 , Rank 7 already in tdb
-(2048,69),	-- Rank 8
-(47436,78);	-- Rank 9
+(6673,1), -- Rank 1
+(5242,12), -- Rank 2
+(6192,22), -- Rank 3
+(11549,32), -- Rank 4
+(11550,42), -- Rank 5
+(11551,52), -- Rank 6 , Rank 7 already in tdb
+(2048,69), -- Rank 8
+(47436,78); -- Rank 9
 
 -- Cleave
 DELETE FROM `spell_threat` WHERE `entry` IN (47519,47520);
@@ -19,9 +19,9 @@ INSERT INTO `spell_threat`(`entry`,`Threat`) VALUES
 -- Commanding Shout
 DELETE FROM `spell_threat` WHERE `entry` IN (469,47439,47440);
 INSERT INTO `spell_threat`(`entry`,`Threat`) VALUES
-(469,68), 	-- Rank 1
-(47439,77), 	-- Rank 2
-(47440,80);	-- Rank 3
+(469,68), -- Rank 1
+(47439,77), -- Rank 2
+(47440,80); -- Rank 3
 
 -- Demoralizing Shout
 DELETE FROM `spell_threat` WHERE `entry` IN (25202,25203,47437);
diff --git a/sql/old/3.3.5a/2011_02_05_00_world_sai.sql b/sql/old/3.3.5a/2011_02_05_00_world_sai.sql
index f68f044e2f1..3a5291b6e94 100644
--- a/sql/old/3.3.5a/2011_02_05_00_world_sai.sql
+++ b/sql/old/3.3.5a/2011_02_05_00_world_sai.sql
@@ -82,7 +82,7 @@ INSERT INTO `creature_addon` (`guid`,`path_id`) VALUES
 (@GUID+0,(@GUID+0)*10),
 (@GUID+1,(@GUID+1)*10);
 DELETE FROM `waypoint_data`  WHERE `id` IN ((@GUID+0)*10,(@GUID+1)*10);
-INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`) VALUES	
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`) VALUES
 ((@GUID+0)*10,00,5865.73,561.7454,656.3502),
 ((@GUID+0)*10,01,5864.76,561.5035,656.3502),
 ((@GUID+0)*10,02,5865.858,545.6048,657.8221),
diff --git a/sql/old/3.3.5a/2011_03_12_00_world_creature_template.sql b/sql/old/3.3.5a/2011_03_12_00_world_creature_template.sql
index 4356a82443f..a2d3d5d44a0 100644
--- a/sql/old/3.3.5a/2011_03_12_00_world_creature_template.sql
+++ b/sql/old/3.3.5a/2011_03_12_00_world_creature_template.sql
@@ -1,23 +1,23 @@
 /*
-1 	0x0000 0001 	MECHANIC_CHARM 	
-2 	0x0000 0002 	MECHANIC_DISORIENTED 	
-16 	0x0000 0010 	MECHANIC_FEAR 	
-32 	0x0000 0020 	MECHANIC_GRIP 
-64 	0x0000 0040 	MECHANIC_ROOT 
-128 	0x0000 0080 	MECHANIC_PACIFY 	(0 spells use this mechanic)
-256 	0x0000 0100 	MECHANIC_SILENCE 
-512 	0x0000 0200 	MECHANIC_SLEEP 	
-1024 	0x0000 0400 	MECHANIC_SNARE 	
-2048 	0x0000 0800 	MECHANIC_STUN 	
-4096 	0x0000 1000 	MECHANIC_FREEZE 
-8192 	0x0000 2000 	MECHANIC_KNOCKOUT 
-65536 	0x0001 0000 	MECHANIC_POLYMORPH 	
-131072 	0x0002 0000 	MECHANIC_BANISH 
-524288 	0x0008 0000 	MECHANIC_SHACKLE 
-4194304 	0x0040 0000 	MECHANIC_TURN 
-8388608 	0x0080 0000 	MECHANIC_HORROR 
-67108864 	0x0400 0000 	MECHANIC_DAZE 
-536870912 	0x2000 0000 	MECHANIC_SAPPED 
+1         0x0000 0001 MECHANIC_CHARM
+2         0x0000 0002 MECHANIC_DISORIENTED
+16        0x0000 0010 MECHANIC_FEAR
+32        0x0000 0020 MECHANIC_GRIP
+64        0x0000 0040 MECHANIC_ROOT
+128       0x0000 0080 MECHANIC_PACIFY (0 spells use this mechanic)
+256       0x0000 0100 MECHANIC_SILENCE
+512       0x0000 0200 MECHANIC_SLEEP
+1024      0x0000 0400 MECHANIC_SNARE
+2048      0x0000 0800 MECHANIC_STUN
+4096      0x0000 1000 MECHANIC_FREEZE
+8192      0x0000 2000 MECHANIC_KNOCKOUT
+65536     0x0001 0000 MECHANIC_POLYMORPH
+131072    0x0002 0000 MECHANIC_BANISH
+524288    0x0008 0000 MECHANIC_SHACKLE
+4194304   0x0040 0000 MECHANIC_TURN
+8388608   0x0080 0000 MECHANIC_HORROR
+67108864  0x0400 0000 MECHANIC_DAZE
+536870912 0x2000 0000 MECHANIC_SAPPED
 */
 -- Update Frozen Halls Immunities
 UPDATE `creature_template` SET `mechanic_immune_mask`=`mechanic_immune_mask`|1|2|16|32|64|128|256|512|1024|2048|4096|8192|65536|131072|524288|4194304|8388608|67108864|536870912 WHERE `entry` IN (