diff options
| author | Drahy <none@none> | 2009-05-16 02:56:39 +0200 |
|---|---|---|
| committer | Drahy <none@none> | 2009-05-16 02:56:39 +0200 |
| commit | 68a8c72041d601ba226e6f932c9cde3f4c66ca0e (patch) | |
| tree | 22ab3722c6acbb3ab14fd7a6ddba88c35d386f5d /sql/updates | |
| parent | 9b4d3bf0afc517c73410f4c55c789cb2850d71ae (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.sql | 4 | ||||
| -rw-r--r-- | sql/updates/3320_worldspell_enchant_proc_data.sql | 3 | ||||
| -rw-r--r-- | sql/updates/3323_world_spell_proc_event.sql | 2 | ||||
| -rw-r--r-- | sql/updates/3331_world_spell.sql | 2 | ||||
| -rw-r--r-- | sql/updates/7823_01_mangos_item_template.sql | 4 |
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 |
