From 23c44b2a16e0347e2f2ee61b9949b7b7a3072fb1 Mon Sep 17 00:00:00 2001 From: Shauren Date: Sun, 29 Jan 2012 18:22:50 +0100 Subject: Core/Players: Fixed talents tree specific spells to work with dual spec --- sql/updates/characters/2012_01_29_00_.characters_characters.sql | 1 - sql/updates/characters/2012_01_29_00_characters_characters.sql | 1 + sql/updates/characters/2012_01_29_01_characters_characters.sql | 2 ++ 3 files changed, 3 insertions(+), 1 deletion(-) delete mode 100644 sql/updates/characters/2012_01_29_00_.characters_characters.sql create mode 100644 sql/updates/characters/2012_01_29_00_characters_characters.sql create mode 100644 sql/updates/characters/2012_01_29_01_characters_characters.sql (limited to 'sql/updates') diff --git a/sql/updates/characters/2012_01_29_00_.characters_characters.sql b/sql/updates/characters/2012_01_29_00_.characters_characters.sql deleted file mode 100644 index baaf37ac467..00000000000 --- a/sql/updates/characters/2012_01_29_00_.characters_characters.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE `characters` ADD `talentTree` smallint(5) UNSIGNED NOT NULL DEFAULT 0 AFTER `resettalents_time`; diff --git a/sql/updates/characters/2012_01_29_00_characters_characters.sql b/sql/updates/characters/2012_01_29_00_characters_characters.sql new file mode 100644 index 00000000000..baaf37ac467 --- /dev/null +++ b/sql/updates/characters/2012_01_29_00_characters_characters.sql @@ -0,0 +1 @@ +ALTER TABLE `characters` ADD `talentTree` smallint(5) UNSIGNED NOT NULL DEFAULT 0 AFTER `resettalents_time`; diff --git a/sql/updates/characters/2012_01_29_01_characters_characters.sql b/sql/updates/characters/2012_01_29_01_characters_characters.sql new file mode 100644 index 00000000000..ae8aefc75b6 --- /dev/null +++ b/sql/updates/characters/2012_01_29_01_characters_characters.sql @@ -0,0 +1,2 @@ +ALTER TABLE `characters` CHANGE `talentTree` `talentTree` varchar(10) NOT NULL DEFAULT '0 0 ' AFTER `resettalents_time`; +UPDATE `characters` SET `talentTree`='0 0 '; -- cgit v1.2.3