From 6c50ac907a97128b3da83f500669ec5d878e09fb Mon Sep 17 00:00:00 2001 From: Drahy Date: Sat, 11 Apr 2009 08:18:22 +0200 Subject: * Used trinity sql coding style --HG-- branch : trunk --- sql/updates/2570_world.sql | 18 +++++++++--------- .../2582_mangos_7644_01_characters_character_pet.sql | 5 +++++ sql/updates/7644_01_characters_character_pet.sql | 5 ----- 3 files changed, 14 insertions(+), 14 deletions(-) create mode 100644 sql/updates/2582_mangos_7644_01_characters_character_pet.sql delete mode 100644 sql/updates/7644_01_characters_character_pet.sql (limited to 'sql/updates') 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; -- cgit v1.2.3