diff options
| author | Drahy <none@none> | 2009-04-11 08:18:22 +0200 |
|---|---|---|
| committer | Drahy <none@none> | 2009-04-11 08:18:22 +0200 |
| commit | 6c50ac907a97128b3da83f500669ec5d878e09fb (patch) | |
| tree | a900c94ddc5113dc51a46f05a7e038f1ec4c8f53 | |
| parent | 7f0e951104b1bf22eb38c4fc455f58e4058acefc (diff) | |
* Used trinity sql coding style
--HG--
branch : trunk
| -rw-r--r-- | sql/updates/2570_world.sql | 18 | ||||
| -rw-r--r-- | sql/updates/2582_mangos_7644_01_characters_character_pet.sql | 5 | ||||
| -rw-r--r-- | sql/updates/7644_01_characters_character_pet.sql | 5 |
3 files changed, 14 insertions, 14 deletions
diff --git a/sql/updates/2570_world.sql b/sql/updates/2570_world.sql index 38d6e763693..0d87bfc80e8 100644 --- a/sql/updates/2570_world.sql +++ b/sql/updates/2570_world.sql @@ -1,9 +1,9 @@ -INSERT INTO `spell_linked_spell` VALUES (47988, 54501, 2, 'Consume Shadows - Rank 9'); -INSERT INTO `spell_linked_spell` VALUES (47987, 54501, 2, 'Consume Shadows - Rank 8'); -INSERT INTO `spell_linked_spell` VALUES (27272, 54501, 2, 'Consume Shadows - Rank 7'); -INSERT INTO `spell_linked_spell` VALUES (17854, 54501, 2, 'Consume Shadows - Rank 6'); -INSERT INTO `spell_linked_spell` VALUES (17853, 54501, 2, 'Consume Shadows - Rank 5'); -INSERT INTO `spell_linked_spell` VALUES (17852, 54501, 2, 'Consume Shadows - Rank 4'); -INSERT INTO `spell_linked_spell` VALUES (17851, 54501, 2, 'Consume Shadows - Rank 3'); -INSERT INTO `spell_linked_spell` VALUES (17850, 54501, 2, 'Consume Shadows - Rank 2'); -INSERT INTO `spell_linked_spell` VALUES (17767, 54501, 2, 'Consume Shadows - Rank 1'); +INSERT IGNORE INTO `spell_linked_spell` VALUES (47988, 54501, 2, 'Consume Shadows - Rank 9'); +INSERT IGNORE INTO `spell_linked_spell` VALUES (47987, 54501, 2, 'Consume Shadows - Rank 8'); +INSERT IGNORE INTO `spell_linked_spell` VALUES (27272, 54501, 2, 'Consume Shadows - Rank 7'); +INSERT IGNORE INTO `spell_linked_spell` VALUES (17854, 54501, 2, 'Consume Shadows - Rank 6'); +INSERT IGNORE INTO `spell_linked_spell` VALUES (17853, 54501, 2, 'Consume Shadows - Rank 5'); +INSERT IGNORE INTO `spell_linked_spell` VALUES (17852, 54501, 2, 'Consume Shadows - Rank 4'); +INSERT IGNORE INTO `spell_linked_spell` VALUES (17851, 54501, 2, 'Consume Shadows - Rank 3'); +INSERT IGNORE INTO `spell_linked_spell` VALUES (17850, 54501, 2, 'Consume Shadows - Rank 2'); +INSERT IGNORE INTO `spell_linked_spell` VALUES (17767, 54501, 2, 'Consume Shadows - Rank 1');
\ No newline at end of file diff --git a/sql/updates/2582_mangos_7644_01_characters_character_pet.sql b/sql/updates/2582_mangos_7644_01_characters_character_pet.sql new file mode 100644 index 00000000000..c9713aeb4b5 --- /dev/null +++ b/sql/updates/2582_mangos_7644_01_characters_character_pet.sql @@ -0,0 +1,5 @@ +/*ALTER TABLE character_db_version CHANGE COLUMN required_7546_01_characters_uptime required_7644_01_characters_character_pet bit;*/ + +/* only hunter pets must be in stable */ +UPDATE `character_pet` + SET slot = 100 WHERE PetType <> 1 AND slot >= 1 AND slot <= 4;
\ No newline at end of file diff --git a/sql/updates/7644_01_characters_character_pet.sql b/sql/updates/7644_01_characters_character_pet.sql deleted file mode 100644 index 03e38a0d8eb..00000000000 --- a/sql/updates/7644_01_characters_character_pet.sql +++ /dev/null @@ -1,5 +0,0 @@ -ALTER TABLE character_db_version CHANGE COLUMN required_7546_01_characters_uptime required_7644_01_characters_character_pet bit; - -/* only hunter pets must be in stable */ -UPDATE `character_pet` - SET slot = 100 WHERE PetType <> 1 AND slot >= 1 AND slot <= 4; |