From 600cc16c9496ec74d66e4d6b77fba085a71fd293 Mon Sep 17 00:00:00 2001 From: tobmaps Date: Tue, 31 May 2011 05:47:17 +0700 Subject: Core/Players: Pet talents can be reset at a pet trainer for free, original idea by rsa --- sql/base/characters_database.sql | 2 -- sql/updates/characters/2011_05_31_0_characters_character_pet.sql | 3 +++ 2 files changed, 3 insertions(+), 2 deletions(-) create mode 100644 sql/updates/characters/2011_05_31_0_characters_character_pet.sql (limited to 'sql') diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index ad33354aaf7..75a0723235a 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -739,8 +739,6 @@ CREATE TABLE `character_pet` ( `curmana` int(10) unsigned NOT NULL DEFAULT '0', `curhappiness` int(10) unsigned NOT NULL DEFAULT '0', `savetime` int(10) unsigned NOT NULL DEFAULT '0', - `resettalents_cost` int(10) unsigned NOT NULL DEFAULT '0', - `resettalents_time` int(10) unsigned NOT NULL DEFAULT '0', `abdata` text, PRIMARY KEY (`id`), KEY `owner` (`owner`), diff --git a/sql/updates/characters/2011_05_31_0_characters_character_pet.sql b/sql/updates/characters/2011_05_31_0_characters_character_pet.sql new file mode 100644 index 00000000000..f36bc806de7 --- /dev/null +++ b/sql/updates/characters/2011_05_31_0_characters_character_pet.sql @@ -0,0 +1,3 @@ +ALTER TABLE `character_pet` +DROP COLUMN `resettalents_cost`, +DROP COLUMN `resettalents_time`; -- cgit v1.2.3