diff options
author | teacher <none@none> | 2010-04-11 12:36:26 +0200 |
---|---|---|
committer | teacher <none@none> | 2010-04-11 12:36:26 +0200 |
commit | 51777d185b042b403e9b86e15aa02441dff9eccf (patch) | |
tree | b7ccd2d9dca455fed46ec415bd45947fc497127c | |
parent | dca29fa4ebf1aae715eadbe563856e0c86091aaa (diff) |
Added realmlist gamebuild default value update missing in 7849.
Added new line at the end of some files.
--HG--
branch : trunk
-rw-r--r-- | sql/updates/3.3.2_old/7827_world_script_texts.sql | 2 | ||||
-rw-r--r-- | sql/updates/7854_world_spell_ranks.sql | 2 | ||||
-rw-r--r-- | sql/updates/7857_realmd_realmlist.sql | 1 |
3 files changed, 3 insertions, 2 deletions
diff --git a/sql/updates/3.3.2_old/7827_world_script_texts.sql b/sql/updates/3.3.2_old/7827_world_script_texts.sql index a9e39adb240..eae0a06a14f 100644 --- a/sql/updates/3.3.2_old/7827_world_script_texts.sql +++ b/sql/updates/3.3.2_old/7827_world_script_texts.sql @@ -26,4 +26,4 @@ INSERT INTO `script_texts` (`npc_entry`,`entry`,`content_default`,`content_loc1` ('28684', '-1601019', 'I sense the living. Be ready.', null, null, null, null, null, null, null, null, '14084', '1', '0', '0', ''), ('28684', '-1601020', 'We are besieged. Strike out and bring back their corpses!', null, null, null, null, null, null, null, null, '14079', '1', '0', '0', ''), ('28684', '-1601021', 'We must hold the gate. Attack! Tear them limb from limb!', null, null, null, null, null, null, null, null, '14080', '1', '0', '0', ''), -('28684', '-1601022', 'The gate must be protected at all costs. Rip them to shreds!', null, null, null, null, null, null, null, null, '14081', '1', '0', '0', '');
\ No newline at end of file +('28684', '-1601022', 'The gate must be protected at all costs. Rip them to shreds!', null, null, null, null, null, null, null, null, '14081', '1', '0', '0', ''); diff --git a/sql/updates/7854_world_spell_ranks.sql b/sql/updates/7854_world_spell_ranks.sql index 60c44cd39b1..eb9be8cc979 100644 --- a/sql/updates/7854_world_spell_ranks.sql +++ b/sql/updates/7854_world_spell_ranks.sql @@ -1 +1 @@ -DELETE FROM `spell_ranks` WHERE `first_spell_id` IN (30803, 33174, 61417, 9736, 15742);
\ No newline at end of file +DELETE FROM `spell_ranks` WHERE `first_spell_id` IN (30803, 33174, 61417, 9736, 15742); diff --git a/sql/updates/7857_realmd_realmlist.sql b/sql/updates/7857_realmd_realmlist.sql new file mode 100644 index 00000000000..c71c29989d0 --- /dev/null +++ b/sql/updates/7857_realmd_realmlist.sql @@ -0,0 +1 @@ +ALTER TABLE `realmlist` CHANGE COLUMN `gamebuild` `gamebuild` int(11) unsigned NOT NULL default '11723'; |