aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorDrahy <none@none>2009-05-16 02:56:39 +0200
committerDrahy <none@none>2009-05-16 02:56:39 +0200
commit68a8c72041d601ba226e6f932c9cde3f4c66ca0e (patch)
tree22ab3722c6acbb3ab14fd7a6ddba88c35d386f5d /sql/updates
parent9b4d3bf0afc517c73410f4c55c789cb2850d71ae (diff)
* Used trinity sql coding style
--HG-- branch : trunk
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/3314_mangos_7823_01_world_item_template.sql4
-rw-r--r--sql/updates/3320_worldspell_enchant_proc_data.sql3
-rw-r--r--sql/updates/3323_world_spell_proc_event.sql2
-rw-r--r--sql/updates/3331_world_spell.sql2
-rw-r--r--sql/updates/7823_01_mangos_item_template.sql4
5 files changed, 7 insertions, 8 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