* Used trinity sql coding style

--HG--
branch : trunk

6 files changed, 8 insertions, 11 deletions

diff --git a/sql/updates/3314_mangos_7823_01_world_item_template.sql b/sql/updates/3314_mangos_7823_01_world_item_template.sql
new file mode 100644
index 00000000000..4916a7b604c
--- /dev/null
+++ b/sql/updates/3314_mangos_7823_01_world_item_template.sql
@@ -0,0 +1,4 @@
+/*ALTER TABLE db_version CHANGE COLUMN required_7796_02_mangos_mangos_string required_7823_01_mangos_item_template bit;*/
+
+ALTER TABLE item_template
+CHANGE COLUMN ScalingStatValue ScalingStatValue int(6) unsigned NOT NULL default '0';
\ No newline at end of file
diff --git a/sql/updates/3320_worldspell_enchant_proc_data.sql b/sql/updates/3320_worldspell_enchant_proc_data.sql
index 351207e7367..fa08461a35c 100644
--- a/sql/updates/3320_worldspell_enchant_proc_data.sql
+++ b/sql/updates/3320_worldspell_enchant_proc_data.sql
@@ -6,7 +6,6 @@ CREATE TABLE `spell_enchant_proc_data` (
 ) ENGINE=MYISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Spell enchant proc data';
 
 -- Frostbrand Weapon
-
 INSERT INTO spell_enchant_proc_data (`entry`, `customChance`, `PPMChance`,`procEx`) VALUES (2, 0, 8.8,0);
 INSERT INTO spell_enchant_proc_data (`entry`, `customChance`, `PPMChance`,`procEx`) VALUES (12, 0, 8.8,0);
 INSERT INTO spell_enchant_proc_data (`entry`, `customChance`, `PPMChance`,`procEx`) VALUES (524, 0, 8.8,0);
@@ -15,4 +14,4 @@ INSERT INTO spell_enchant_proc_data (`entry`, `customChance`, `PPMChance`,`procE
 INSERT INTO spell_enchant_proc_data (`entry`, `customChance`, `PPMChance`,`procEx`) VALUES (2635, 0, 8.8,0);
 INSERT INTO spell_enchant_proc_data (`entry`, `customChance`, `PPMChance`,`procEx`) VALUES (3782, 0, 8.8,0);
 INSERT INTO spell_enchant_proc_data (`entry`, `customChance`, `PPMChance`,`procEx`) VALUES (3783, 0, 8.8,0);
-INSERT INTO spell_enchant_proc_data (`entry`, `customChance`, `PPMChance`,`procEx`) VALUES (3784, 0, 8.8,0);
+INSERT INTO spell_enchant_proc_data (`entry`, `customChance`, `PPMChance`,`procEx`) VALUES (3784, 0, 8.8,0);
\ No newline at end of file
diff --git a/sql/updates/3323_world_spell_proc_event.sql b/sql/updates/3323_world_spell_proc_event.sql
index e1ed1649994..ab87f8b0e53 100644
--- a/sql/updates/3323_world_spell_proc_event.sql
+++ b/sql/updates/3323_world_spell_proc_event.sql
@@ -1,4 +1,4 @@
 -- Glyph of Ice Block --
 DELETE FROM `spell_proc_event` WHERE `entry` = 56372;
 INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES
-(56372, 0x00, 3, 0x00000000, 0x00000080, 0x00000000, 0x00004000, 0x00000000, 0.000000, 0.000000, 0);
+(56372, 0x00, 3, 0x00000000, 0x00000080, 0x00000000, 0x00004000, 0x00000000, 0.000000, 0.000000, 0);
\ No newline at end of file
diff --git a/sql/updates/3331_world_spell.sql b/sql/updates/3331_world_spell.sql
index bbad1797eb0..f28dca08509 100644
--- a/sql/updates/3331_world_spell.sql
+++ b/sql/updates/3331_world_spell.sql
@@ -3,4 +3,4 @@ DELETE FROM spell_proc_event WHERE entry in (19615);
 
 UPDATE creature_template SET spell2 = 0 WHERE entry IN (16474,30000);
 UPDATE gameobject_template SET scriptname = 'go_najentus_spine' WHERE entry = 185584;
-UPDATE gameobject_template SET scriptname = 'go_bridge_console' WHERE entry = 184568;
+UPDATE gameobject_template SET scriptname = 'go_bridge_console' WHERE entry = 184568;
\ No newline at end of file
diff --git a/sql/updates/7823_01_mangos_item_template.sql b/sql/updates/7823_01_mangos_item_template.sql
deleted file mode 100644
index 2b3a0b314b6..00000000000
--- a/sql/updates/7823_01_mangos_item_template.sql
+++ /dev/null
@@ -1,4 +0,0 @@
-ALTER TABLE db_version CHANGE COLUMN required_7796_02_mangos_mangos_string required_7823_01_mangos_item_template bit;
-
-ALTER TABLE item_template
-CHANGE COLUMN ScalingStatValue ScalingStatValue int(6) unsigned NOT NULL default '0';
\ No newline at end of file
diff --git a/sql/world_spell_full.sql b/sql/world_spell_full.sql
index 6fb1f5aafab..11f8b411b55 100644
--- a/sql/world_spell_full.sql
+++ b/sql/world_spell_full.sql
@@ -1489,12 +1489,10 @@ INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `Spell
 (9784, 0, 0, 0, 0, 0, 0, 64, 0, 0, 0),
 (9799, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0),
 (56372, 0, 3, 0, 128, 0, 16384, 0, 0, 0, 0);
--- (42370, 0x00, 11, 0x00000080, 0x00000000, 0x00000000, 0.000000, 0.000000, 0);
 
 -- --------
 -- ENCHANT PROC
 -- --------
-
 DROP TABLE IF EXISTS `spell_enchant_proc_data`;
 CREATE TABLE `spell_enchant_proc_data` (
   `entry` INT(10) UNSIGNED NOT NULL,
@@ -1512,4 +1510,4 @@ INSERT INTO spell_enchant_proc_data (`entry`, `customChance`, `PPMChance`,`procE
 INSERT INTO spell_enchant_proc_data (`entry`, `customChance`, `PPMChance`,`procEx`) VALUES (2635, 0, 8.8,0);
 INSERT INTO spell_enchant_proc_data (`entry`, `customChance`, `PPMChance`,`procEx`) VALUES (3782, 0, 8.8,0);
 INSERT INTO spell_enchant_proc_data (`entry`, `customChance`, `PPMChance`,`procEx`) VALUES (3783, 0, 8.8,0);
-INSERT INTO spell_enchant_proc_data (`entry`, `customChance`, `PPMChance`,`procEx`) VALUES (3784, 0, 8.8,0);
+INSERT INTO spell_enchant_proc_data (`entry`, `customChance`, `PPMChance`,`procEx`) VALUES (3784, 0, 8.8,0);
\ No newline at end of file