diff options
| -rw-r--r-- | sql/updates/3601_world.sql | 10 | ||||
| -rw-r--r-- | sql/updates/3603_mangos_7896_01_world_creature_template.sql (renamed from sql/updates/7896_01_mangos_creature_template.sql) | 4 | ||||
| -rw-r--r-- | sql/updates/3609_mangos_7902_01_world_pool_creature.sql | 4 | ||||
| -rw-r--r-- | sql/updates/3609_mangos_7902_02_world_pool_gameobject.sql | 4 | ||||
| -rw-r--r-- | sql/updates/3612_world_spell_(dk).sql | 5 | ||||
| -rw-r--r-- | sql/updates/7902_01_mangos_pool_creature.sql | 4 | ||||
| -rw-r--r-- | sql/updates/7902_02_mangos_pool_gameobject.sql | 4 |
7 files changed, 17 insertions, 18 deletions
diff --git a/sql/updates/3601_world.sql b/sql/updates/3601_world.sql index 0230669b1c5..e156c1944a2 100644 --- a/sql/updates/3601_world.sql +++ b/sql/updates/3601_world.sql @@ -1,8 +1,8 @@ -UPDATE creature_template SET `VehicleId`=200 WHERE `entry` IN (28605,28606,28607); -UPDATE creature_template SET `ScriptName`='npc_salanar_the_horseman' WHERE `entry`=28653; +UPDATE `creature_template` SET `VehicleId`=200 WHERE `entry` IN (28605,28606,28607); +UPDATE `creature_template` SET `ScriptName`='npc_salanar_the_horseman' WHERE `entry`=28653; -DELETE FROM npc_spellclick_spells WHERE `npc_entry` IN (28605,28606,28607); -INSERT INTO npc_spellclick_spells (`npc_entry`, `spell_id`, `quest_id`, `quest_status`, `cast_flags`) VALUES +DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN (28605,28606,28607); +INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `quest_id`, `quest_status`, `cast_flags`) VALUES (28605, 52263, 12680, 3, 1), (28606, 52263, 12680, 3, 1), -(28607, 52263, 12680, 3, 1); +(28607, 52263, 12680, 3, 1);
\ No newline at end of file diff --git a/sql/updates/7896_01_mangos_creature_template.sql b/sql/updates/3603_mangos_7896_01_world_creature_template.sql index 51146095825..4d4ff6d6c6e 100644 --- a/sql/updates/7896_01_mangos_creature_template.sql +++ b/sql/updates/3603_mangos_7896_01_world_creature_template.sql @@ -1,4 +1,4 @@ -ALTER TABLE db_version CHANGE COLUMN required_7893_01_mangos_command required_7896_01_mangos_creature_template bit; +/*ALTER TABLE db_version CHANGE COLUMN required_7893_01_mangos_command required_7896_01_mangos_creature_template bit;*/ ALTER TABLE creature_template CHANGE COLUMN class trainer_class tinyint(3) unsigned NOT NULL default '0'; -ALTER TABLE creature_template CHANGE COLUMN race trainer_race tinyint(3) unsigned NOT NULL default '0'; +ALTER TABLE creature_template CHANGE COLUMN race trainer_race tinyint(3) unsigned NOT NULL default '0';
\ No newline at end of file diff --git a/sql/updates/3609_mangos_7902_01_world_pool_creature.sql b/sql/updates/3609_mangos_7902_01_world_pool_creature.sql new file mode 100644 index 00000000000..84aa4d90f9e --- /dev/null +++ b/sql/updates/3609_mangos_7902_01_world_pool_creature.sql @@ -0,0 +1,4 @@ +/*ALTER TABLE db_version CHANGE COLUMN required_7896_01_mangos_creature_template required_7902_01_mangos_pool_creature bit;*/ + +ALTER TABLE `pool_creature` + ADD INDEX `idx_guid`(`guid`);
\ No newline at end of file diff --git a/sql/updates/3609_mangos_7902_02_world_pool_gameobject.sql b/sql/updates/3609_mangos_7902_02_world_pool_gameobject.sql new file mode 100644 index 00000000000..27911828e55 --- /dev/null +++ b/sql/updates/3609_mangos_7902_02_world_pool_gameobject.sql @@ -0,0 +1,4 @@ +/*ALTER TABLE db_version CHANGE COLUMN required_7902_01_mangos_pool_creature required_7902_02_mangos_pool_gameobject bit;*/ + +ALTER TABLE `pool_gameobject` + ADD INDEX `idx_guid`(`guid`);
\ No newline at end of file diff --git a/sql/updates/3612_world_spell_(dk).sql b/sql/updates/3612_world_spell_(dk).sql index 59a3cf69a3c..62f8a9b8b7a 100644 --- a/sql/updates/3612_world_spell_(dk).sql +++ b/sql/updates/3612_world_spell_(dk).sql @@ -1,5 +1,4 @@ -DELETE FROM `spell_script_target` WHERE entry IN -(52124); +DELETE FROM `spell_script_target` WHERE entry IN (52124); INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES (52124, 1, 28655); -UPDATE `creature_template` SET spell1=52372,spell2=52373,spell3=52374,spell4=52375 WHERE `entry`=28406; +UPDATE `creature_template` SET spell1=52372,spell2=52373,spell3=52374,spell4=52375 WHERE `entry`=28406;
\ No newline at end of file diff --git a/sql/updates/7902_01_mangos_pool_creature.sql b/sql/updates/7902_01_mangos_pool_creature.sql deleted file mode 100644 index 309ca5e38fb..00000000000 --- a/sql/updates/7902_01_mangos_pool_creature.sql +++ /dev/null @@ -1,4 +0,0 @@ -ALTER TABLE db_version CHANGE COLUMN required_7896_01_mangos_creature_template required_7902_01_mangos_pool_creature bit; - -ALTER TABLE `pool_creature` - ADD INDEX `idx_guid`(`guid`);
\ No newline at end of file diff --git a/sql/updates/7902_02_mangos_pool_gameobject.sql b/sql/updates/7902_02_mangos_pool_gameobject.sql deleted file mode 100644 index 46524337ab7..00000000000 --- a/sql/updates/7902_02_mangos_pool_gameobject.sql +++ /dev/null @@ -1,4 +0,0 @@ -ALTER TABLE db_version CHANGE COLUMN required_7902_01_mangos_pool_creature required_7902_02_mangos_pool_gameobject bit; - -ALTER TABLE `pool_gameobject` - ADD INDEX `idx_guid`(`guid`);
\ No newline at end of file |