diff options
| -rw-r--r-- | sql/updates/3649_world.sql | 2 | ||||
| -rw-r--r-- | sql/updates/3689_TC1_1534_world.sql (renamed from sql/updates/TC1_1534_world.sql) | 3 | ||||
| -rw-r--r-- | sql/updates/3691_TC1_919_world.sql | 2 | ||||
| -rw-r--r-- | sql/updates/3715_mangos_7932_01_characters_character_pet.sql (renamed from sql/updates/7932_01_characters_character_pet.sql) | 5 | ||||
| -rw-r--r-- | sql/updates/3724_world.sql | 2 | ||||
| -rw-r--r-- | sql/updates/3729_mangos_7938_01_realmd_account.sql | 4 | ||||
| -rw-r--r-- | sql/updates/3736_world_spell_(dk).sql | 2 | ||||
| -rw-r--r-- | sql/updates/7938_01_realmd_account.sql | 4 | ||||
| -rw-r--r-- | sql/updates/919_world.sql | 3 |
9 files changed, 12 insertions, 15 deletions
diff --git a/sql/updates/3649_world.sql b/sql/updates/3649_world.sql index a75ebe7b158..4d1948c753e 100644 --- a/sql/updates/3649_world.sql +++ b/sql/updates/3649_world.sql @@ -3,4 +3,4 @@ UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_stasis' WHERE `entr UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_stasis' WHERE `entry` = 184595; UPDATE `gameobject_template` SET `ScriptName` = 'go_ethereum_stasis' WHERE `entry` BETWEEN 185461 AND 185464; -UPDATE `creature_template` SET `ScriptName` = 'npc_engineering_tele_trinket' WHERE `entry` IN (14742, 14743, 21493, 21494); +UPDATE `creature_template` SET `ScriptName` = 'npc_engineering_tele_trinket' WHERE `entry` IN (14742, 14743, 21493, 21494);
\ No newline at end of file diff --git a/sql/updates/TC1_1534_world.sql b/sql/updates/3689_TC1_1534_world.sql index cd80a785278..774e0f7ec1b 100644 --- a/sql/updates/TC1_1534_world.sql +++ b/sql/updates/3689_TC1_1534_world.sql @@ -1,3 +1,2 @@ UPDATE `creature_template` SET `ScriptName` = 'mob_ethereal_apprentice' WHERE `entry` = 18430; - -DELETE FROM `creature` WHERE `id` = 18431; +DELETE FROM `creature` WHERE `id` = 18431;
\ No newline at end of file diff --git a/sql/updates/3691_TC1_919_world.sql b/sql/updates/3691_TC1_919_world.sql new file mode 100644 index 00000000000..02e35d5a423 --- /dev/null +++ b/sql/updates/3691_TC1_919_world.sql @@ -0,0 +1,2 @@ +ALTER TABLE version + ADD `core_revision` varchar(120) AFTER `core_version`;
\ No newline at end of file diff --git a/sql/updates/7932_01_characters_character_pet.sql b/sql/updates/3715_mangos_7932_01_characters_character_pet.sql index f797a79774c..7f272c92004 100644 --- a/sql/updates/7932_01_characters_character_pet.sql +++ b/sql/updates/3715_mangos_7932_01_characters_character_pet.sql @@ -1,9 +1,8 @@ --- ALTER TABLE character_db_version CHANGE COLUMN required_7903_01_characters_character_pet required_7932_01_characters_character_pet bit; +/*ALTER TABLE character_db_version CHANGE COLUMN required_7903_01_characters_character_pet required_7932_01_characters_character_pet bit;*/ UPDATE character_pet SET abdata = CONCAT(REPLACE(TRIM(abdata),' ',' '),' '); UPDATE character_pet SET abdata = SUBSTRING_INDEX(SUBSTRING_INDEX(abdata,' ',(10-3)*2),' ',-(10-3-3)*2) - WHERE length(SUBSTRING_INDEX(abdata, ' ', 20)) < length(abdata) and length(SUBSTRING_INDEX(abdata, ' ', 21)) >= length(abdata); - + WHERE length(SUBSTRING_INDEX(abdata, ' ', 20)) < length(abdata) and length(SUBSTRING_INDEX(abdata, ' ', 21)) >= length(abdata);
\ No newline at end of file diff --git a/sql/updates/3724_world.sql b/sql/updates/3724_world.sql index 1269925e0ee..36c8a75c3d1 100644 --- a/sql/updates/3724_world.sql +++ b/sql/updates/3724_world.sql @@ -7,4 +7,4 @@ UPDATE creature_template SET `ScriptName`='npc_ros_dark_rider' WHERE `entry`=287 -- Spellclick spell to mount deathcharger DELETE FROM npc_spellclick_spells WHERE `npc_entry`=28782; INSERT INTO npc_spellclick_spells (`npc_entry`, `spell_id`, `quest_id`, `quest_status`, `cast_flags`) VALUES -(28782, 52280, 12687, 3, 1); +(28782, 52280, 12687, 3, 1);
\ No newline at end of file diff --git a/sql/updates/3729_mangos_7938_01_realmd_account.sql b/sql/updates/3729_mangos_7938_01_realmd_account.sql new file mode 100644 index 00000000000..01c16d0b0bb --- /dev/null +++ b/sql/updates/3729_mangos_7938_01_realmd_account.sql @@ -0,0 +1,4 @@ +/*ALTER TABLE realmd_db_version CHANGE COLUMN required_7867_01_realmd_account required_7938_01_realmd_account bit;*/ + +ALTER TABLE account + CHANGE id id int(11) unsigned NOT NULL auto_increment COMMENT 'Identifier';
\ No newline at end of file diff --git a/sql/updates/3736_world_spell_(dk).sql b/sql/updates/3736_world_spell_(dk).sql index c4097fef37e..4aa0c6b557c 100644 --- a/sql/updates/3736_world_spell_(dk).sql +++ b/sql/updates/3736_world_spell_(dk).sql @@ -1,3 +1,3 @@ DELETE FROM spell_area WHERE spell = 52693; INSERT INTO spell_area (`spell`, `area`, `quest_start`, `quest_start_active`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`) VALUES -(52693, 4298, 12687, 1, 12687, 0, 0, 0, 1); +(52693, 4298, 12687, 1, 12687, 0, 0, 0, 1);
\ No newline at end of file diff --git a/sql/updates/7938_01_realmd_account.sql b/sql/updates/7938_01_realmd_account.sql deleted file mode 100644 index e0658b68cd4..00000000000 --- a/sql/updates/7938_01_realmd_account.sql +++ /dev/null @@ -1,4 +0,0 @@ -ALTER TABLE realmd_db_version CHANGE COLUMN required_7867_01_realmd_account required_7938_01_realmd_account bit; - -ALTER TABLE account - CHANGE id id int(11) unsigned NOT NULL auto_increment COMMENT 'Identifier';
\ No newline at end of file diff --git a/sql/updates/919_world.sql b/sql/updates/919_world.sql deleted file mode 100644 index 7aa9fa363e6..00000000000 --- a/sql/updates/919_world.sql +++ /dev/null @@ -1,3 +0,0 @@ -ALTER TABLE version - ADD `core_revision` varchar(120) AFTER `core_version`; - |