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/base/characters_database.sql | 2 +- 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 ++ 4 files changed, 4 insertions(+), 2 deletions(-) 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') diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 5cd0db50dcb..df935c184d2 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -1127,7 +1127,7 @@ CREATE TABLE `characters` ( `rest_bonus` float NOT NULL DEFAULT '0', `resettalents_cost` int(10) unsigned NOT NULL DEFAULT '0', `resettalents_time` int(10) unsigned NOT NULL DEFAULT '0', - `talentTree` smallint(5) unsigned NOT NULL DEFAULT '0', + `talentTree` varchar(10) NOT NULL DEFAULT '0 0', `trans_x` float NOT NULL DEFAULT '0', `trans_y` float NOT NULL DEFAULT '0', `trans_z` float NOT NULL DEFAULT '0', 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