From 1e4381f7b1ad0127257dc858ce300ded444e2664 Mon Sep 17 00:00:00 2001 From: megamage Date: Fri, 2 Jan 2009 11:03:43 -0600 Subject: *Update to Mangos 7006. --HG-- branch : trunk --- sql/updates/6970_01_mangos_playercreateinfo.sql | 7 +++++++ sql/updates/6976_01_realmd_realmd_db_version.sql | 1 + sql/updates/6976_02_characters_character_db_version.sql | 1 + sql/updates/7002_01_mangos_spell_chain.sql.obs | 9 +++++++++ 4 files changed, 18 insertions(+) create mode 100644 sql/updates/6970_01_mangos_playercreateinfo.sql create mode 100644 sql/updates/6976_01_realmd_realmd_db_version.sql create mode 100644 sql/updates/6976_02_characters_character_db_version.sql create mode 100644 sql/updates/7002_01_mangos_spell_chain.sql.obs (limited to 'sql') diff --git a/sql/updates/6970_01_mangos_playercreateinfo.sql b/sql/updates/6970_01_mangos_playercreateinfo.sql new file mode 100644 index 00000000000..a6d7747383d --- /dev/null +++ b/sql/updates/6970_01_mangos_playercreateinfo.sql @@ -0,0 +1,7 @@ +ALTER TABLE db_version CHANGE COLUMN required_6961_01_mangos_command required_6970_01_mangos_playercreateinfo bit; + +DELETE FROM `playercreateinfo` WHERE `race`=7 AND `class` IN (4,8,9); +INSERT INTO `playercreateinfo` VALUES +(7,4,0,1,-6240,331,383), +(7,8,0,1,-6240,331,383), +(7,9,0,1,-6240,331,383); diff --git a/sql/updates/6976_01_realmd_realmd_db_version.sql b/sql/updates/6976_01_realmd_realmd_db_version.sql new file mode 100644 index 00000000000..0ebbb2c82ab --- /dev/null +++ b/sql/updates/6976_01_realmd_realmd_db_version.sql @@ -0,0 +1 @@ +ALTER TABLE realmd_db_version CHANGE COLUMN required_2008_11_07_04_realmd_account required_6976_01_realmd_realmd_db_version bit; \ No newline at end of file diff --git a/sql/updates/6976_02_characters_character_db_version.sql b/sql/updates/6976_02_characters_character_db_version.sql new file mode 100644 index 00000000000..5fc19205843 --- /dev/null +++ b/sql/updates/6976_02_characters_character_db_version.sql @@ -0,0 +1 @@ +ALTER TABLE character_db_version CHANGE COLUMN required_2008_12_22_19_characters_item_instance required_6976_02_characters_character_db_version bit; \ No newline at end of file diff --git a/sql/updates/7002_01_mangos_spell_chain.sql.obs b/sql/updates/7002_01_mangos_spell_chain.sql.obs new file mode 100644 index 00000000000..1ec5c5c0333 --- /dev/null +++ b/sql/updates/7002_01_mangos_spell_chain.sql.obs @@ -0,0 +1,9 @@ +ALTER TABLE db_version CHANGE COLUMN required_6970_01_mangos_playercreateinfo required_7002_01_mangos_spell_chain bit; + +DELETE FROM `spell_chain` WHERE `spell_id` IN (51490,59156,59158,59159); + +INSERT INTO `spell_chain` VALUES +(51490,0,51490,1,0), +(59156,51490,51490,2,0), +(59158,59156,51490,3,0), +(59159,59158,51490,4,0); -- cgit v1.2.3